ODBC Linked Tables

[marksmithy69]

Hi, I would really appreciate any suggestions that might help solve this problem I've been having. I had an Access database on an old NT Server that had ODBC linked tables connected to some dbf files. I also had a few queries set up which accessed these tables.

Last month our company bought new Windows 2003 servers, which are much more powerful. I have migrated the Access databases to the new servers, and the queries that I ran previously on the old NT server now take much, much longer to complete. All other applications that I migrated from the old server to the new are much faster though. The dbf files are stored on another server, so they are being accessed the same way as they were in the old NT environment. The driver that I have been using to access the dbf files is Microsoft FoxPro Driver version 6.01.8630.01.

Does anyone have any idea why the performance would be so much worse on a server that is so much faster? Thanks very much in advance.

 

[jsteph]

Generally, if the bottleneck was the ODBC connection, then a faster processor won't do a whole lot. The fact that this now runs slower, points possibly to the network connection. The other apps that are faster--do they have odbc connections or access files over the network?

I ask because we had similar issues--a new 2003 server, but painfully slow network access. The problem there was that we had teaming nics that were somehow colliding with each other, once we went to a single network card, everything was much, much faster.

--Jim

 

[marksmithy69]

Thanks for the reply. I don't believe it to be a network issue since the other applications also access files on other servers and they are much faster, although not via ODBC. The dbf files have remained on the same server as they were before we switched the databases to the new 2003 server. The odd thing is, when I double click the dbf tables within Access, I get data quicker in the 2003 server version that I do on the NT box. Seems that Select queries, and especially Select Into queries are taking much longer to run on the 2003 box though.

 

[marksmithy69]

To add another element to this problem, the query returns different numbers of records each time I run the same query using the same tables. I'll run the query and it will return 500 rows, and 30 seconds later I will run it and it will return 498 rows and so on. The tables are static so the row count should be the same.