[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.
>