Antwort #18 am: 17. Januar 2011, 23:06:14
Hallo,
ich habe mal etwas gespielt.
Komisch ist, dass die BOX manufacturers.php die Seite total ausbremst. Wenn ich die Box raus nehme, bringt das fast eine Sekunde. Obwohl ein Timestamp in der manufacturers.php nur eine Durchlaufzeit von ein paar ms anzeigt.
DB Indexe bringen irgendwie nicht viel. Ich habe die SlowQuerys vom Provider mal angeschaut. Ein paar brauchen ziemlich lang, obwohl Indexe verwendet werden.
SELECT distinct
p
.products_id
, p
.products_price
, p
.products_model
, p
.products_quantity
, p
.products_shippingtime
, p
.products_fsk18
, p
.products_image
, p
.products_weight
, p
.products_tax_class_id
, p
.products_vpe
, p
.products_vpe_status
, p
.products_vpe_value
, pd
.products_name
, pd
.products_short_description
, pd
.products_description
FROM products
AS p
LEFT
JOIN products_description
AS pd ON
( p
.products_id
= pd
.products_id
) LEFT OUTER
JOIN products_attributes
AS pa ON
( p
.products_id
= pa
.products_id
) LEFT OUTER
JOIN products_options_values
AS pov ON
( pa
.options_values_id
= pov
.products_options_values_id
) LEFT OUTER
JOIN specials
AS s ON
( p
.products_id
= s
.products_id
) AND s
.status
= '1' WHERE p
.products_status
= '1' AND pd
.language_id
= '2' AND
( ( pd
.products_keywords LIKE
( '%c750%' ) OR pd
.products_description LIKE
( '%c750%' ) OR pd
.products_short_description LIKE
( '%c750%' ) OR pd
.products_name LIKE
( '%c750%' ) OR p
.products_model LIKE
( '%c750%' ) OR
( pov
.products_options_values_name LIKE
( '%c750%' ) AND pov
.language_id
= '2' ) ) ) GROUP BY p
.products_id
ORDER BY p
.products_id
-> 1,5 Sekunden
SELECT
p.products_tax_class_id,
p.products_id,
pd.products_name,
p.products_sort,
p.products_quantity,
p.products_image,
-- BOF - Tomcraft - 2009-12-03 - show model-number upon search for products
p.products_model,
-- EOF - Tomcraft - 2009-12-03 - show model-number upon search for products
p.products_price,
p.products_discount_allowed,
p.products_date_added,
p.products_last_modified,
p.products_date_available,
p.products_status,
p.products_startpage,
p.products_startpage_sort,
p2c.categories_id FROM products p, products_description pd, products_to_categories p2c
WHERE p.products_id = pd.products_id AND pd.language_id = '2' AND
p.products_id = p2c.products_id AND (pd.products_name like '%tx-l32%' OR p.products_model like '%tx-l32%') ORDER BY p.products_sort, pd.products_name ASC;
-> 1,5 Sekunden
Vielleicht hat ja noch jemand eine Idee.
Danke.
Christian