in mysql database i implemented simple query on 1 like select * from dbo.company limit 2 .it taking tomuch time.except that table remaning all tables are working well. in that table records also very less.i try to editing,droping,deleting any thing i
-
in mysql database i implemented simple query on 1 like select * from dbo.company limit 2 .it taking tomuch time.except that table remaning all tables are working well.
in that table records also very less.i try to editing,droping,deleting any thing it is not responding.any one know answer Please give answer. -
in mysql database i implemented simple query on 1 like select * from dbo.company limit 2 .it taking tomuch time.except that table remaning all tables are working well.
in that table records also very less.i try to editing,droping,deleting any thing it is not responding.any one know answer Please give answer.Member 9671482 wrote:
Please give answer.
Fetching a lot of data takes a lot of time. There's no cure for that, other than fetching less. Here's some idea's you can try if you need more speed;
- verify and update the indexes (what fields are you using in your search?)
- look into (horizontal) paritioning
- select fewer columns (are you really using them all?)
- execute the optimize table[^]-command to compact the table (if deleted a lot recently)
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]