|
|||
|
Ich kann im Admin Bereich anscheinend meine Perfomance testen und diese durch Veränderungen auch beeinflussen.
Hat jemand eine Ahnung wie man das macht? Hier die Infos: Expensive SQL Tuning the following SQL could reduce the server load substantially SELECT * FROM xt_content_block SELECT config_key, config_value FROM xt_config_payment WHERE shop_id=1 SELECT * FROM xt_stores SELECT * FROM xt_system_status st, xt_system_status_description std where st.status_id=std.status_id and std.language_code = 'de' SELECT cd.customers_status_name,cs.customers_status_id FROM xt_customers_status cs, xt_customers_status_description cd where cs.customers_status_id = cd.customers_status_id and cd.language_code = 'de' SELECT * FROM xt_content_elements ce, xt_content c left JOIN xt_content_permission shop ON (shop.pid = c.content_id and shop.pgroup = 'shop_1' and shop.type = 'content') left JOIN xt_content_permission group_permission ON (group_permission.pid = c.content_id and group_permission.pgroup = 'group_permission_1' and group_permission.type = 'content') LEFT JOIN xt_seo_url su ON (su.link_id = c.content_id and su.link_type='3' and su.language_code = 'de') WHERE c.content_id = ce.content_id and c.content_parent = '1' and shop.permission IS NULL and group_permission.permission IS NULL AND ce.language_code='de' SELECT language_key, language_value FROM xt_language_content WHERE language_code='de' and (class = 'admin' or class='both') SELECT code FROM xt_languages l left JOIN xt_content_permission shop ON (shop.pid = l.languages_id and shop.pgroup = 'shop_1' and shop.type = 'language') where code = 'de' and shop.permission IS NULL SELECT pc.code FROM xt_plugin_code pc INNER JOIN xt_plugin_products pp ON pc.plugin_id = pp.plugin_id WHERE pc.hook = 'page_registry.php:bottom' AND pc.code_status = 1 and pp.plugin_status = 1 order by pc.sortorder SHOW COLUMNS FROM `xt_acl_nav` |
![]() |
| Lesezeichen |
| Themen-Optionen | |
| Ansicht | |
|
|
Ähnliche Themen
|
||||
| Thema | Autor | Forum | Antworten | Letzter Beitrag |
| SQL Error - xt:Commerce VEYTON | stanstas | Fragen zur Software | 9 | 30.09.2011 21:36 |
| Installationsproblem Veyton | Reimot | Installation und Konfiguration | 4 | 26.07.2010 21:05 |
| SQL Error - xt:Commerce VEYTON | steinbrock | Fragen zur Software | 2 | 10.09.2009 21:35 |
| SQL Error - xt:Commerce VEYTON | SS156 | Fragen zur Software | 11 | 08.05.2009 23:03 |
| Habe einige errors | Gilles | Installation und Konfiguration | 3 | 06.04.2008 20:16 |