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.
