Performance issues

[stephenmeehanuk]

I'm experiencing performance issues on my Statamic site, the production site uses a translation service called Weglot, the staging site doesn't.

Both production and staging sites use half measure and both are outputting the same messages to slow log.

The staging site is fast, but the production site is sluggish, feels like it's not even using half measure cache.

However, digging into the slow logs, I see this for both sites:

I think this could be the root of the problem, can you recommend any workflows to help me fix these issues?

ploi@web-dev:~$ tail -50 /var/log/php8.4-fpm.slow.log
[0x0000760901c1e050] render() /home/ploi/staging.website.com/vendor/statamic/cms/src/Tags/Partial.php:31
[0x0000760901c1dfb0] render() /home/ploi/staging.website.com/vendor/statamic/cms/src/Tags/Partial.php:15
[0x0000760901c1df30] wildcard() /home/ploi/staging.website.com/vendor/statamic/cms/src/Tags/Tags.php:186
[0x0000760901c1de70] __call() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Language/Runtime/NodeProcessor.php:1610

[08-Sep-2025 08:07:11]  [pool www] pid 1570445
script_filename = /home/ploi/staging.website.com/public/index.php
[0x0000760901c19270] getCallbacksForType() /home/ploi/staging.website.com/vendor/laravel/framework/src/Illuminate/Container/Container.php:1440
[0x0000760901c19150] fireResolvingCallbacks() /home/ploi/staging.website.com/vendor/laravel/framework/src/Illuminate/Container/Container.php:934
[0x0000760901c19070] resolve() /home/ploi/staging.website.com/vendor/laravel/framework/src/Illuminate/Foundation/Application.php:1077
[0x0000760901c18fd0] resolve() /home/ploi/staging.website.com/vendor/laravel/framework/src/Illuminate/Container/Container.php:847
[0x0000760901c18f50] make() /home/ploi/staging.website.com/vendor/laravel/framework/src/Illuminate/Foundation/Application.php:1057
[0x0000760901c18ec0] make() /home/ploi/staging.website.com/vendor/laravel/framework/src/Illuminate/Foundation/helpers.php:126
[0x0000760901c18e40] app() /home/ploi/staging.website.com/vendor/statamic/cms/src/Tags/Loader.php:20
[0x0000760901c18da0] init() /home/ploi/staging.website.com/vendor/statamic/cms/src/Tags/Loader.php:15
[0x0000760901c18ce0] load() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Language/Runtime/NodeProcessor.php:1578
[0x0000760901c18480] reduce() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Language/Runtime/NodeProcessor.php:750
[0x0000760901c183f0] render() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Language/Runtime/RuntimeParser.php:386
[0x0000760901c182a0] renderText() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Language/Runtime/RuntimeParser.php:778
[0x0000760901c181c0] parseView() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Engine.php:93
[0x0000760901c180f0] get() /home/ploi/staging.website.com/vendor/laravel/framework/src/Illuminate/View/View.php:208
[0x0000760901c18090] getContents() /home/ploi/staging.website.com/vendor/laravel/framework/src/Illuminate/View/View.php:191
[0x0000760901c18020] renderContents() /home/ploi/staging.website.com/vendor/laravel/framework/src/Illuminate/View/View.php:160
[0x0000760901c17f70] render() /home/ploi/staging.website.com/vendor/statamic/cms/src/Tags/Partial.php:31
[0x0000760901c17ed0] render() /home/ploi/staging.website.com/vendor/statamic/cms/src/Tags/Partial.php:15
[0x0000760901c17e50] wildcard() /home/ploi/staging.website.com/vendor/statamic/cms/src/Tags/Tags.php:186
[0x0000760901c17d90] __call() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Language/Runtime/NodeProcessor.php:1610

