[TYPO3-core] RFC #3107: Duplicate database index in indexed search

Ernesto Baschny [cron IT] ernst at cron-it.de
Thu Mar 25 17:15:35 CET 2010


Dmitry Dulepov schrieb am 25.03.2010 16:23:
> Hi!
> 
> Ernesto Baschny [cron IT] wrote:
>> This is not a duplicate, as already mentioned. If you remove that one,
>> you will no longer have an index to search by "phash", for example.
> 
> While we disagree on duplicate indexes, I agree to drop this RFC. I will
> also mark it as "won't fix" in the BT.

A nice way to analyse the need or unneed of indexes (maybe there are
some that we could yet add for more performance) it would be nice to try
to make a "summary" of all potential SQL-queries that indexed search
might do. Maybe this can be traced at TYPO3_DB level.

That knowledge would allow us to optimize on index level.

Cheers,
Ernesto


More information about the TYPO3-team-core mailing list