slow db update on network share

polundra · #1 (**permalink**) 09-11-03, 12:12

I am noticing close-to-linear increase in db update delay with the db size increase (20Mb db takes 15s). MS Access Jet 3.51 db is on a network share on Win98. db update is done using recordset object and the update method.
Could you please advise on performance enchancements

Norberto · #2 (**permalink**) 09-11-03, 17:17

How many computers are in the network ?
How many users are in the Access Base ?

polundra · #3 (**permalink**) 09-11-03, 23:13

Quote:

Originally posted by Norberto
How many computers are in the network ?
>>The test is done with just 2 machine
How many users are in the Access Base ?

>>To eliminate effect of locking, the test is doen with single user accessing network share.

DannyY · #4 (**permalink**) 09-12-03, 05:54

Hmmmm...peer-to-peer network on Win 98...

1. What's the performance of the shared computer: hard-disk size, speed, free space? Can you upgrade it?

What's the performance of the client workstation: CPU, RAM? Can you upgrade it?

What's the network speed? Ethernet, Fast Ethernet, Gigabyte Ethernet?

Do you use hubs or switches?

What's the performance when opening a Word document from the shared computer when you update and save it?

Dan

Norberto · #5 (**permalink**) 09-12-03, 09:20

One computer with a local base off 100 Mb, the time is 5 seg.
In a NT 4.0 with Five users Access Base 300 Mb, the time is 12 seg - 15 seg.

polundra · #6 (**permalink**) 09-13-03, 00:00

Quote:

Originally posted by DannyY
Hmmmm...peer-to-peer network on Win 98...

1. What's the performance of the shared computer: hard-disk size, speed, free space? Can you upgrade it?
>> P3, 800MHz, 128 Mb, ~1Gb of free space. <<
What's the performance of the client workstation: CPU, RAM? Can you upgrade it?
>>It is P3, 64 Mb laptop. I'm looking for "software" solution for a given hardware. Also access delay is unnoticable if running program locally on either machine.

What's the network speed? Ethernet, Fast Ethernet, Gigabyte Ethernet?
>>Ethernet Connection is full duplex 100Mbps
Do you use hubs or switches?
>>Linksys router

What's the performance when opening a Word document from the shared computer when you update and save it?
<<Performance obviously slower than doing it locally but much better than db access from VB. Which is also expected since forming recordset and Update would take more time than open small size document.>>
<<Also, it is expected to have db Update delay rising with db size but is linear dependency expected for MS access (compacted) db?>>

Dan

polundra · #7 (**permalink**) 09-16-03, 10:14

Quote:

Originally posted by Norberto
One computer with a local base off 100 Mb, the time is 5 seg.
In a NT 4.0 with Five users Access Base 300 Mb, the time is 12 seg - 15 seg.

>>What is the time in seconds to change Recordset+update record for 100Mb db and 300Mb db over the network share connection?
Thanks
<<

Internet Services

Web Development

Digital Marketing

Consumer Tech