I'm running a copy of MySQL database on our web server - this is not a dedicated MySQL server, but the one web application that pulls data from this db has really poor performance.
I inherited this whole mess from another developer. I can understand large, complex connections on a shared server could be problematic, but I'm talking like 15 seconds to load 700 records.
I know next to nothing about this database, but was wondering what are the general things I should look at to "compact-repair" the db, recommended cache settings, etc.
Can anyone suggest what might be going on here? Or some remedies?
This is on a Windows Server 2003 box with all the latest updates. MySQL database has approximately 20 tables, most of them holding only a few columns and a few records.
I've also confirmed on the old website that performance was slow, and now our new code for their new website is sluggish too, so I do think it's the db.