[TYPO3-core] Fw: RFC: Bug 689: Domain Record with umlaut Domains not working

[Dmitry Dulepov [typo3]]

Martin Kutschker wrote:
> Dmitry Dulepov [typo3] schrieb:
>> I did not profile it myself yet. But currently finding rootline 
>> involves as many queries as much deep the page stays. If it is 5 
>> levels deep, there will be 5 queries (or so). With nested sets it will 
>> be one query always (if no mountpoints or WS previews).
> 
> I know. For some reason the multiple simple lookups with key index 
> access were faster than one complex query for the nested set.

It probably means that indexes were not set properly on two integer 
fields (for nested sets) ;) For example they were not set at al or were 
set individually for each field or did not include some other fields.

-- 
Dmitry Dulepov
TYPO3 freelancer / TYPO3 core team member
Web: http://typo3bloke.net/
Skype: callto:liels_bugs