MySQL is extremely slow... sometimes

shawjames

Hello,
I have some scripts that make 50+ queries to my SQL database. The speed is not very fast, as expected... but sometimes it takes forever, or cannot complete without a page timeout. It is strange, sometimes it goes fast... other times it cannot run at all for days.

I have recently switched my webhost to iPower.com, and I seem to have more of these problems then before.

My question is, can this be helped by switching to another provider or by getting a different class of webhost service?

I have made the assumption that it is not my script that is the problem, because it has not changed. I figure it must be the webhost.

Any suggestions? I have tried contacting support, but they are no help...

Cheers!
-Shaw

_RL_Ian

shawjames wrote:
Hello,
I have some scripts that make 50+ queries to my SQL database. The speed is not very fast, as expected... but sometimes it takes forever, or cannot complete without a page timeout. It is strange, sometimes it goes fast... other times it cannot run at all for days.

I have recently switched my webhost to iPower.com, and I seem to have more of these problems then before.

My question is, can this be helped by switching to another provider or by getting a different class of webhost service?

I have made the assumption that it is not my script that is the problem, because it has not changed. I figure it must be the webhost.

Any suggestions? I have tried contacting support, but they are no help...

Cheers!
-Shaw

Hey Shaw,

There are a few reasons why your queries might be acting up.

1.) You have a slow server (which you said).
2.) You might not be using Indexes and primary keys on your tables.
3.) You may not be joining your tables correctly in your queries.

Lots of times you could combine multiple queries into one if you join them correctly, so take a look at any place where you have the opportunity to join them.

If you want, post your queries here and I'll take a look at them.