COGetMultiple used to have a problem in the original version of Spectra. I don't know if it has been fixed. It used to select / retrieve up to 10,000 records (by default) from the type and then programmatically restrict the records to return by using the specified criteria. We had to stop using COGetMultiple because we had over 10,000 records in the type and weren't getting everything we were supposed to. This was aside from the long retrieval times.
Nancy -----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_RECORDSELECT.CFM > > > > > 194765 ms > > /OPT/ALLAIRE/SPECTRA/CUSTOMTAGS/SYSTEM/TIER0/OBJECTSTORE/CFA_CONTENTOBJE CTGETMULTIPLE.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_sitemodelc reatestruct.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 > > > > > > > > > > > > > > > > > > > > > > > > > > > ______________________________________________________________________ Macromedia ColdFusion 5 Training from the Source Step by Step ColdFusion http://www.amazon.com/exec/obidos/ASIN/0201758474/houseoffusion ------------------------------------------------------------------------------ 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.
