jwcolby
jwcolby at colbyconsulting.com
Mon Oct 4 17:05:13 CDT 2010
One pass of the query that updates the ' ' (space) to null value takes about 5 minutes on the SSD, whereas it takes about 30 minutes minutes on rotating media. I am not pursuing actually doing this on the SSD over nagging concerns about hot spot wear. However a actually need to do this for about 540 fields. At 1/2 hour / field... this will be running for the next month. John W. Colby www.ColbyConsulting.com On 10/4/2010 5:36 PM, jwcolby wrote: > With an index, both databases took 2 seconds to return the results. > > John W. Colby > www.ColbyConsulting.com > > On 10/4/2010 5:16 PM, jwcolby wrote: >> I On the new server, have the same database on my SSD (two drive) raid 0 and a rotating media (2 >> drive) Raid 0. >> >> There is a clustered index on the PK as the index key. >> There is no index on the FieldX, forcing a field scan. >> >> I did a simple count PK Group By FieldX on both database files. >> >> The SSD returned the counts in 1:31 >> The rotating media returned the counts in 8:58 >>