Upgrade to Win 7 Makes for VERY slow Queries
Posted on 2013-11-27
A client has an older line of business application, written in VB (or maybe Access, hard to tell) that uses Jet 3.0. The DB lives on a server, and the client machines have the app installed and connect to the data over the network.
Most of his clients were running XP machines, and we recently bumped everyone up to Win 7 Pro machines. When running his LOB app, the queries are noticeably slower, as much as ten times slower than they were on XP. In some cases, while running the query, the screen will "jump", and the query window will say "Not Responding" but will eventually come back with the information.
I have disabled the IP6 stuff in Networking, made sure everyone has a nice minimum 100M connection to the net, but the Win 7 machines continue to struggle mightily.
Any ideas at all? The Server is 2012.