Thank you for using our plugin @rahe
May I ask how many tables you have on your database? Just trying to understand how long the plugin is taking (we have some users with more than thousand sites on a multisite and have no issues).
I will also look into why we are using the query and see how we can improve it.
In regards to the logger, just to confirm, so you are writing directly to Cloudwatch and not on the WordPress database? If that’s the case, I’d like to learn more about your setup. Would appreciate if you can send me more details at robert@wpwhitesecurity.com
Looking forward to hearing from you.
Hello,
I have 3101 tables for 59 sites, these calls can take 100ms of query displayed on query monitor.
Maybe the SQL server have some issues.
But these are useless calls in my case, maybe a filter or something else ?
Nicolas,
That´s a lot of tables! We will certainly look into this issue to see why the Show Tables is used and if we can do without it or replace it with something else @rahe
Thank you for reporting this.
Hello @rahe
We have a positive update for you. Today we discussed this / looking into this and can confirm that in some cases we need show tables in some others it has been added as part of a “template”.
We are going to remove it from where it is not needed. We will also see how we can optimize the queries where it is needed (this is basically needed for the plugin to detect table changes). However, there are many things we can do here, such as, move the database changes detection to the background etc.
Anyway, just thought that you’d be happy to hear this update. Thank you again for using and supporting our plugin.
Hello,
This is great news, thank you very much 🙂
I’m looking forward for the updates.
BTW, do you have received my email about CloudWatch ?
Nicolas,
You’re welcome @rahe
We have received your email about CloudWatch and just replied to it yesterday. Sorry for the delayed response Nicolas.
Have a good day.