Make sure you've applied the patches from spectrasource.macromedia.com. There are quite a few table indexes included.
In addition, if you are using client variables stored in a database then make sure that CDATA and CGLOBAL are properly indexed and purged. Unless you know for sure that the query in contentobjectgetmultiple is causing the problem it could be interrelated. We ran into this recently where the CF server was not purging our client variables, even though we set up the server to purge them every 15 days. In addition, the table indexes were missing on CDATA and CGLOBAL. What we saw from debugging was many different Spectra tags running slowly. Hope you find the problem soon. regards, Dave Gallerizzo VP, Consulting Services Fig Leaf Software "We've got you covered" (P) 202.797.5447 (F) 202.797.5444 (efax)(413) 208-4106 Cell 202.438.7270 Pager [EMAIL PROTECTED] www.figleaf.com > -----Original Message----- > From: Richard Ragan [mailto:[EMAIL PROTECTED]] > Sent: Sunday, March 10, 2002 2:37 PM > To: Spectra-Talk > Subject: Re: Webtop Error > > > The long running query you posted (qGetRecords) is most > likely in cfa_recordSelect which > doesn't say very much because that is a general purpose > routine to "select" records using > a query constructed by the caller. You need to better isolate > which part of your page > is chewing up the time in order to figure out what to do about it. > > You could try using GetTickCount( ) around the various > <cfa_container>'s to see > which one is using all the time. Once you know that you can > focus there. > For example, what rules are you using in that container? > > The query you posed that ran 62 seconds appears to be an > unqualifed retrieval > of all the records describing the properties of the objects > in your application. > I can't offhand see why that would run for 62 seconds to get > 103 records unless > something is wrong on the DB server end of things. You might > just try that same > query in a little test CF script that does just that and see > how long it takes. > > Rich > > ----- Original Message ----- > From: "Huzir Sulaiman" <[EMAIL PROTECTED]> > To: "Spectra-Talk" <[EMAIL PROTECTED]> > Sent: Sunday, March 10, 2002 9:14 AM > Subject: Re: Webtop Error > > > > standard method - teaser, full, etc.. > > > > Richard Ragan wrote: > > > > > Sometimes you just have to avoid contentObjectGetMultiple > and do a straight SQL query against > the > > > properties table to get things fast. Figure out which > COGetMultiple is taking the time and look > at > > > what it is trying to get. This may help understand the > speed issues. If you don't directly call > it, > > > what methods are your containers using that do call it? > > > > > > Rich > > > ----- Original Message ----- > > > From: "Huzir Sulaiman" <[EMAIL PROTECTED]> > > > To: "Spectra-Talk" <[EMAIL PROTECTED]> > > > Sent: Saturday, March 09, 2002 2:39 AM > > > Subject: Re: Webtop Error > > > > > > > Logging to the webtop shows the bottleneck comes from > CFA_CONTENTOBJECTGETMULTIPLE. It's > taking > > > almost 130 seconds to complete. > > > > > > > > Best Regards > > > > > > > > "Huzir Sulaiman (s21019)" wrote: > > > > > > > > > Guys, > > > > > > > > > > Second run of the same pages took around 4 seconds, > third run took around 2 seconds. After > > > putting the CFCACHE, it took around 0.7 seconds. > > > > > > > > > > It tooks longer after I restarted the cf server. Any > workaround ?. > > > > > > > > > > Best Regards. > > > > > > > > > > "Huzir Sulaiman (s21019)" wrote: > > > > > > > > > > > Guys, > > > > > > > > > > > > More info : 131454 ms > > > > /OPT/ALLAIRE/SPECTRA/CUSTOMTAGS/SYSTEM/COAPI/UTILS/CFA_RECORDS > ELECT.CFM > > > > > > 194765 ms > > > > /OPT/ALLAIRE/SPECTRA/CUSTOMTAGS/SYSTEM/TIER0/OBJECTSTORE/CFA_C > ONTENTOBJECTGETMULTIPLE.CFM > > > > > > > > > > > > isn't this two taking too long. I have only 5 > containers with around 50 objects in it. > > > > > > > > > > > > Best Regards. > > > > > > > > > > > > "Huzir Sulaiman (s21019)" wrote: > > > > > > > > > > > > > It seems running my spectra web sites(17 > tablespaces on Oracle 8i) on solaris 7 / cf 5 / > > > spectra 1.5.1 keep giving me this problem : > > > > > > > > > > > > > > An error occurred while evaluating the expression: > > > > > > > bSectionStructKeyExists = structKeyExists( > > > server.cfa.siteModel[siteModelServerScope].sections, > rootElementID ) > > > > > > > Error near line 112, column 9. > > > > > > > The member "SBNWEB" in dimension 1 of object > "server.cfa.siteModel" cannot be found. > > > Please, modify the member name. > > > > > > > The error occurred while processing an element > with a general identifier of (CFSET), > > > occupying document position (112:3) to (112:121) in the > template file > > > > > > > > /opt/allaire/spectra/customtags/system/tier1/sitemodeling/cfa_ > sitemodelcreatestruct.cfm. > > > > > > > > > > > > > > I have to restart the cf services everytime it > happens and it almost took an hour to > build > > > up the site structure and then dies again. > > > > > > > > > > > > > > Best Regards > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ______________________________________________________________________ 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.
