Opened 8 years ago

Closed 8 years ago

#57 closed Erweiterung (fixed)

Indizes in customers_basket und customers_basket_attributes

Reported by: info@… Owned by: somebody
Priority: normal Milestone: DB-Performance
Component: Shop Version: 1.06

Description (last modified by Tomcraft)

Hallo,

meiner Meinung nach, sollten die Tabellen customers_basket und customers_basket_attributes unbedingt ein paar mehr Indizes bekommen...

customers_basket

auf jeden Fall customers_id

products_id evtl. von tinytext auf varchar und auch indiziert

customers_basket_attributes

das gleiche + evtl. auch products_options_id undproducts_options_values_id

Ich war gerade an einem größeren Shop und da haben die Abfragen in der shopping_cart-Klasse ohne Indizes mindestens 1.5 Sekunden extra pro Seitenaufruf gekostet...

Beste Grüße

Marcus

Attachments (0)

Change History (3)

comment:1 Changed 8 years ago by Tomcraft

  • Component changed from Installer to Shop
  • Description modified (diff)
  • Type changed from Bug/Fehler to Erweiterung

comment:2 Changed 8 years ago by Tomcraft

Wir haben Die Datenbank in r5295 bzw. r5296 bzw. r5297 jetzt erst einmal um folgende Indizes erweitert:

#GTB - 2013-08-02 - Add new index on customers_basket
ALTER TABLE customers_basket ADD INDEX idx_customers_id (customers_id);

#GTB - 2013-08-02 - Add new index on customers_basket_attributes
ALTER TABLE customers_basket_attributes ADD INDEX idx_customers_id (customers_id);

#GTB - 2013-08-02 - Add new index on products_images
ALTER TABLE products_images ADD INDEX idx_products_id (products_id);

#GTB - 2013-08-02 - Add new index on sessions
ALTER TABLE sessions ADD INDEX idx_expiry (expiry);

#GTB - 2013-08-02 - Add new index on whos_online
ALTER TABLE whos_online ADD PRIMARY KEY (session_id);
ALTER TABLE whos_online ADD INDEX idx_time_last_click (time_last_click);

#GTB - 2013-08-02 - Add new index on coupons
ALTER TABLE coupons ADD INDEX idx_coupon_code (coupon_code);
Last edited 8 years ago by Tomcraft (previous) (diff)

comment:3 Changed 8 years ago by dokuman

  • Resolution set to fixed
  • Status changed from new to closed

Thema damit erledigt.

Add Comment

Modify Ticket

Action
as closed
The resolution will be deleted. Next status will be 'reopened'
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.