MySQL with 68,492 records... Slow
I'm running MySQL on a windows NT 4 server, and it's been running like a dream until I imported a database with close to 70,000 unique records in it.
The database itself takes up right around 9 mb, and every query I make to the larger tables times out and slows my web server to a crawl. I'm using MyISAM tables and the most recent non beta release of MySQL.
Is there anything I can do to make these queries faster? Could modifying the table type improve performance? If so what table type do you recomend?
This is an enterprise envirenment, and the release notes on the newer version of MySQL advised against using the beta version in a mission critical setting. Has anyone tried this? What kind of results did you have?
Thanks for the help.
