Project

General

Profile

Actions
Copy link

Bug #55184

closed

Epic #55070: Workpackages

Epic #55065: WP: Overall System Performance (Backend and Frontend)

Task #55179: Optimize SQL Performance

Filling the entries from sys_registry does not use an index

Added by Ingo Schmitt over 10 years ago. Updated about 10 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Ingo Schmitt
Category:
Performance
Target version:
6.2.0
Start date:
2014-01-20
Due date:
% Done:

0%

Estimated time:
2.00 h
TYPO3 Version:
6.2
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

While filling the cache by Registry->loadEntriesByNamespace the Entries of the Database are fetched.

Count: 44 Time=0.00s (0s) Lock=0.00s (0s) Rows=111.7 (4915), webuser[webuser]@localhost
SELECT * FROM sys_registry WHERE entry_namespace = 'S'

Since the is no index on entry_namespace this query is not cached and executed slower.

Solution: Add index on entry_namespace

Actions
Copy link
 #1

Updated by Ingo Schmitt about 10 years ago

  • Estimated time changed from 0.50 h to 2.00 h
Actions
Copy link
 #2

Updated by Ingo Schmitt about 10 years ago

SQL Statement is no more present in current master. So close

Actions
Copy link
 #3

Updated by Ingo Schmitt about 10 years ago

  • Status changed from New to Closed
Actions
Copy link

Also available in: Atom PDF