marksmithy69
Programmer
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.
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.
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.
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.
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.
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.