Wow, this is a good idea. I will try adding an index and see if it helps.
On Jun 22, 2007, at 8:29 AM, Sean Cribbs wrote: > One thing John and I discussed last night in a "duh!" moment was the > fact that there is not an index on the 'parent_id' column of the pages > table. Adding that might give a minor performance boost. > > Sean >> No, it's running on Mongrel. >> >> I've been benchmarking the script - the slowness is coming from >> recursively calling <r:snippet name="sub-nav" />. Each time the sub- >> nav snippet is called takes about 0.05 - 0.1 seconds. For a large >> site, that adds up to a very slow load time. I'm not sure yet if it's >> rendering the snippet that takes so long, or if it's my tag that's >> inefficient. >> >> > > _______________________________________________ > Radiant mailing list > Post: [email protected] > Search: http://radiantcms.org/mailing-list/search/ > Site: http://lists.radiantcms.org/mailman/listinfo/radiant > ------------------------------------------------ Ryan Heneise Art of Mission, Inc. 3720 Gattis School Rd #800 PMB 245 Round Rock, TX 78664 800-722-1492 (phone) www.artofmission.com [EMAIL PROTECTED] _______________________________________________ Radiant mailing list Post: [email protected] Search: http://radiantcms.org/mailing-list/search/ Site: http://lists.radiantcms.org/mailman/listinfo/radiant
