Blog Sections Open

Diagnosing Slow Page Loads When Database Time Looks Fine

If database time is tiny but full render time is huge, the bottleneck is usually in parsing, file operations, external calls, or backend tooling rather than raw SQL.

A useful performance clue appears when timing placeholders show very low database time, but the full page still takes several seconds to render. That usually means the real bottleneck is not SQL at all.

What to inspect next

  • plugins that run on every request
  • filesystem-heavy snippets and thumbnail generation
  • network requests to external services
  • cache clearing or cache regeneration behavior
  • manager extensions that also feel slow on the backend

If both the public site and the manager are slow, look beyond template logic and inspect the wider runtime environment: disk I/O, antivirus hooks, thumbnail churn, logging, and PHP process limits.

Fast queries do not guarantee a fast site. They only prove the bottleneck lives somewhere else.

Newer post

Disabling Automatic Image Resize on Upload in Older Evolution CMS Builds

How to stop automatic image resizing during file manager uploads when upgrading the whole CMS is not an option.

Older post

Fixing txNewsletters Encoding and Mail Delivery Problems on cp1251 Sites

What to check when txNewsletters works structurally but breaks on character encoding or refuses to deliver mail reliably.