Are random queries bad?

[DeZiner]

I recently moved from NT / Access to Linux/MySql. I run a query to pull 5 random records. I query and pull data from 3 columns on these random queries. The database is approaching 10,000 records with about 15 columns.

The query used to not take anytime. Since our move it takes 8-12 seconds.

Any thoughts on what I can have my host check or tune? Is the database too big? DeZiner
Never be afraid to try something new.
Remember that amateurs built the Ark.
Professionals built the Titanic

 

[GunJack]

It sounds like a performance issue with either your host's server or possibly with MySql. From what I've read, MySql is a good database but still has limitations and is not quite ready for real production environments. If the host's server is an adequate machine, you may just be dealing with limitations of MySql.

I would bring it to their attention and ask them why the query takes longer to run than the previous environment. In my opinion, 10,000 records isn't that big of a recordset to cause performance problems.

Good luck,
GJ