And why this ?: qGetRecords (Records=103, Time=62964ms) SQL = select propertydefinitionid, label, propertydescription, propertydatatype, propertyinputtype, propertydata, attribs from propertydefinitions
Regards "Huzir Sulaiman (s21019)" wrote: > 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 > > > > > > > > > > > > > > ______________________________________________________________________ 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.
