Dear friends:
This extension is amazing, I use it since months, and all works very well. The only problem is that, I'm using a vps with limited resources (apache, 512Mb ram). I've noticed that one of the slowest sql in my vps is the following:
Code:
# Query_time: 16.976461 Lock_time: 0.000214 Rows_sent: 0 Rows_examined: 278721
SET timestamp=1356435021;
SELECT postid, dateline, pagetext
FROM post
WHERE iei_parsed=0
AND pagetext LIKE '%[/IMG]%'
ORDER BY postid
LIMIT 0, 5;
As you can see, my posts table has only 278721 rows. I think this is a small forum, I suppose that there will be bigger forums out there. But you can see too, that the query time is very high (16sg). I have discarded another problem (very much visits, and so on).
Is there a way to increase the perfomance of this query?
Best regards and thanks in advance.