I have an application that was developed for a client. For needed purposes, it is a Winforms application written in C#. In the morning a technician can download a service order off of the main sql server database....it is then loaded on a remote database (access) on their remote machines. They can work offline to complete the service order and then upload.
The question is....this works great if the remote machine has windows 7 on it. If it is on Windows 8 or Windows 8.1....the download and upload take forever. In other words, on windows 7 a download would take about 10 seconds or less. On Windows 8, the same service order would take over a minute or two. Uploads are even worse. For Windows 7 service orders upload in less than 10 seconds. On windows 8....the same service orders can take over 10 minutes.
I should add....that to download the "service order" , I simply do a select against the needed tables in the sql server database and then do an immediate insert into the remote database. This is done on about 10 tables for each service order.
I have racked my brain to try and figure out what I am missing. Any thoughts out there very appreciated.