Database speed:

  • Thread starter Thread starter Pramod
  • Start date Start date
P

Pramod

Hi,
Happy New year to all.

I wanted to measure the bytes accessed Vs Time, across
LAN, for Access XP database.
 
That would so much depend on so many different factors that it would be a
useless result. Some factors include: requirements, design, and
implementation of the database application, and the hardware, software, and
network environment. It would also depend on whether you are using a split
Access-Jet multiuser database, or an Access client to a server Database (and
whether that was using MDB-Jet-ODBC or ASP-ADODB).
 
I have got maintenance Access project. This database in
one shared folder of network. Users creates shortcut of
same and use it. A database contains objects like forms,
rpts, queries, macro, tables more than 40 each. This
design gives problem of locking and crashing the database.
To solve the same, I will be splitting in Front-Ends and
Back-Ends. Hope this will solve my problem. I have to
submit document of the Network Speed before and after
splitting the database i.e. No of Bytes(records) Vs Time
(Millisecs or seconds) or atleast some figures. At least
want to show the network traffic has reduced. My question
was, is there any utility or code segment will give the
same against query or forms?
 
Pramod said:
I have got maintenance Access project. This database in
one shared folder of network. Users creates shortcut of
same and use it. A database contains objects like forms,
rpts, queries, macro, tables more than 40 each. This
design gives problem of locking and crashing the database.
To solve the same, I will be splitting in Front-Ends and
Back-Ends.
Click to expand...

Splitting will definitely help with corrupting the database. What do
you mean by locking?
Hope this will solve my problem. I have to
submit document of the Network Speed before and after
splitting the database i.e. No of Bytes(records) Vs Time
(Millisecs or seconds) or atleast some figures. At least
want to show the network traffic has reduced. My question
was, is there any utility or code segment will give the
same against query or forms?
Click to expand...

Sounds to me like the person requiring this information is a PHB.
(Dilbert's Pointy Haired Boss.). This is like requiring someone to
record the gas consumption while they drive over a curb. If you stop
driving over a curb that should drastically slow down the frequency of
repairing the vehicle.

BTW see the Access Performance FAQ at my website. The LDB locking
problem will likely rear it's ugly head as soon as you split the MDB.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top