What I would do:
- I would add pagination (as @Willem Van Onsem suggested) just load the first 100 (for example) samples and add link to paginate over the table (next/previous). Take a look at Django Paginator.
- If you want to show some information about the whole dataset, I would compute statistics describing the data and display it instead of whole data. For example mean values, or median values …
If you really want to make it faster with the whole table:
- You can try to use a faster server (maybe will help a little),
- You can try to cache it, maybe store the data in the memory so you don’t need to run DB query for each request (but you need to remember to refresh/validate the cache).
CLICK HERE to find out more related problems solutions.