I have made a comparison between talking with a local database and via
100Mbit's network and im a bit suprised about the difference in speed
that i recieve on these two methods.
The hardware is about the same on both the local-db and the
network-db. Windows 2000 Professional with SP3 running SQLserver 2000
NIC's are Intel's S-Pro on both ends connected via a hub.
If i make a lengthy query to be able to see the difference, the
difference is on certain tough queries 2 on local db and 15 across the
I did all to make it fair, restarted machines between the queries so
nothng is cached.
Calling with ADO 2.5 from VB wth OLE-DB connection
How can it be that the difference is so huge !? normal FTP-traffic and
also normal file-copying across the machines show that it is around
7-9 Mb per seconds so i am running 100mbit.
Tried to change the Packet Size in the connecting string from
defaulting 4096 to higher values but no difference at all seen.
Any guru can give me an optimization tip, replication to a local db on
non critical data is a good solution, but that can't be done for
everything so im eager to get some speed from it all.
Thanks for any reply
Staffan - Sweden