[TYPO3] Slow query
lukasnoname at yahoo.com
Wed Sep 27 15:42:55 CEST 2006
My web hotel gave me an alert for a slow SQL query that took 16 seconds.
When I ran the same question in PHPmyAdmin, it took 6 seconds, which is
shorter but still pretty long.
I guess the query came from macina-searchbox. How can I speed it up?
Here's the query:
FROM index_words IW,
IW.baseword LIKE '%Ã¤ngsholmmen%'
AND ISEC.phash = IR.phash
AND ISEC.rl0 IN (130)
GROUP BY IR.phash;
Best regards, Lukas
More information about the TYPO3-english