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

 

Onno-

I use hard drives for my servers only.  My last several laptops have all had SSD or the equivalent.  (My Macbook Air has Flash storage that's super-fast.)  There are "junk" SSD's out there.  What make and model did you get?

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 

http://www.viescas.com/ 

(Paris, France)

On Jul 1, 2015, at 11:49 AM, onno.knol@pbl.nl [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

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?

Kind regards,

 

Onno

---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

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 

http://www.viescas.com/ 

(Paris, France)

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: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (7)

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___