Slow MYsql database on just the first query

My search engine lags on first query

[MrSchmidt]

I operate a small nich search engine with about 22,200 pages indexed. When I go to do a query, it takes sometimes 30-40 seconds to return the results. Then if I do another query, it returns results in 1-2 seconds and the same for every query after that. But if I let it go 15 minutes without any activity, it'll go to lagging on the next query.

My webhost says it's me, but if I try to login to my cPanel when the query is lagging, the login lags also and then the second I get logged in, the query returns results.

Is there anything I can tell my webhost to tweak the mysql so I connect to the mysql server faster.

Thanks,
ED

[jatar_k]

seems strange, maybe just a slow to respond db server but I am not really sure.

Anyone else have any ides?

[henry0]

Have you tried uploading a simple PHP test page with a simple query returning just one item such as user_ID ASC LIMIT 1 for example?

Is that one slower than expected?

I have seen the exact same query taking about 3 times the same times with a well known host than in another host where I run most of my sites

so yes I would think that a given host is responsible, at least part-responsible for loading up speed.

<edit>typo</edit>