php mysql improve loading time
I have a page displaying horse racing data. With a database over a GB.
Depending on how much data is displayed, the page can take up to 1 mn to
fully display. It's faster if I remove one row where I have lots of
calculation and mysql queries, but it impact my end users.
What would be your advice to load the page faster?
My last thought is to display the page without the heavy calculation. And
then make an AJAX call (user clicks a button) to calculate the data and
display it.
Any other idea?
Thank you
No comments:
Post a Comment