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 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
