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)
> 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?