Hi Daniel, You said: > Yes. I've indexed the database as suggested in the existing document regarding that issue.
I'm wondering if you could shed some light on this for me please... which document etc.. :) thanx VV -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Daniel Niklasson Sent: 17 May 2005 16:21 To: FarCry Developers Subject: [farcry-dev] Re: Help with optimization > What version of FarCry are you running? 2.3 > Have you optimised the database schema? FarCry installs by > default with no indices. Yes. I've indexed the database as suggested in the existing document regarding that issue. > You can apply CFCACHE flatfile caching to the primary > invocation url... > probably ../www/index.cfm -- this basically means you only > execute the Application.cfm. > > But typically a single db look up for an object display > should not pose too much of a burden on a correctly optimised > db schema. No it dosn't. But the contentobjectget bothers me when the page should be cached :) One strange thing thou, look at the following url: http://sportal.minsport.nu/time2.html ContentObjectGet is executed two times. And since the first thing I do in my display handler is: farcry.category.getCategories() (which should be the "qGetCategories" if I'm correct) the two contentobjectgets is done before the handler. > Turn off stats caching -- run your stats from web logs > instead of FarCry. Stats can be a performance hog. When a page is cached it takes about 300-400 ms. When it's not cached several seconds. The only thing Farcry does as far as I can see is that last "qInsertLog"? Daniel --- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to farcry-dev as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
