Databse is too slow

[bronson_mech]

Hi guys,

my database is too slow if i click any form or query it is taking more than 5mins i have more than 20thousan records in my database & it is a multi user. is there any option make my database to run fast....


please help me to rectify it....

[June7]

20,000 records is not much.

Is this a split design with each user running their own copy of frontend?

[bronson_mech]

S its an split design with each user running their own copy of frontend....

[ranman256]

We had this condition happen because of the anti-virus on the network. It sucked ALL our computing resource on the db.

[bronson_mech]

is there any option to make my database to run fater/normal....?

[ranman256]

It could be many things....

It could be the network,
or db connection
or anti-virus (if you can disable it temporarily)
or db usage on other users.

[June7]

Conduct tests.

1. Copy of frontend and backend on a computer at C: root. Change table links to this backend.

2. Make copy of frontend and import data into local tables. Run this db on computer C: drive.

[RuralGuy]

Here's a link to several suggestions: http://www.granite.ab.ca/access/performancefaq.htm