Does braapf_variation_attributes update automatically with new products?

edigermatthew
(@edigermatthew)

2 years, 11 months ago

Running a product import script with a bunch of products.. It runs much slower with BR Advanced Ajax Product Filters active.

I check the mysql processes and it was inserting into braapf_variation_attributes every time, I believe, and taking forever. I have the data cache off and thought that I had the plugin active while uploading before.. but it is definitely making importing new products much slower now.

Hoping one of the plugin developers can confirm this happens when new variable products are created, and if there is a way around this.

Thanks.

Viewing 5 replies - 1 through 5 (of 5 total)

Plugin Author RazyRx
(@razyrx)

2 years, 10 months ago

Hello @edigermatthew,

Yes, plugin update braapf_variation_attributes table automatically when variable product created or updated with new data, because this table uses to speed up some features and plugin can work incorrect without this update.
We did not get any message about speed issue with importing products before.

What tool do you uses to import products?

Regards,
Oleg

Thread Starter edigermatthew
(@edigermatthew)

2 years, 10 months ago

Hi Oleg,

It is just my own script.. uses ajax to parse through a csv file creating products and variations programmatically via php. There are already 200k (600k with variations) and we were hoping to keep uploading while using the site (with aapf) but it has slowed the uploads to a crawl. Might have to explore a different plugin to run simultaneously for the time being. Probably not a speed issue for a more normal usage.

Thread Starter edigermatthew
(@edigermatthew)

2 years, 10 months ago

I ended up changing the db table’s storage engine to MyISAM and repaired it and optimized it. Not overly familiar with that stuff but it helped or fixed my problem! I’m going to watch it but running much more as expected.

Thread Starter edigermatthew
(@edigermatthew)

2 years, 10 months ago

I don’t know how to go back and delete posts or whatever..

Changing the storage engine didn’t end of solving everything. I believe I had the plugin off while lots of products were imported, possibly, and that the db tables needed updated. I had to manually delete these tables so when I went to the plugin, it automatically recreated the databases so I thought things would be good..

However, when trying to visit shop page with filters enabled, it just spends forever doing mysql ‘statistics’ stuff and times out.

Optimized the server and it has lots of memory and a large sql pool cache, so I’m out of ideas now.

Plugin Author RazyRx
(@razyrx)

2 years, 10 months ago

Hello @edigermatthew,

To regenerate tables you need in plugin settings -> Add-ons tab disable “Additional tables” add-on and Save settings, then enable it back and Save settings.

Regards,
Oleg

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Does braapf_variation_attributes update automatically with new products?’ is closed to new replies.

Views