[AccessD] Apples to oranges take 2a

Lambert,

Thanks for that article.

It is interesting that this author describes the flash write lifetime as "well over a million".  I 
intensely studied the current literature and came to the conclusion that MLS is pretty much quoted 
as 10K and SLC as 100K.  Both well south of 1 million.

10K is not a large number.  1 million is.  I don't know which to believe.

What I am going to do is to grab my old 32 gig SSD and use it as my tempdb disk.  The point of the 
ssd is that reads and writes are fast and IOPS are startlingly high.  If SSDs are in fact durable, 
and we can move the tempdb and log db to them then we have a huge win.

Unfortunately for me, I still have the issue of database size.  While I have managed to get the 
"empty space" issue under control, I can still end up with log files many times the size of the 50 
gig data file if I do heavy manipulation.

John W. Colby
www.ColbyConsulting.com

On 10/7/2010 10:53 AM, Heenan, Lambert wrote:
> Here's an interesting article on the lifetime question...
>
> http://www.storagesearch.com/ssdmyths-endurance.html
>
> Lambert
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
> Sent: Thursday, October 07, 2010 10:22 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Apples to oranges take 2a
>
> Fascinating study.
> Which SSD (make/model) was used ?
> What is the typical lifetime duration of an SSD ?
> Do these devices have an early-warning system to determine when they need to be replaced ?
>
>>
>> Same two files, rotating / SSD.
>>
>>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>