[TYPO3-core] RFC: #8515: Speed up tslib_cObj->getTreeList by caching its results

[Peter Niederlag]

Hi Ingo,

Ingo Renner schrieb:
> Peter Niederlag wrote:
> 
> Hi Peter,
> 
>> I don't have any site running where tslib_piBase->pi_getPidList whould
>> run one more than maximal five pages. So I don't expect any reasonable
>> gain from this patch. in 99% percent of cases it just operates on a
>> single(!) page, where the records are stored.
> 
> Not in the (special) case of indexed_search. IS always runs through the 
> whole tree beginning at the root. This patch will save you n-1 queries 
> for every site. (where n is the number of pages in the tree beginning at 
> the root)

I perfectly understand that. ;) Wouldn't there probably be another
approach to optimize the query itself using recent SQL features?

[...]
> yes, basically every extension. Even in the scenario you mentioned above 
> it would save 4 queries.

might be, but we still don't know what the price for this is.

>> I am not against it at all but would really like to see a thorough
>> analysis of the performance-impacts for different situations.
> 
> Have a look at a corresponding thread in typo3.dev for more numbers: 
> http://support.typo3.org/general/dev/m/re-typo3-dev-sphinx-for-indexed-search-340973/p/226/ 

I tried to follow it. Is there any facts and figures about the
(performance-)impact of the additional hook-usage?

Greets,
Peter
-- 
Peter Niederlag * Neuer Sandberg 9 * 31535 Neustadt *
Fon (privat): 05036 / 924 100 * Fon (Büro): 05036 / 924 101
Fon (mobil): 0172 / 516 48 55 * Fax 05036 / 924 105
callto:typo3support (skype)
http://www.niekom.de * TYPO3 und EDV Dienstleistungen *