[y2ksw]

Originally Posted by cylon1

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:

# 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.

Not that I can think of. A server should really ahve more than 512 MB of RAM, specially when using a database server, too. You may try to add some MB to the MySQL key buffer, but I doubt it will help.