These are chat archives for collectiveaccess/support

24th
Apr 2018
TBthegr81
@TBthegr81
Apr 24 2018 09:23

@collectiveaccess Another issue, when loading any of our Providence websites it's super slow and I have tracked the problem down to the MySQL table ca_sql_search_word_index.
I view what the database is doing via MySQL Workbench and I can see a bunch of Inserts and Deletes into this table before the server responds with the webpage.
These write/deletes runs for about a minute before it stops, then you can use the site as intended for a while until it decides it needs to do it all over again.

So my question is, what is this table for? I am assuming to cache searches and make them faster, but why does it behave the way it does and can we turn the search word indexing off in some way?