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_RECORDSELECT.CFM > > > > > 194765 ms > > >/OPT/ALLAIRE/SPECTRA/CUSTOMTAGS/SYSTEM/TIER0/OBJECTSTORE/CFA_CONTENTOBJECTGETMULTIPLE.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 > > > > > > > > > > > > > > > > > > > > > > > > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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.
