Do all the things like ++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatarSign Up
Voxera640270dAs long as we learn its never a complete loss.
And when something is slow and there is a database involved, start looking at it, its very often involved.
And finally, always keep track on any third party plugins, some are very good but some are not worth the space on the harddrive.
And to often some do mot work well with other plugins.
ErvinSabic49870d@Voxera well the issue here was that this plugin probably would have been fantastic on a much smaller scale. Ya know, when it doesn't hurt to recache a whole site cause it's like 6 pages.
What threw me off was the fact that I had never worked with this large of a site before. So I just kinda expected these things eat all of the CPU and RAM. I didn't look into the disk IO untill much much later...
Inexperience I guess. After all these years, I'm still a noob.
Semmel12670dAnd this kids is why WordPress and PHP are evil.
Semmel12670dAlso kudos to you for pushing through and solving the issue. We've all been there.
Nanos687870dGreat story and valuable wisdom shared.
FX [ Tries to work out how big a database he would need for 32794.95 to the power of 545 records.. ]
Google says first it can't do higher than 500, and then:
> According to my calculations, 32794.95
> raised to the power of 500 would equal Infinity.
So, I'll need a bigger HD then..
Fradow102070dCode that store serialized data in DB is evil.
CMS have too many plugins doing just that. I die a bit inside every time I see that.
stackodev863470dWhich caching plugin was the issue? I might have the same problem. One day my app server went from 500ms per request on average to 3s with the majority of slowness centered on WooCommerce. I suspect it’s the WP Rocket plugin but I can’t seem to prove it. And it does have files outside its plugin directory.
Salim36570dThe moral of the story is not "never give up" it's "stop using WP"
Your Job Suck?
Take a quick quiz from Triplebyte to skip the job search hassles and jump to final interviews at hot tech firms
Get a Better Job