MS Access and RAM disk?

[OspreyO]

Ok I know this not the way to do things, and it should be on MS SQL, but humor me. I'm just playing with this.

I'm running a MS Access database on a ram disk, on Windows 7 64bit. I've about 1.5MB on the RAM disk out of 4GB total. This in a i3@4Ghz. Being single threaded (MS Access) its mainly using only core, but CPU usage is about 30%, its using only 60% of Physical memory, and its still hitting the HD constantly. Its not paging, so is it a case of no matter what I do MS Access will always use the HD?

As an aside, All my Windows 7 system seem to have constant disk activity even when idle. I've never got to the bottom of that.

 

[d_brennen]

The disk activity is system maintenance (defragging/indexing etc) so it may be a good idea to turn those off for ram disk use. I've never used one but I imagine it would be the same settings as you'd use for a non trim ssd...

Indexing off, paging to another (physical) drive if possible, defragging disabled (the drive removed from the schedule). This could be wide of the mark as I've no experience of ram drives

Access is a disk hog in my experience though.

 

[OspreyO]

I don't have disk indexing or defragging on.

I thought by having the Access DB on the ram disk, it would have no reason to access the disk at all.

I though the CPU was waiting on the HD thats why it only used 30% of the CPU.