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:241247
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
