speeding up Access DB

[Mark floating in Space]

Hey,

 

I am currently working with an Access DB with roughly 50.000 entries which amounts to approximately 580mb so really not a lot. Furthermore I am running it from my local computer at the moment so there really isn't any bottlenack in terms of server or lan connection. However, it is still pretty slow. Like when you open a form for example to input or edit information it sometimes takes a couple of seconds. Do you have any idea how I could solve this?

 

I am very grateful for any suggestuions! Thank you for your help in advance! (=

[Windows7ge]

A 7200RPM HDD (hard drive) has a max sequential read of around 150-175MB/s it would take it a few seconds to load a 580MB file. An SSD can read/write in the 500MB-600MB/s range which would potentially help load your files faster. Provided your motherboard has a SATAIII port available.

[Mark floating in Space]

11 minutes ago, Windows7ge said:

A 7200RPM HDD (hard drive) has a max sequential read of around 150-175MB/s it would take it a few seconds to load a 580MB file. An SSD can read/write in the 500MB-600MB/s range which would potentially help load your files faster. Provided your motherboard has a SATAIII port available.

Oh yeah that is kinda obvious I put the DB on my ssd and it really is a lot quicker. But access doesn't need to read the whole db for opening a from - i mean the froms use a handful of lookup-tables but not nearly all data. Do you have any idea why the opening of the forms is still depending on the read performance of the drive?

[Windows7ge]

Do you think it's possible that the size of the databases you worked with in the past were smaller? It might have always scanned the entire database for the files you want but this time a 580MB database proves a challenge. As for why it depends on the read performance of the drive, I can only guess it has to load the full database to lookup the forms you want. If you say it doesn't then...I'm lost for thought, sorry. I've had a little experience working with Microsoft Access but not nearly to the scale of almost 600MB databases I can't vouch if it's just the fact that it's a large file. 580MB is quite a bit for a HDD to load. Keep searching though, remember Google is your friend if we can't help.