显示记录的性能问题

Question

I have a table with just 3,000 records.
I render these 3000 records in the home page without pagination, my client is not interested in pagination...

So to show page completely it takes around 1 min, 15 sec. What can be done to make the page load more quickly?

My table structure:

customer table

• customer id
• customer name
• guider id
• and few columns

guider table

• guider id
• guider name
• and few columns

Answer 1

Where's the slow down? The query or the serving?

If the former, see the comments above. If the latter:

Enable gzip on the server. Otherwise capture the [HTML?] output to a file, compress it (zip), then serve it as a download. Same for any other format if you think something else can render it better than a browser (CSV and Open Office).

If you're outputting the data into a HTML table then you may have an issue where the browser is waiting for the end of the table before rendering it. You can either break this into multiple table chunks like every 500 records/rows or try CSS "table-layout: fixed;".