Selasa, 30 Juni 2015

[MS_AccessPros] Msaccess and solid state disk (SSD)

 

Dear pro's,

I recently put an SSD in my Computer. The OS (win7) is on that disk and the system starts remarkably faster.

 Now I thought that my msaccess application would profit from that, so I put it on my C:\ disk. I ran a query that invokes a user defined function (VBA) and ran on the original disk for 50 seconds. Result: on the SSD it runs 6 minutes!  Much slower!  Besides that  no performance improvements, so I switched back.What ere your experiences with SSD disks? Is it no good idea to put your database on it? Or are there other caveats that you should take care of.?

Is it possible or not?


Kind regards,


Onno Knol

__._,_.___

Posted by: onno.knol@pbl.nl
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar