[AccessD] SSDs and BE storage

Hi John,

A few months ago I switched to using an SSD for the Windows 7 OS and
applications, and a WD Black HD for data storage.  And yes, things are
significantly faster.  If I had a 2nd gen Intel CPU I'd see another jump in
speed.  But the way it is now, every Access file I open is up in about 1
second (if it doesn't have startup code).  VS 2010 takes about 35 seconds to
open and a VS app takes about 5 seconds to open.  

If you're going to all SSD, then you'll see a dramatic difference.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, September 20, 2011 7:10 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] SSDs and BE storage

Well, it seems I will be answering this question in the next few weeks.  The
client is building a server in the next couple of weeks, which will include
a raid1 SSD as the data store.  Phase 1 of the story will be to move the
access BEs to that SSD and use that while we migrate the data into something
else (MySQL maybe).

My FE / framework logs the start / stop time  when opening forms so it
should be easy to discover whether the SSD makes things significantly
faster.

John W. Colby
www.ColbyConsulting.com

On 9/14/2011 10:54 PM, jwcolby wrote:
> Does anyone have experience with using an SSD (or SSD RAID) to store 
> the Access BEs? Does it significantly speed up the database?
>
> My client has a pretty large (by Access standards) database. It is a 
> call center application and they do mostly reads (viewing claim data 
> as they talk to the client), but do a fair amount of "documenting" the
phone calls by writing notes. About 25 users in the database all day.
>
> It seems logical that the SSDs enormous IOPS and streaming reads would 
> speed things up but I have never seen any actual studies or documented
usage data.
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com