woof_query_cache table
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday. If you have problems with registration ask help on contact us page pleaseIf you not got email within 24~36 business hours, firstly check your spam box, and if no any email from the support there - back to the forum and read answer here. DO NOT ANSWER ON EMAILS [noreply@pluginus.net] FROM THE FORUM!! Emails are just for your info, all answers should be published only here.
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday.
at this moment my db is almost 1000MB with some plugins using a lot of resources and i am trying to move some plugins to other dbs
For each db the max size is 1000MB.
Can we move the table woof_query_cache or any other woof table to another mysql database on the same hosting and configure plugin to retrieve the data from that db?
the new db will contains only tables that has to do with woof filter.
Hello
In this case, you need to customize the plugin code
how can we customise it. you will provide instructions?
does this will be affected by updates from woocommerce or woof plugins?
Hello
You should change your database queries in file( https://share.pluginus.net/image/i20220404093323.png ) - wp-content\plugins\woocommerce-products-filter\classes\counter.php
If i have understand correct,
i have to edit the file counter.php at 3 positions(line 28,76,89) the $this->table to newdbname.wp_9xjjzhfdqy_woof_query_cache.
i have to do it like that?
Hello
Yes/ you should reconnect these queries to another database
And chenge a code in( https://c2n.me/4flvAhz.png ) - wp-content\plugins\woocommerce-products-filter\views\plugin_options.php
in fact you need to change this variable - global $wpdb;
it should be as below or is wrong. is the newdatabase name and plus the woof table.
is this correct?
Hello
it is not correct! You just changed the name of the table, which in fact does not make any sense
You should make a connection to another database - https://c2n.me/4fm97ho.png
i have to changed it as below to both files(plugin_options.php, counter.php)?
global $wpdb->select('database_name');
Hello
global $wpdb->select('database_name'); - so you break the whole site
You should hire a developer
Better use PDO class
Read this - https://stackoverflow.com/questions/23811628/wordpress-and-pdo-compatibility
can you handle this?
If you can, send me a direct email to my personal email address.
Hello
Unfortunately I don't have time for custom tasks