Hi John, yes it was a fair test, I copied the whole database and ran the query immediately after opening. tried it several times. Ram memory could be an issue, I only have 2 gig in my system. but then it would affect both types of disks equally, wouldn't it?
I also tried several harddisks, one from an USB connection and one build- in SATA. No big difference, only the ssd is 10 times slower ..
Did you ever try an SSD? What are your experiences?
---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :
On Jun 30, 2015, at 12:32 PM, onno.knol@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote: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 (6) |
Tidak ada komentar:
Posting Komentar