# Analyse Performance Issues
**URL:** https://forum.shopware.com/t/analyse-performance-issues/103448
**Category:** Shopware 6 (English)
**Created:** [26. März 2024 um 11:18 UTC](https://forum.shopware.com/t/analyse-performance-issues/103448 "2024-03-26T11:18:40Z")
**Posts on this page:** 17
**Page:** 1
### Author:  [@hkn11](https://forum.shopware.com/u/hkn11)
#### Post date: [26. März 2024 um 11:18 UTC](https://forum.shopware.com/t/analyse-performance-issues/103448/1 "2024-03-26T11:18:40Z")
Hello everyone
I’ve been struggling for ages with our TTFB value, which is always over 2 seconds. Everything else is lightning fast.
It definitely seems to be a combination of plugins. I’ve also turned them all off one by one, where I found out → the less, the faster (logically) - but I’ve never found out what exactly causes the +1 second delay.
With Chrome Inspector and the Symfomy Profiler I also tried to find out WHAT exactly the bottleneck is, I’m just not sure where exactly to look.
It would be difficult to do without certain plugins.
But at least a clue which function, which listener, which part is responsible would be great.
I hope someone has an idea in this regard
---
### Author:  [@Max\_Shop](https://forum.shopware.com/u/Max_Shop)
#### Post date: [27. März 2024 um 13:04 UTC](https://forum.shopware.com/t/analyse-performance-issues/103448/2 "2024-03-27T13:04:03Z")
You have already done the first step.
You know that the TTFB is the problem. Thus it cannot be any frontend JavaScript.
Next, open different type of pages: category, detail, shop page (e.g. legal notes). Is there a difference between these types? If yes, you can focus on all plugins that are involved in that type. If not, it looks like a more general problem.
Activate the dev mode and also log all SQL query (within the MySQL server) and then look for maybe broken configuration or UUIDs.
There is also a slow query log in MySQL that might help.
---
### Author:  [@hkn11](https://forum.shopware.com/u/hkn11)
#### Post date: [27. März 2024 um 13:47 UTC](https://forum.shopware.com/t/analyse-performance-issues/103448/3 "2024-03-27T13:47:51Z")
thanks for the detailed reply!
its predominantly in the category pages
the „privacy“ page with no images etc has a TTFB of around 1 second which still isn’t optimal, but still better than 2-3 seconds on category pages or 2 second on product pages.
I’ve removed all plugins for testing and it definitely helps, however some of the plugins are essential, that’s why i want to find out what plugin or more specifically what query or request is causing the bottleneck.
so your suggestion would be logging all SQL querys and see which one are „long“ correct?
regarding the dev mode i’ve tried it and utilised the symfomy profiler to check for bottlenecks, however it didn’t reveal much more than chrome inspector or pingdom - maybe i was looking at the wrong areas?
the MySQL Slow Query Log sounds promising - however we are using the nativa MariaDB as our nginx server doesn’t have MySQL8 installed - is there a similar option for MariaDB?
---
### Author:  [@Max\_Shop](https://forum.shopware.com/u/Max_Shop)
#### Post date: [27. März 2024 um 14:14 UTC](https://forum.shopware.com/t/analyse-performance-issues/103448/4 "2024-03-27T14:14:26Z")
One second is still way too long.
Approximately, how many variants are loaded on one category in complete? Not the 8 or 16 products, their variants included.
What is the RAM limit for PHP?
Which PHP version do you use?
How many PHP processes are allowed to run parallel?
How many and which CPU cores are available?
I guess it is a performance bottleneck.
You should be able to see in the Symphony Profiler how many ms an sql query took.
> **[Slow Query Log Overview](https://mariadb.com/kb/en/slow-query-log-overview/)**
>
> A record of SQL queries that took a long time to perform.
---
### Author:  [@hkn11](https://forum.shopware.com/u/hkn11)
#### Post date: [27. März 2024 um 15:12 UTC](https://forum.shopware.com/t/analyse-performance-issues/103448/5 "2024-03-27T15:12:24Z")
i did ask my hoster and he replied that the server has lots of resources left even at peak visitor times, so it must be related to some plugins and maybe the server not handling it correctly?
we are using a managed dedicated root server
Intel(R) Core™ i7-7700 CPU @ 3.60GHz (8 core(s))
Version
Plesk Obsidian v18.0.59\_build1800240229.10 os\_CentOS 7
CentOS Linux 7.9.2009 (Core)
64 Gigabytes of RAM (15GB used on average load)
500GB SSD (80% Full)
on CPU Load it says „2.8“ on average
attached you will find the php settings and the frosch tools status - is there anything which can be increased?
Frosch Tools:
---
### Author:  [@Max\_Shop](https://forum.shopware.com/u/Max_Shop)
#### Post date: [27. März 2024 um 15:40 UTC](https://forum.shopware.com/t/analyse-performance-issues/103448/6 "2024-03-27T15:40:59Z")
That should be more than enough performance.
If you want, write me the domain in an private message and I will look if I can see anything in the frontend, that caches my eye.
---
### Author:  [@pginware](https://forum.shopware.com/u/pginware)
#### Post date: [2. April 2024 um 10:00 UTC](https://forum.shopware.com/t/analyse-performance-issues/103448/7 "2024-04-02T10:00:03Z")
I’m curios about SSD’s read/write performance. Had some issues some time ago, and was due to poor read/write performance. It’s a dedicated server and should perform well - but was just an idea.
---
### Author:  [@hkn11](https://forum.shopware.com/u/hkn11)
#### Post date: [3. April 2024 um 11:52 UTC](https://forum.shopware.com/t/analyse-performance-issues/103448/8 "2024-04-03T11:52:03Z")
good on that end! just checked a basic test.html with hello world from the same folder as the shopware Installation and it gives me 30ms as TTFB
accessing a satelitte page in our shop which talks about stuff without pulling any products gives me 300 ms
accessing the imprint gives me 600 ms
category pages are 1000 ms
(all on first load and consecutive loads - no difference)
I wonder what other info i could provide
---
### Author:  [@hkn11](https://forum.shopware.com/u/hkn11)
#### Post date: [6. April 2024 um 08:06 UTC](https://forum.shopware.com/t/analyse-performance-issues/103448/9 "2024-04-06T08:06:38Z")
just analysed a bit further with profiler
curious that the base.html.twig blog of the storefront standard theme takes 400 ms to render?
Jumps from 94% to 19% for only that block (base doctype and base html)
which would explain a lot because its on every page.
---
### Author:  [@hkn11](https://forum.shopware.com/u/hkn11)
#### Post date: [9. April 2024 um 16:41 UTC](https://forum.shopware.com/t/analyse-performance-issues/103448/10 "2024-04-09T16:41:16Z")
I might add that I added a staging environment under [staging.domain.de](http://staging.domain.de) and the TTFB, after turning off EVERY plugin only improved by 100 ms, so it’s still above 700 for most pages, but never lower than 500.
Plugins aren’t the main cause it seems it must be something with the server config, since the server ressource limits are not even close to being hit
---
### Author:  [@Marvin](https://forum.shopware.com/u/Marvin)
#### Post date: [29. Oktober 2024 um 08:26 UTC](https://forum.shopware.com/t/analyse-performance-issues/103448/11 "2024-10-29T08:26:32Z")
Did you find a solution for your problem?
---
### Author:  [@hkn11](https://forum.shopware.com/u/hkn11)
#### Post date: [29. Oktober 2024 um 08:51 UTC](https://forum.shopware.com/t/analyse-performance-issues/103448/12 "2024-10-29T08:51:53Z")
Unfortunately not. Ive tried everything imaginable
---
### Author:  [@Marvin](https://forum.shopware.com/u/Marvin)
#### Post date: [29. Oktober 2024 um 09:14 UTC](https://forum.shopware.com/t/analyse-performance-issues/103448/13 "2024-10-29T09:14:55Z")
okay, if I have some spare time I want to dig deeper whats causing the problem.
When I check the stats for example „[Stabilo.com](http://Stabilo.com)“ which should be an sw 6.6.x shop (js is split for dynamic imports) the inital page load is around 500ms+ after that it drops to 30-50ms.
With the new dynamic import it is also more transparent, which plugins they use. They use quite a few as well.
We will see.
---
### Author:  [@hkn11](https://forum.shopware.com/u/hkn11)
#### Post date: [30. Oktober 2024 um 09:33 UTC](https://forum.shopware.com/t/analyse-performance-issues/103448/14 "2024-10-30T09:33:54Z")
thats pretty nice! were happy to provide any data neccessary
Im pretty sure it has a LOT to do with server configuration, but Ive tried so many iterations of configuration changes and none of them brought the intended effect
---
### Author:  [@raymond-de](https://forum.shopware.com/u/raymond-de)
#### Post date: [1. November 2024 um 07:55 UTC](https://forum.shopware.com/t/analyse-performance-issues/103448/15 "2024-11-01T07:55:05Z")
CPU: the i7-7700 is released in Q1/2017. So it is very old in the tech world: the hoster should update the CPU. Min 8 physical cores for average usage.
SSD: is that a SATA or M2 SSD? Better usw. M2
PHP: use version 8.3
CentOS: this is End of Life (EOL). The hoster should upgrade to a supported operating system.
Performance Tweaks: [Performance Tweaks | Shopware Documentation](https://developer.shopware.com/docs/guides/hosting/performance/performance-tweaks.html)
---
### Author:  [@hkn11](https://forum.shopware.com/u/hkn11)
#### Post date: [5. November 2024 um 10:31 UTC](https://forum.shopware.com/t/analyse-performance-issues/103448/16 "2024-11-05T10:31:40Z")
But these significant bottlenecks down to minimal php version differences?
Server is quite powerful still compared to what many others are using. Could use an update for sure, but im not sure if thats the underlying cause because other shops on this server worked normally.
---
### Author:  [@raymond-de](https://forum.shopware.com/u/raymond-de)
#### Post date: [24. November 2024 um 19:48 UTC](https://forum.shopware.com/t/analyse-performance-issues/103448/17 "2024-11-24T19:48:02Z")
Then please check every shopware plugin you use and the template.
Hoster: it is not very expensive to have a hoster that are shopware certified (and can help regarding performance issues) and use latest hardware and software.