Slow loading page


Was having issues with pages being slow to load (around 16 seconds). Assumed issue was that I was still using sqlite. Migrated to mysql. Now page is taking approx 20 seconds!

Have run tests and issue is definitely in the reading from the database. I'm populating a table with about 7000 cells, so maybe this is right - am pretty new to all this - but still confused why mysql would be slower??

Thanks in advance for any advice you can offer.

There are many reasons that MySQL could be slower. In general, they will be related to your query - the most likely is that you're making a join that creates a large result set to return.

Thanks for your response. Led me to learn about search optimization and slashed the load time to about 3 seconds.

That's excellent!