Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ODBC calls to database on network drive

Status
Not open for further replies.

eljainc

Programmer
Mar 23, 2004
3
0
0
US
Hello,

I have written a C# application which uses simple SQL calls through a Faircom ODBC driver. The database resides on a Windows Server 2008 R2 hard drive and the data. When this application is run on a test machine without the server it takes about 0.2 seconds to load roughly 75 records. When it is running from the server it takes 10-20 times longer to load those same 75 records. Is there any way this can be sped up? I don't know if it is a file server issue or an ODBC driver issue.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top