I am using a VB 6 application with DAO 3.51 Jet Engine. The database is located on a Server. I have changed the old server (Windows NT 4) to a new Windows 2003 small business server. With the old NT server saving an invoice (within a transaction) was 5 to 10 times faster than with the new server. Both servers are domain controllers. What as changed?
Signed network packets (a security measure) require packet serialisation, which means each database lock has to wait for the previous database lock to go the server and back again. SBS has network packet signing turned on by default because it handles user profiles, including group policy objects. Sometimes you can get most of your speed back by going through and doing other optimisations. Look at Tony's Access pages for suggestions: http://granite.ab.ca/access/performancefaq.htm (david) "Georg" wrote in message news:DDAEBD68-4334-457F-8351-FE1E8EE44473@microsoft.com... > I am using a VB 6 application with DAO 3.51 Jet Engine. The database is > located on a Server. I have changed the old server (Windows NT 4) to a new > Windows 2003 small business server. > With the old NT server saving an invoice (within a transaction) was 5 to 10 > times faster than with the new server. Both servers are domain controllers. > What as changed?
