Question Locked

Open large mySQL table from a LAN very slow

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

hi,

we have a table that grows more or less 12000 records a day, everytime we open it in our application we have to wait for more than a minute or so. currently the table is around 230,000 records.

any suggestions on how we can speed things up?

thank you,
ocavid

2 replies

by tony hopkinson

Mysql has a log option for slow queries.

If you run the app on the server itself, is it appreciably faster ? .

It could be something pretty strange, but usually this turns out to be really bad design, such as something doing Select * from Table,

ie sucking up all 230,000 records and then processing them on the client.....

This discussion is closed to new replies.