Modify ↓

Opened 9 years ago

Closed 4 years ago

Last modified 4 years ago

#1157 closed Aufgabe (fixed)

Fehlende DB-Indizes

Reported by: INETvisio Owned by: somebody
Priority: normal Milestone: modified-shop-2.0.7.0
Component: Shop Version: 2.0.2.1
Keywords: Cc:
Blocked By: Blocking:

Description

Hallo,

folgende Indizes fehlen noch:

  1. customers
    • account_type
    • customers_default_address_id
  1. categories
    • categories_status
  1. countries
    • status
  1. content_manager
    • content_active
    • languages_id
  1. languages
    • status
  1. tax_rates
    • tax_class_id
  1. zones
    • zone_country_id
  1. personal_offers_by_customers_status_
    • products_id (customers_status.php - Tabellen Erstellung)

Gruß
Jürgen H.

Attachments (0)

Change History (14)

comment:1 by Torsten Riemer, 9 years ago

Milestone: DB-Performance → modified-shop-2.0.2.2
Version: trunk → 2.0.2.1

comment:2 by Torsten Riemer, 9 years ago

Milestone: modified-shop-2.0.2.2 → modified-shop-2.0.2.3

comment:3 by Torsten Riemer, 9 years ago

Milestone: modified-shop-2.0.2.3 → modified-shop-2.0.2.4

comment:4 by Gerhard Waldemair, 9 years ago

Resolution: → fixed
Status: new → closed

In 10783:

fix #1157

comment:5 by Torsten Riemer, 9 years ago

Milestone: modified-shop-2.0.2.4 → modified-shop-2.0.2.3

comment:6 by Torsten Riemer, 9 years ago

In 10803:

Addition on r10783 (fix #1157)

comment:7 by Volker Strähle, 8 years ago

Resolution: fixed
Status: closed → reopened

Es werden in 2.0.3.0 zwar Indizes auf personal_offers_by_customers_status_ gesetzt, aber nur für die standardmäßigen Kundengruppen 0-4.

Weitere Kundengruppen sind ohne Indizes.

Müßte man nicht besser erst auf die Existenz und Anzahl der Tabellen prüfen?

SELECT `TABLE_NAME` FROM information_schema.TABLES where `TABLE_SCHEMA` = 'modified_db' AND `TABLE_NAME` like 'personal_offers_by_customers_status_%'

Besser evtl. die Erstellung der Indizes in neues Autoinclude "updates" auslagern und diese Datei nach Installation löschen/umbenennen/verschieben?

comment:8 by Torsten Riemer, 8 years ago

Milestone: modified-shop-2.0.3.0 → modified-shop-2.0.3.1

comment:9 by Torsten Riemer, 8 years ago

Milestone: modified-shop-2.0.4.0

comment:10 by Torsten Riemer, 4 years ago

Milestone: → modified-shop-2.0.6.1

comment:11 by Gerhard Waldemair, 4 years ago

Resolution: → fixed
Status: reopened → closed

In 13716:

fix #1157 - add index

comment:12 by Gerhard Waldemair, 4 years ago

In 13717:

revised r13716 (fix #1157 - add index)

comment:13 by Gerhard Waldemair, 4 years ago

In 14344:

fix #1157 - add index

comment:14 by Gerhard Waldemair, 4 years ago

In 14345:

revised r14344 (fix #1157 - add index)

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.