I have a site with approx 6500 products. The are constantly running into problems where they run up against the hosting companies PHP Process limit.
I have been running a SQL profiler against their site today and came up with the following slow queries:
is_processed = '0' (13s)
The next slow query is the actual search on the catalog search query table. (78,000 rows)
My question: Can I truncate this table?
Here are all the queries by threads during the day in order of slowness