Issue Bug Closed

#54929Speedup Category Listing by SQL Keys

Ingo Schmitt 01/13/14, 10:21 updated 10/23/17, 21:41

Description

When a category listing the the Backend is made, the following SQL Statements are issued:

SELECT sys_category.uid,sys_category.title,sys_category.t3ver_id,sys_category.t3ver_state,sys_category.t3ver_wsid,sys_category.t3ver_count,sys_category.hidden,sys_category.starttime,sys_category.endtime FROM sys_category WHERE sys_category.pid<>-1 AND sys_category.deleted=0 AND sys_category.sys_language_uid IN (-1, 0) ORDER BY sys_category.sorting ASC;

(Twice per Category Tree)

plus per each category element

SELECT uid FROM sys_category WHERE FIND_IN_SET(‘9’,parent);

Possible Solution: Add two additional indexes to sys_category

Reviews 1