- Sep 26, 2018
- 241
- 374
I believe I can help you with that. I can see there are two large optimisations you can make.yeah, it was too slow, i'll find a solution...
Thank you for the useful tips, i'm actually using Smush image plugin, i through to convert all image from jpg to webp. for the second tip I just using redis, that should help to reduce database connection, I think the real problem is the poor image optimization...I believe I can help you with that. I can see there are two large optimisations you can make.
First is the bandwidth usage - You're displaying full-sized images on the index pages that are scaled down within the HTML. This requires each visitor to download large images even if they are not interested in visiting the detailed page. You should consider having properly resized images for the index pages, and gain a drastic reduction in bandwidth usage.
Second is that you are accessing the database for every page. There is a limit (one you may be able to increase) to how many concurrent open connections to the database. A "temporary" solution to this would be to increase this limit if you can, and if you have enough RAM that would allow it to happen smoothly. The more ideal solution would be to have Static HTML pages created for each product detail page (not access the database at all).
Welcome back!Thank you for the useful tips, i'm actually using Smush image plugin, i through to convert all image from jpg to webp. for the second tip I just using redis, that should help to reduce database connection, I think the real problem is the poor image optimization...
That looks like it ought to work wonders.you should try thisYou must be registered to see the links
I tried them all, I'm about to give up... I don't understand why it's still slow...That looks like it ought to work wonders.
Another potential solution to the image problem is to just offload that problem to a third-party image hosting site.