[dba-VB] [AccessD] Apples to Oranges

jwcolby jwcolby at colbyconsulting.com
Mon Oct 4 16:36:49 CDT 2010

With an index, both databases took 2 seconds to return the results.

John W. Colby

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

More information about the dba-VB mailing list