> Storing in a database, SQL 7, not much data, this is the first page you go
> to, so there are no variables stored there yet, and it is set to expire in
> 10 days. It isn't slow once it is cached, but the very first time you go
> there it is horrible.

Hmmm...  I wouldn't think it's your client variables.  I've never seen this
behavior before.  Do you have debug turned on in the cfadmin?  Have you
looked to slow queries?  Have you looked at the exploded benchmarking for
each individual template to verify which file may be causing this?

Perhaps break codebits out that you think may be slowing things down and
temporarily stick them into a separate file.  CFINCLUDE that file where the
code use to be.  Watch your exploded benchmarking.  Is that the faulty code?

How about Service Packs?  Do you have SQL Server SP3 installed?  NT SP6a?
Recent ODBC drivers?  Anything out of date could cause a slowdown or other
non-optimized behaviors...

-Cameron

--------------------
Cameron Childress
elliptIQ Inc.
p.770.460.1035.232
f.770.460.0963
--
http://www.neighborware.com
America's Leading Community Network Software
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to