Project

General

Profile

Actions
Copy link

Bug #24308

closed

sys_log: optimize index recuidIdx

Added by Juergen Deisenroth almost 14 years ago. Updated about 10 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2010-12-07
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.5
PHP Version:
5.3
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

Please change the key "recuidIdx (recuid,uid)" to "recuidIdx (recuid)" for the database table "sys_log" at the file "typo3_src-4.5.0beta2/t3lib/stddb/tables.sql" because "uid" is the unique primary key. A combination with any other column makes no sence and wastes only resources.

(issue imported from #M16699)

Actions
Copy link
 #1

Updated by Alexander Opitz over 10 years ago

  • Status changed from New to Needs Feedback
  • Target version deleted (0)
  • Is Regression set to No

There were many index improvements for TYPO3 while developing the 6.x release series.
Also the mentioned assumption is not right. If you have select queries which have recuid and uid in the where clause it's better to have both in one index as only one index can be used.

So is it ok to close this issue?

Actions
Copy link
 #2

Updated by Alexander Opitz about 10 years ago

  • Status changed from Needs Feedback to Closed

No feedback within the last 90 days => closing this issue.

If you think that this is the wrong decision or experience this issue again, then please write to the mailing list typo3.teams.bugs with issue number and an explanation or open a new ticket and add a relation to this ticket number.

Actions
Copy link

Also available in: Atom PDF