Modify ↓

Opened 10 years ago

Closed 10 years ago

Last modified 10 years ago

#920 closed Bug/Fehler (fixed)

Produktfilter: Fehlender Index

Reported by: Volker Strähle Owned by: somebody
Priority: hoch Milestone: modified-shop-2.0.1.0
Component: Shop Version: 2.0.0.0
Keywords: Cc:
Blocked By: Blocking:

Description (last modified by Torsten Riemer)

​SQL Fehler bei Produktfilter modified 2.0

ALTER TABLE `products_tags` ADD INDEX(`options_id`);
ALTER TABLE `products_tags` ADD INDEX(`values_id`);

Signifikante Verbesserung durch o. g. Indizes. Ohne ist die Abfrage bei genug Kriterien und Artikeln nicht mer auführbar.

Attachments (0)

Change History (5)

comment:1 by Torsten Riemer, 10 years ago

Description: modified (diff)

comment:2 by Gerhard Waldemair, 10 years ago

Resolution: → fixed
Status: new → closed

In 9953:

fix #920

comment:3 by Torsten Riemer, 10 years ago

In 9986:

Fix r9953 (fix #920)

comment:4 by Torsten Riemer, 10 years ago

In 9999:

Fix r9953 (fix #920)

comment:5 by Gerhard Waldemair, 10 years ago

In 10002:

Fix r9953 (fix #920)

Modify Ticket

Action
as closed The owner will remain somebody.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment
E-mail address and name can be saved in the Preferences .
Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.