[08-Sep-2025 08:08:27]  [pool www] pid 1641946
script_filename = /home/ploi/staging.website.com/public/index.php
[0x0000760901c1dbe0] guardRuntimeAccess() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Language/Runtime/PathDataManager.php:534
[0x0000760901c1da00] getData() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Language/Runtime/Sandbox/Environment.php:1274
[0x0000760901c1d960] scopeValue() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Language/Runtime/Sandbox/Environment.php:1591
[0x0000760901c1d840] getValue() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Language/Runtime/Sandbox/Environment.php:948
[0x0000760901c1d600] process() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Language/Runtime/Sandbox/Environment.php:1568
[0x0000760901c1d4e0] getValue() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Language/Runtime/Sandbox/Environment.php:948
[0x0000760901c1d2a0] process() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Language/Runtime/Sandbox/Environment.php:296
[0x0000760901c1d1f0] processStatements() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Language/Runtime/Sandbox/Environment.php:319
[0x0000760901c1d170] evaluate() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Language/Runtime/Sandbox/Environment.php:353
[0x0000760901c1cfb0] evaluateBool() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Language/Runtime/ConditionProcessor.php:101
[0x0000760901c1ce60] process() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Language/Runtime/NodeProcessor.php:1318
[0x0000760901c1c600] reduce() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Language/Runtime/NodeProcessor.php:1433
[0x0000760901c1bda0] reduce() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Language/Runtime/NodeProcessor.php:1433
[0x0000760901c1b540] reduce() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Language/Runtime/NodeProcessor.php:1433
[0x0000760901c1ace0] reduce() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Language/Runtime/NodeProcessor.php:2337
[0x0000760901c1a3e0] reduce() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Language/Runtime/NodeProcessor.php:750
[0x0000760901c1a350] render() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Language/Runtime/RuntimeParser.php:386
[0x0000760901c1a200] renderText() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Language/Runtime/RuntimeParser.php:778
[0x0000760901c1a120] parseView() /home/ploi/staging.website.com/vendor/statamic/cms/src/View/Antlers/Engine.php:93
[0x0000760901c1a050] get() /home/ploi/staging.website.com/vendor/laravel/framework/src/Illuminate/View/View.php:208

The site is large, but it's nowhere near the often mentioned 5000 entry limit for flat file sites

Environment
Application Name: Statamic
Laravel Version: 12.27.0
PHP Version: 8.4.11
Composer Version: 2.8.11
Environment: production
Debug Mode: OFF
URL: website.com
Maintenance Mode: OFF
Timezone: America/New_York
Locale: en

Cache
Config: CACHED
Events: NOT CACHED
Routes: CACHED
Views: CACHED

Drivers
Broadcasting: pusher
Cache: redis
Database: sqlite
Logs: stack / single, nightwatch
Mail: array
Queue: redis
Session: redis

Storage
public/storage: NOT LINKED

Livewire
Livewire: v3.6.4

Statamic
Addons: 5
Sites: 1
Stache Watcher: Disabled
Static Caching: half
Version: 5.64.0 PRO

Statamic Addons
marcorieser/statamic-live-search: 3.0.1
marcorieser/statamic-livewire: 4.5.3
statamic/collaboration: 1.0.1
statamic/importer: 1.8.4
visuellverstehen/statamic-anchor-navigation: 1.0.0

[duncanmcclean]

The production site doesn't appear to be using the half measure cache - its slow and often timesout.

The staging site is fast and uses the half measure cache

Why don't you use half measure caching on production too?

[stephenmeehanuk]

Apologies, I meant to say it is configured to use half measure, but it's loading like it isn't.

[duncanmcclean]

Config: CACHED

Have you tried clearing the config cache? php artisan config:clear

[stephenmeehanuk]

Thanks, yes I've been wrestling with this for a few days. Cleared all the caches, isolated redis and queues, restarted supervisors, turned on Opcache. Checked and double checked the queues are running and using the right redis database.

It all appears to be working...

I was wondering do the slow logs reveal anything to you?

The production site is running behind Weglot - which uses Cloudflare.

I was thinking if I could perhaps address the issues in the slow log, that might help.