Performance tuning MS Access - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Click Here to Login
Closed Thread
 
Thread Tools Display Modes
 
Old 10-12-2004, 12:27 PM   #1 (permalink)
Newb Techie
 
Join Date: Mar 2004
Posts: 20
Default Performance tuning MS Access

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???
__________________

tglake is offline  
Old 10-12-2004, 02:39 PM   #2 (permalink)
It's all just 1s and 0s
 
office politics's Avatar
 
Join Date: Jan 2004
Location: in the lab
Posts: 6,555
Send a message via MSN to office politics
Default

is it just one db? do you have others on the pc that are running fine?
__________________

office politics is offline  
Old 10-12-2004, 04:06 PM   #3 (permalink)
Master Techie
 
Join Date: Jul 2004
Posts: 2,932
Default

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?
__________________

-----------------------------------------------
Don\'t hate the player...Hate the game...
ShoobieRat is offline  
Old 10-13-2004, 10:15 AM   #4 (permalink)
Newb Techie
 
Join Date: Mar 2004
Posts: 20
Default

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?
tglake is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off




Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 07:06 PM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.