Does braapf_variation_attributes update automatically with new products?

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

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.

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.

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.

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