Hey, Bryan, you know me better than that :) I was just doing it as an easy test...
-----Original Message----- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 4:35 PM To: CF-Talk Subject: RE: Slow CF response times? 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
