[Plugin: WP-Table Reloaded] Searching within tables

  • joesamcoke

    (@joesamcoke)


    12 years, 2 months ago

    I’ve recently upgraded my wordpress and the table reloaded plugin. This has caused some major cpu spikes on my server. I tracked the problem down to an sql query that kept hanging for ages. The query seems to be for searching posts. Looking at the query, there was a regex trying to match with over 1000 table id’s. The search term was very commonly found on the site in posts and tables. Is it possible to stop the search function searching within tables?

    http://wordpress.org/extend/plugins/wp-table-reloaded/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    12 years, 2 months ago

    Hi,

    thanks for your report.

    Yes, that query is likely coming from WP-Table Reloaded. To turn this feature off, just uncheck the corresponing checkbox (“WordPress Search”) on the “Plugin Options” screen of WP-Table Reloaded.

    And just out of interest: Could you share some more details on this? That would maybe help in optimizing this feature. Do you think that the spike is just a result of the large number of tables?

    Thanks,
    Tobias

    Thread Starter joesamcoke

    (@joesamcoke)

    12 years, 2 months ago

    Thanks for that – can’t believe I missed !

    As I mentioned the search terms were very generic for our site and would have been in upto 2500 posts and upto 1000 tables so may just be that.

    The strange thing is we use google custom search on the front end of the site so I initially assumed it was one of the editors on the back end of the site performing these searches/spikes. However (unless it’s a coinicence) when I disabled the checkbox (“WordPress Search”) on the “Plugin Options” screen of WP-Table Reloaded the overall cpu usage dropped off?

    Plugin Author TobiasBg

    (@tobiasbg)

    12 years, 2 months ago

    Hi,

    thanks for these insights. Yes, that big number of posts and tables sounds like a possible reason.

    Really interesting that this seems to happen although you are using Google Custom Search… Maybe someone is doing direct queries by appending the ?s= parameter to URL?
    I don’t really have an explanation on why overall CPU usage went down after this change though. I guess, I’ll have to dive into that part of the code again. Maybe I missed something so that a search query is built although it was not necessary.

    Best wishes,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘[Plugin: WP-Table Reloaded] Searching within tables’ is closed to new replies.