[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