Quote:Can anybody suggest how to reduce the time for fetching
- Get faster server, faster storage.
- Optimize database (database design), indexes
- Get faster network
- Reduce size of data to load on page.
Without indication of what is this database, optimization is on your own, DataBase Design is a job on its own.
Loading 200000 records on a web page is a bad idea in 99.99% of time.
There is no magic to speedup the queries.