MSSQL – What Exactly Does It Mean?

Posted by Colin Wynn on Oct 3, 2011 in Move Administer, The Future |

Microsoft SQL ServerWell as per our Press Release – September 2011, MSSQL will provide increased stability, portability and more importantly speed. Speed is something we have been testing of late and we would like to share our results with you.

We took a client’s activity audit data file comprising of 423,189 records for more than a single trading company and ran the following tests which returned data from all fields with in the file:

Test 1
Return all accounting activity for the year 2010.
Clarion returned 75,608 records in 9 seconds.
MSSQL returned 75,608 records in 1 second!

Test 2
Return all accounting activity for the year 2010, but for a single trading company.
Clarion returned 21,651 records in 7 seconds.
MSSQL returned 21,651 records in 1 second!

Test 3
Return all sales accounting activity for the year 2010, but for a single trading company.
Clarion returned 13,518 records in 6 seconds.
MSSQL returned 13,518 records in 0 seconds!

Test 4
Return all records.
Clarion returned 413,459 records in 56 seconds.
MSSQL returned 413,459 records in 9 seconds!

I’m sure you’ll agree that MSSQL has returned some pretty impressive times, but we would just like to end this snippet of information by stating all tests were ran over our network – which makes MSSQL very impressive indeed, especially as no fine tuning has been done!

Share

Leave a Reply

Your email address will not be published. Required fields are marked *

Copyright © 2005-2024 The Development Blog All rights reserved.
Desk Mess Mirrored v1.6 theme from BuyNowShop.com.