[Radiant] How big is your Radiant site?

[Oliver Baltzer]

Andrew O'Brien wrote:
>> Andrew: You may want to avoid deep directory hierarchies on your site
>> due to the recursive database queries Radiant performs.
>>
>> Oliver
> 
> Oh, good point.  How deep is "deep"?  Does radiant execute a query for
> each level of the page tree that it traverses (and on each request)?
> Could some kind of caching solution like memcached (or even just
> storing it in memory) be used instead (or is it already)?

Radiant has built-in caching, one of Radiant's main features in fact. 
With this caching being enabled it does not need to query the database 
at all when a cached page is requested. This, however, is likely to 
conflict with your plans of fine grained authorization. Without caching 
I believe Radiant needs to execute one database query per hierarchy 
level to find the right page, though I am not sure if Rails does some 
magic and caches database records. Memcached might help here.

Oliver