Performance tuning MS Access

Status
Not open for further replies.

tglake

Solid State Member
Messages
20
I'm trying to cure a slow running MS Access db.

I am running a

- 3.2 Ghz P4
- Dual RAID 0 SATA
- 1 Gb RAM

The time to open some forms can be up to 30 secs.
CPU usage never clocks above 20%
I can't believe it's the Hard disk

where's my bottle neck going to be???
 
How big is the DB?

What kind of stuff are you storing?

When's the last time you've run a re-index?

How many tables do you have linked to the table you're trying to open?

Any hyperlinks?
 
How big is the DB?
I have
- one apps db with the forms, queries, reports = 12mb
- one data db with the tables = 24mb

What kind of stuff are you storing?
- 10,000 customer records and a few financials

When's the last time you've run a re-index?
- never. I suspect the indices may be a factor here

How many tables do you have linked to the table you're trying to open?
- I'm opening a form which is built on about 5 tables, all normalised, and linked from the data db

Any hyperlinks?
- nope

is it just one db? do you have others on the pc that are running fine?
- see above. I have several other dbs that run OK, but where we have large data volumes or complexity in the forms it gets slower.

What I don't understand is where the bottleneck lies in my PC spec. If the CPU is only up at 20% what is slowing things down?
 
Status
Not open for further replies.
Back
Top Bottom