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 ========= ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ 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.
