Plugin Author
RazyRx
(@razyrx)
Hello,
Plugin do not have any possibility to change from outside how it is generates. You can only edit file in plugin and change it.
The file is /addons/additional_tables/additional_tables.php and lines that limit each request are
$end_id = $start_id + 5000;
and
$end_id = $start_id + 10000;
Where 5000 and 10000 is number of rows from database.
Regards,
Oleg
Can you more explain what the solution is?
i have the exact same problem…
Thx
Greets,
Jeroen
Hello Jeroen,
Edit file /addons/additional_tables/additional_tables.php in the plugin folder.
Search for $end_id = $start_id + 5000; and change to $end_id = $start_id + 20000;
Search for $end_id = $start_id + 10000; and change to $end_id = $start_id + 50000;
Save file and try it. Reload tables with this steps: turn on addon, save settings, turn on addon, save settings. Check the difference.
Regards,
Dima
When i change it next error comes:
wp-content/plugins/woocommerce-ajax-filters/addons/additional_tables/additional_tables.php on line 1
any idea’s?
thx for the fast reactions
greets,
Jeroen
Tested, and additional tables are generating in a fraction of the time.
Thank you.
Plugin Author
RazyRx
(@razyrx)
Hello, @jgabjanssen,
You provide only file where you have error, but what exactly error you have?
Regards,
Oleg
@richardgeorgedavis, could you tell please how much faster?
Maybe we would add some option to control this by the clients if result is noticeable.
Regards,
Dima
@dholovnia with the tests performed before and after there was a huge difference for processing 12281 records.
Before making your suggested changes, the average time was around 8 hours and now it’s less than an hour.
Just a note for anyone else with a large number of records to process, the Woocommerce limits should also be changed however, these all depend on your hosting resources – if you exceed resources your site will crash so use a test Environment or staging server first.
I have just further tested the function on a test website. Problem fixed. It’s about 30 minutes now. instead all day .. Adding these options in the plugin would certainly be an addition
I have created a request for this feature already. We will add it asap.
Regards,
Dima
Hi guys,
is it possible to raise the numbers futher on for speed?
Looks like it takes an hour. however it seems that I have to be logged in for this … but in the meantime the page is not accessible.
Hi,
Sure. You can set there any numbers but if memory will be not enough to manage all the rows per execution it will stuck. Just change the numbers to something smaller and re-activate the tables plugin.
Regards,
Dima
Hi,
I see the new 3.0.3 update includes “New hook to change additional table generation products per call”.
Could you assist with the function required?
Hi
There are 2 hooks
berocket_insert_table_braapf_product_stock_status_parent_end – default value is 5000
berocket_insert_table_braapf_product_variation_attributes_end – default value is 10000
Functions should look like this:
add_filter('berocket_insert_table_braapf_product_stock_status_parent_end', 'berocket_insert_table_braapf_product_num_end_487rg348734');
function berocket_insert_table_braapf_product_num_end_487rg348734() {
return 50000; //x10
}
add_filter('berocket_insert_table_braapf_product_variation_attributes_end', 'berocket_insert_table_braapf_product_num_end_8437g349g34t');
function berocket_insert_table_braapf_product_num_end_8437g349g34t() {
return 100000; //x10
}
Regards,
Dima
