Selasa, 30 Juni 2015

Re: [MS_AccessPros] Msaccess and solid state disk (SSD)

 

Onno-


First reaction: No WAY!

Are the hard disk and the SSD on the same system?  How much free space is there on the SSD?

When you ran your query tests, did you start from scratch both times?  In other words, start Access, open the database, run the query.

Also how much memory do you have on your computer and what else was running during each test?  It has been my experience that Access desktop performance is most highly impacted by the amount of memory available.  Access actually spends as little time as possible fetching stuff from the disk - it tries to do as much as possible in memory.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On Jun 30, 2015, at 12:32 PM, onno.knol@pbl.nl [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: John Viescas <johnv@msn.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

.

__,_._,___

Tidak ada komentar:

Posting Komentar