Just a thought but check the power management on your machine running sql
make sure that the hdds are not going to sleep
-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 02, 2002 9:08 AM
To: CF-Talk
Subject: RE: Problem with 1st hit to MSSQL 7.0
I had this problem before, try putting on the service pack for SQL again. I
use client variables and when I have this problem I get that hit right away
when I hit my application. It's very annoying.
Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire
-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 5:55 PM
To: CF-Talk
Subject: Problem with 1st hit to MSSQL 7.0
Hi all,
The first query to my MS SQL server 7.0 always takes a long time, like
14000ms.
After the first hit to the DB it runs fine, until about 20 mins of idle
time. Then the next hit to the DB takes about 14000ms again. So its like
the first hit to the DB every session takes an extremely long time.
The query could be as simple as:
SELECT *
FROM Users
WHERE UserID = 25
There are maybe 40 records in the user table and maybe a dozen fields.
Im thinking there is a configuration/performance setting im missing, or
something. Ive tryed checking and unchecking the Maintain database
connections in the CF administrator, but it doesnt effect my problem.
Any ideas?
Thanks,
Jeff
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
