Slow performance after database move

[Robin9876]

After moving a backend access 2003 database from a linux server in a
local office, to a Windows file cluster on a WAN with a 100Mb
connection the performance of the split access database now takes 15
seconds to open a form with an individual record.

There is plenty of bandwidth available and the client pc's have plenty
of resources available. The Client PC is XP and has Office 2003 both
with the latest service packs.

The backend database on server was in a location 3 folders deep and
all longer than 8 characters. I there relinked the tables to use the
8.3 notation which slightly speeded the system up.

As I am told there are plenty of network bandwidth available is the
change of data file location causing this significant performance
issue?

What other changes can be made to help improve the speed?

[Jeff Boyce]

Do an on-line search on "MS Access" and "WAN". I think you'll find strong
recommendations against trying to run an Access application over a WAN.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Robin9876" <robi...@hotmail.com> wrote in message
news:1667b868-3c08-4e1c...@p25g2000hsf.googlegroups.com...

[david@epsomdotcomdotau]

It's not the size of the bit that matters. It's not the number
of bits that matter. It's the length of time it takes a bit
to go from your machine to the server and back again.

Provided your network is not overloaded, that is about the
same amount of time on a 100Mb network as on 2Mb
network. The bit difference is the number of bits you can
send in the same time, not the length of time it takes to
get a reply. On a WAN the time is dominated by other
factors.

Having said that, are you sure it is 100Mb all the way?
If it is, you want the server to be on the same subnet,
you want to maintain a connection (using an open table),
you want packet signing turned off, and you may need
to adjust your Anti-Virus scanning.

(david)

"Robin9876" <robi...@hotmail.com> wrote in message
news:1667b868-3c08-4e1c...@p25g2000hsf.googlegroups.com...

[Armen Stein]

On Sat, 30 Aug 2008 23:02:16 +1000, <david@epsomdotcomdotau> wrote:

>Having said that, are you sure it is 100Mb all the way?
>If it is, you want the server to be on the same subnet,
>you want to maintain a connection (using an open table),
>you want packet signing turned off, and you may need
>to adjust your Anti-Virus scanning.
>

As David says, it would be good to actually check the network
throughput (is it really 100Mb? That's really fast for a WAN). You
can get speed measuring tools, but for a *really* rough idea, just
time how long it takes to copy a large file over the WAN. Multiply
the size of the file by 8 to get bits, then divide by the number of
seconds for the transfer. That's a rough approximation of your bits
per second.

And even if it is 100Mb, as David indicates the latency is another big
issue. Access applications by default are very "chatty" - they send
lots of chunks of data back and forth over the wire. Latency will
really hurt you here, even if throughput is good.

For example, with a satellite internet connection you can watch a
movie on your PC - it has enough throughput once it gets going. But
the latency is very high, half a second or more! So Access would have
a terrible time.

Hope this helps,

Armen Stein
Microsoft Access MVP
www.JStreetTech.com