Hauptsächlich den alten xt:Commerce mit den Servicepacks.
Der soll jetzt aber nach modified eCommerce Shopsoftware 1.05 SP1a umgebaut werden.
Die DB ist vom alten xt:Commerce - Shop.
Das Problem ist mir aber in beiden Shops aufgefallen.
Hab mal angefangen die SQL Anweisung etwas zu optimieren.
Dauert jetzt zwar nicht mehr ganz so lang wie vorher aber immer noch zu lange für meinen Geschmack.
Vielleicht kann man da ja noch was dran drehen...
vorher:$orders_query_raw = "select
o.orders_id,
o.orders_status,
o.afterbuy_success,
o.afterbuy_id,
o.customers_name,
o.payment_method,
o.date_purchased,
o.last_modified,
o.currency,
o.currency_value,
o.language,
s.orders_status_name,
ot.text as order_total
from ".TABLE_ORDERS." o
left join ".TABLE_ORDERS_TOTAL." ot on (o.orders_id = ot.orders_id),
".TABLE_ORDERS_STATUS." s
where (o.orders_status = s.orders_status_id
and s.language_id = '".$_SESSION['languages_id']."'
and ot.class = 'ot_total')
or (o.orders_status = '0'
and ot.class = 'ot_total'
and s.orders_status_id = '1'
and s.language_id = '".$_SESSION['languages_id']."')"
.$sort;
nachher:$orders_query_raw = "select
o.orders_id,
o.orders_status,
o.afterbuy_success,
o.afterbuy_id,
o.customers_name,
o.payment_method,
o.date_purchased,
o.last_modified,
o.currency,
o.currency_value,
o.language,
s.orders_status_name,
ot.text as order_total
from ".TABLE_ORDERS." o
left join (".TABLE_ORDERS_TOTAL." ot, ".TABLE_ORDERS_STATUS." s) on (o.orders_id = ot.orders_id and o.orders_status = s.orders_status_id)
where ( s.language_id = '".$_SESSION['languages_id']."'
and ot.class = 'ot_total')
or (o.orders_status = '0'
and ot.class = 'ot_total'
and s.orders_status_id = '1'
and s.language_id = '".$_SESSION['languages_id']."') "
.$sort;
Edit Dokuman: SQL Darstellung etwas lesbarer