[TYPO3-dev] getRootLine

Peter Russ peter.russ at 4many.net
Mon Oct 23 17:12:46 CEST 2006


Steffen Kamper schrieb:
> Hi,
> 
> i need for extension all pages from one Rootline. Now I have a problem, 
> cause there is no way to get them by one SQL.
> I have to run through all pages and have to decide with the function 
> getRootLine() if the page is in the wanted rootline.
> 
> This is very unperformant, and for each page there will be a loop with 
> dbqueries (i don't count all db requests :) )
> 
> So maybe I'm wrong, but would it be much easier if the table pages has one 
> or two more fields specifying the position ? Then it would be possible with 
> one or less Queries, so like other nested sets, simular to this model:
> http://www.php-resource.de/tutorials/read/21/1/ (german, sry)
> 
> Or maybe simply one field with the rootline pid may help.
> I think there are more possible ways, just want to discuss it with the list 
> and i'm very interested about your input.

Ever thought about HMENU or TMENU?

Regs. Peter.

-- 
Fiat lux!
Docendo discimus.
_____________________________
4Many® Services
openBC: http://www.openbc.com/go/invuid/Peter_Russ




More information about the TYPO3-dev mailing list