CoreCommunity ExtensionsIncubatorDistributionsTYPO3 4.5 ProjectsTYPO3 4.6 ProjectsTYPO3 4.7 ProjectsTYPO3 6.0 ProjectsTYPO3 6.1 ProjectsTYPO3 6.2 Projects (+)

Bug #13589

Missing indexes in sql tables (dramatic performance improvement)

Added by Dimitri Koenig about 2 years ago. Updated about 2 years ago.

Status:Accepted Start date:2011-03-03
Priority:Must have Due date:
Assignee:- % Done:

100%
Category:-
Target version:- Estimated time:2.00 hours
Votes: 0

Description

Using the publication search which includes several fields linked to other tables can take several seconds if no indexes definied. Adding missing indexes results in a performance improvement of about 500% depending on which fields are definied.

13589.diff (800 Bytes) Dimitri Koenig, 2011-03-03 17:30

History

#1
Updated by Dimitri Koenig about 2 years ago

  • File 13589.diff added
  • % Done changed from 0 to 100
  • Estimated time set to 2.00

#2
Updated by 4eyes GmbH about 2 years ago

  • Status changed from New to Accepted

Also available in: Atom PDF