[AccessD] Anyone used dbSync?

[John Bodin]

Ah, they must have spent too much time at the Beachcomber in Wellfleet...

On hardware, I'd get the model of the switch to make sure it is gigabit.  You can probably just hover your mouse over the networking icon in the system tray on the server and see what it says for connection speed.

On software, you want SQL Server to do all the heavy lifting and only return the results.  With Access, it pulls all the tables locally that you are querying and then performs the action. Check what Dan is providing for options, especially the ADO option.  

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Fred Hooper
Sent: Monday, November 02, 2015 2:13 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Anyone used dbSync?

Thank you John, I didn't know that. They have a 5-year old DLink 24-port switch, that I assume is a gig. Their server is a small Dell of the same age, probably also with gig ports. When I started looked at their network, they mentioned that every network company they've ever used is out of business a year or two later (they're on Cape Cod).

Do you have any recommendations if (as I now expect), the network speed shows only small improvements after the cable change, for the switch and/or the ports?

Thanks,
Fred
> John Bodin <mailto:jbodin at sbor.com>
> Monday, November 02, 2015 1:39 PM
> Fred, on the cable change, the Cat5 and Cat7 ratings will not help you 
> if the switch the server is connected to can only go 100meg or even a 
> gig (Cat 5 will still get you fine throughput at a gig). The switch 
> will be the bottleneck. If on the other hand you have a 10gig switch 
> that the server is connected to and 10gig ports on the server, then 
> the better cable will aid you there, and then whatever speed network 
> card the users have (typically a gig) will dictate how much and how 
> fast they can connect to the network to send/receive data. Good luck.
>
> John
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com