Slow C5 site
Permalink
I'm working with a client who's got a fairly large site and is a bit older. The "time to first byte" has been increasing over the past couple of years and the page loads seem a bit long. Can anybody suggest the best way/tools to profile a page load? Is there tools I can use to profile the total request and db calls to help pinpoint some of the bottlenecks?
The site is running 5.5.2.1 and unfortunately I hit a wall trying to update C5 to 5.6+ .
Is there profiling tools available for 5.7 as well?
Thanks
The site is running 5.5.2.1 and unfortunately I hit a wall trying to update C5 to 5.6+ .
Is there profiling tools available for 5.7 as well?
Thanks
If you were on 5.6.x, I would recommend my Extreme Clean job. For 5.5.x, I don't think there is any equivalent other than running Remove Old Page Versions repeatedly.
Thanks John,
I'll definitely keep that addon in mind for 5.6+ sites. Can large numbers of page versions actually slow down a page load? I only thought it would increase db size no?
I'll definitely keep that addon in mind for 5.6+ sites. Can large numbers of page versions actually slow down a page load? I only thought it would increase db size no?
A bigger db takes longer to query. For example, when a query involves joining several tables, if the tables are longer, then the join has more rows to process. Its not linear and databases have optimisations to speed up such queries, but its still longer.
You can also try repairing tables in case a damaged table is slowing things down. There may be a c5 job somewhere to repair everything, or its easy enough to do through phpMyAdmin.
You can also try repairing tables in case a damaged table is slowing things down. There may be a c5 job somewhere to repair everything, or its easy enough to do through phpMyAdmin.
