You shouldn't ever use the registry as your client storage mechanism!!!
The
registry is used by the operating system and clogging it up often has
serious repurcussions. I've seen systems go down because of this!
If you want to speed things up in the DB you can do two things...
1. Create and index on the CFID column for both tables (CGLOBAL and
CDATA).
The query currently does a table scan to find the needed info
2. Make sure that "Maintain Connection" is checked for the DB you are
using
for client storage.
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may
have
peace'..."
- Thomas Paine, The American Crisis
-----Original Message-----
From: Ian Lurie [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 3:57 PM
To: CF-Talk
Subject: RE: Slow CF response times?
Robert, you da man. I sit corrected - we were using SQL Server 2000 for
client storage. I switched to registry storage as an experiment, and it
s
ped
right up.
Did you just create a new client var store, or actually reinstall SQL
Server...?
-----Original Message-----
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 3:28 PM
To: CF-Talk
Subject: RE: Slow CF response times?
I had this problem when I used client management with an external
databas
e.
I reinstalled the database and it made the response time what I
expected.
Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire
-----Original Message-----
From: Ian Lurie [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 6:20 PM
To: CF-Talk
Subject: Slow CF response times?
Hi all,
I'm getting slow response times from CFM templates on a production
server.
Many of these templates execute in 150 ms or less on our dev server,
and
asp and .htm templates on the production server are showing up just
fine.
If you want to experiment, go to:
http://winpisinger.iamaw.org - that's a .html page.
Then go to:
http://winpisinger.iamaw.org/home.cfm
See the difference? What's weird is that home.cfm doesn't do ANY CF
processing. It's just an experiment to try to figure out why the
server's
so
slow?
The server is a dual processor Pentium III with 1024 meg of RAM, so
traff
ic
isn't the issue, either...
Any ideas?
Thanks,
Ian
Portent Interactive
Using Process, Design and Content to create great web sites since 1995
Consulting, design, development, measurement
http://www.portentinteractive.com
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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
