Jump to content
xt:Commerce Community Forum
Sign in to follow this  
dragon_0000

fehlende DB Indizies

Recommended Posts

In einigen Tabellen fehlen wichtige indizies auch bei der aktuellen Version 4.1

Hier eine Liste von Indizies welche auf jedenfall empfehlenswert sind.

#Produkt


ALTER TA+BLE `xt_products`

	ADD INDEX `products_ean` (`products_ean`),

	ADD INDEX `products_model` (`products_model`),

	ADD INDEX `products_tax_class_id` (`products_tax_class_id`),

	ADD INDEX `products_owner` (`products_owner`),

	ADD UNIQUE INDEX `products_model_manufacturers_id` (`products_model`, `manufacturers_id`);

#Bilder

ALTER TA+BLE `xt_media_link`

	ADD INDEX `link_id` (`link_id`),

	ADD INDEX `class` (`class`),

	ADD INDEX `type` (`type`),

	ADD INDEX `m_id` (`m_id`);


ALTER TA+BLE `xt_media`

	ADD INDEX `type` (`type`),

	ADD INDEX `class` (`class`),

	ADD UNIQUE INDEX `file` (`file`),

	ADD INDEX `download_status` (`download_status`);

#Warenkorb

ALTER TA+BLE `xt_customers_basket`

	ADD INDEX `customers_id` (`customers_id`),

	ADD INDEX `products_id` (`products_id`);

#Bestellungen

ALTER TA+BLE `xt_orders`

	ADD INDEX `customers_id` (`customers_id`);

#Plugins

ALTER TA+BLE `xt_plugin_code`

	ADD INDEX `plugin_id` (`plugin_id`);

ALTER TA+BLE `xt_plugin_sql`

	ADD UNIQUE INDEX `plugin_id` (`plugin_id`);

#Kategorien

ALTER TA+BLE `xt_products_to_categories`

	ADD INDEX `master_link` (`master_link`);

#Versandkosten

ALTER TA+BLE `xt_shipping`

	ADD UNIQUE INDEX `shipping_code` (`shipping_code`);

ALTER TA+BLE `xt_shipping_cost`

	ADD INDEX `shipping_id` (`shipping_id`);

#Bestellstatus

ALTER TA+BLE `xt_system_status`

	ADD INDEX `status_class` (`status_class`);

#Steuer

ALTER TA+BLE `xt_tax_rates`

	ADD INDEX `tax_class_id` (`tax_class_id`),

	ADD INDEX `tax_country_id` (`tax_country_id`),

	ADD INDEX `tax_zone_id` (`tax_zone_id`);

#BUI Configurator Plugin

ALTER TA+BLE `xt_products`

	ADD INDEX `product_configurator_flag` (`product_configurator_flag`),

	ADD INDEX `product_configurator_only_flag` (`product_configurator_only_flag`);

ALTER TA+BLE `xt_plg_product_configurator`

	ADD INDEX `status` (`status`);

#BUI Watchlist

ALTER TA+BLE `xt_plg_bui_watchlist`

	ADD INDEX `customers_id` (`customers_id`);

bitte im nächsten Release fixen gerade bei Shops mit >1.000 Produkten oder >1.000 Bilder erhöhen die Indizies die Ladezeit erheblich da kann man soviel SEO Ladezeit optimieren wie man will.

bei meinem aktuellen Shop mit 175.000 Produkten und 73.000 Bilder wurde die Ladezeit (um 99%) von 60 sec auf 1 sec reduziert !

Edited by dragon_0000

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...