I have installed mysql 3.23.28, with myodbc 2.50.36 on my Windows 98
computer for a few months now, using PWS as my web server. I am only using
this setup for testing of
my scripts before uploading them to my server. It has been working well and
a considerable speed increase over an access database I was using before.
I have a forum software on my computer that utilizes the mysql database.
Since
recently, when I access the forum software, the mysql server reads the
hardrive for at least 1 minute before displaying the page. This goes for all
pages I access in the forum software and any script I access, outside of the
forum software. So I know it's not just the forum. It didn't take so long to
read the database before. It took less than 1 second on most pages, less
than 5 seconds on longer sql queries. But now it takes forever.
I have tried re-installing mysql but that didn't work. The sql queries are
nothing intensive. Simple query commands returning very little data. With
this problem, mysql now takes longer than an access database.
Anyone has any suggestions on how I can fix this problem?