Cache the cfa_browser results in session scope and only execute it once for all page hits for one user. Of course if you have lots of users who only hit the site once in a short duration this won't be a winner.
Rich ----- Original Message ----- From: "Johan Coens" <[EMAIL PROTECTED]> To: "Spectra-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 16, 2002 7:50 AM Subject: search (and cfa_browser) is killing your website > Hi all, > > I'm breaking my head over the search (type_search) functionallity in > spectra. For now we have built a few 'large' websites, they all have > searching functionallity for the user. The search does a type search through > a few types (5-10 types) with the keywords entered by the user. > > Unfortunately I notice that the search is a true killer for your websites > performance. Even other templates run whithin 200-400 ms, a 'difficult' > search can take up 100+ seconds! even if we optimize and re-index the > collection every night. > > The most performance is eaten by the following tags (example times are > shown): > 27937 ms \ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\CFA_ISACTIVE.CFM > 20092 ms > \ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\OBJECTSTORE\CFA_CONTENTOBJECTCACHER > EADMULTIPLE.CFM > 20579 ms > \ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\OBJECTSTORE\CFA_CONTENTOBJECTGETMUL > TIPLE.CFM > 25032 ms \ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\SEARCH\CFA_TYPESEARCH.CFM > > We run Spectra 1.5.1 with hotfixes installed on a NT4 machine with > SQL-server. > > I also notices <cfa_browser> is a performance killer for your website if you > have many users (1 sec for each pagecall). I think it is due to the fact > that the server.cfa.browser structure is duplicated whithin each page-call > with <cfa_browser>. If your site has over 3500 different browsers visitors > within 1/2 hour, this is killing.... We now use are own <cfa_browser> like > tag. > > Does anyone got suggestions for improving the search performance? > > Regards, > > ========= > Johan Coens > <theFactor.e> > > Premium Partner for Macromedia > > "Imagination is more important than knowledge. Knowledge is limited. > Imagination encircles the world." > Albert Einstein > ========= > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
