Increasing access speed over network

[Guest]

Hi

I have indexed all the fields that are used for searching and sorting in my
db but yet it runs really slow over the network. There are only a few
thousand (1-3k) records in the db and only a max of 4 users using it at once
but yet it is still really slow. Mainly it is when u go onto a data entry
form it can take more than 5 seconds some times. I am usign access front end
linked to access tables. Do u have any suggestions to help me increase the
speed of the database as it is really annoying when using it?

Cheers

Danny

 

[Albert D. Kallal]

You don't mention what kind of network you are using.

If you are using a wide area network, then likely your network is too slow

You can read about this here:
http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

However, if you are talking about a standard LAN in your office, then you
need to do two things:

First, check your setup for performance. There is a great list here:
http://www.granite.ab.ca/access/performancefaq.htm

After you checked the above list, then the next thing to do is split your
database
This concept is explained here:
http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

After all of the above, if have a good network, then performance becomes
that of good (or bad) design...

Further..how well are the forms designed?

How well does the application work with 5 users..and then when you jump to
10 users...how much a slow down to you notice?

A few things:

Having a table with 75k records is quite small. Lets assume you have 12
users. With a just a 100% file base system (jet), and no sql server, then
the performance of that system should really have screamed.

Most forms, and most operations should be near instant....

I have some applications out there with 50, or 60 HIGHLY related tables.
With 5 to 10 users on a network, response time is instant. I don't think any
form load takes more then one second. Many of those 60+ tables are highly
relational..and in the 50 to 75k records range.

Mind you, with such small tables where you have 75,000 records, then one
should not expect much of a delay in forms loads etc.

So, it is not clear why you have a performance problem, but check the
above links....