Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2003
    Location
    wisconsin
    Posts
    4

    Question Unanswered: slow db update on network share

    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

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465
    How many computers are in the network ?
    How many users are in the Access Base ?
    Saludos
    Norberto

  3. #3
    Join Date
    Sep 2003
    Location
    wisconsin
    Posts
    4
    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.

  4. #4
    Join Date
    Jul 2002
    Location
    Romania
    Posts
    122
    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

  5. #5
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465
    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.
    Saludos
    Norberto

  6. #6
    Join Date
    Sep 2003
    Location
    wisconsin
    Posts
    4
    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

  7. #7
    Join Date
    Sep 2003
    Location
    wisconsin
    Posts
    4
    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
    <<

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •