[AccessD] Anyone used dbSync?

[John Bodin]

That s/b alright.  Lot of other factors that could affect performance (Ram, hard drive speed, other software on the server like Exchange, # of users making I/O intensive requests, etc.)  I would lean more towards the ADO idea as the server is not really that old.

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

You know the area...

The switch is aDLink DGS-1224T, which is a gigabit switch. The NIC cards in the server are both gigabit cards. Is that good enough to feed a cat5 network?

Thanks,
Fred
> John Bodin <mailto:jbodin at sbor.com>
> Monday, November 02, 2015 2:37 PM
> 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.
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com