I got over 1M+ images on my site. Now every time someone opens explore it kind of brings down my site. I reduced listing images to 50 from earlier 100. But still CPU is hitting 100% when opening explore. Most of the CPU usage goes to mysql process. Also the site now through Nginx timeout when this happens.
I believe this is due to database query on a large database table. The database size is around 1.3GB now. I am considering moving database to cloud to ease the load on server. But not sure if it is going to solve the issue or would require some database optimization.
Anyone able to provide any expert advise on this would appreciated.
I believe this is due to database query on a large database table. The database size is around 1.3GB now. I am considering moving database to cloud to ease the load on server. But not sure if it is going to solve the issue or would require some database optimization.
Anyone able to provide any expert advise on this would appreciated.