And please give us the tabledefinition and indexes too.
Thimble Smith wrote:
> MySQL can handle tables with millions of rows, and 20,000 should pose
> no problem.
> If you send us the output of EXPLAIN on the slow queries, and also
> how many rows are returned and how many rows are in each table, we
> should be able to help out.
> At 15:03, 19990804, Craig Vincent wrote:
> >I'm running a mailing list organizer using mysql.
> >One table now has grown to over 20,000 records and since then queries and updates
> are taking 5-6 seconds if not more before completion.
> >Are there anyways to optimize the database or perhaps use a ramdrive to help
> improve the speed of the queries?
> >Craig Vincent