Ian, One possibility is name resolution. The server is "nasserver-01". The question is, how does the web server "find" this server? Are you using AD or Wins or host, or DNS or what? A lengthy but predictable delay probably means that it is "trying" one method of finding the server (like checking wins) then trying the next method (probably broadcast) which is successful. Make sure resolution is the same on both servers. Then make sure that networking is the same as well - for example, sitching, duplexing and bandwidth levels.
-mark -----Original Message----- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 2:23 PM To: CF-Talk Subject: Access Connectivity Issue Can anybody point out avenues of investigation on why a simple query to an access database located on a network fileserver takes 1/10 of a second to run on one CF server and ~20 seconds to run on a second? Query: <cfquery datasource="ISINV_TEST" name="Testing" debug="yes" result="metrics"> SELECT * FROM Equipment WHERE smfid = 102619 </cfquery> UNC Path in Access DSN definition: \\Nasserver-01\PC Applications\IS Inventory\dev\is inventory.mdb When I run this from my workstation machine it takes about 1/10 of a second. When I run it from the development box it takes about 20 seconds. I've tried to verify that every thing is the same between the two systems and I can not figure out why the difference times. -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA --------- | 1 | | --------- Binary Soduko | | | --------- "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241255 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54