Backend curiose overview

[heural]

Hi Aimeos-Team,

we have a curiose overview in our production system now:

screenshot-2024_10_24-10_04_21.png (28 KiB) Viewed 20401 times

Orders are created before the Oct. 19.

screenshot-2024_10_24-10_05_05.png (37.58 KiB) Viewed 20401 times

In the protocol long queries are logged with > 1s:

Time: 1014.7659778595ms
Class: Aimeos\MShop\Order\Manager\Standard
SELECT "order.chour", count("val") AS "value"
FROM ...

Time: 1369.9569702148ms
Class: Aimeos\MShop\Order\Manager\Standard
SELECT
mord."id" AS "order.id", mord."channel" AS "order.channel",
mord."siteid" AS "order.siteid", mord."invoiceno" AS "order.invoiceno", ...

Time: 1056.0281276703ms
Class: Aimeos\MShop\Order\Manager\Standard
SELECT "order.currencyid", "order.cwday", sum("val") AS "value"
FROM (
SELECT mord."currencyid" AS "order.currencyid", mord."cwday" AS ...

Seems there is a a performance issue in our mysql-server or some indexes are not used?

Aimeos 2023.10.7
Typo3 12.4.20

[aimeos]

Seems like you have a very high number of orders within one week and the counting stops at 10,000 records for performance reasons. Can you check which indexes would speed up the queries?