I've got a database with 17 tables. Several of the tables have about 350 records and contain no more than 12 fields per table. When I run a 'select' query on a table, it never displays the data. Trust me, the query is ok as I've done it many many times. However, when I do a 'select field1 from table1 where field2 = 'blah' the result is given at a normal speed.
I can also run a 'select * from table1 where field1 between '1' and '38'...38 being the highest # of records that can be displayed at once. The db has been running slowly growing at a rate of about 20 records a week. I had to take down a tool on an application that's using the tables...
not good at all.
Any ideas as to why mysql would freak out like this at only 350 records and displaying only 38 records at a time?
Any help is much appreciated.
Thanks so much, dave.
I can also run a 'select * from table1 where field1 between '1' and '38'...38 being the highest # of records that can be displayed at once. The db has been running slowly growing at a rate of about 20 records a week. I had to take down a tool on an application that's using the tables...
not good at all. Any ideas as to why mysql would freak out like this at only 350 records and displaying only 38 records at a time?
Any help is much appreciated.
Thanks so much, dave.