[dba-Tech] [AccessD] SSD, The Game Changer - SQL Man of Mystery - SQLServerCentral.com

Jim Lawrence accessd at shaw.ca
Sun Jul 3 14:13:03 CDT 2011


Hi John:

As your databases do not need do manage transaction queues or locks here is
an example of just one of the NoSQL database MongoDB vs. SQL Server 2008
performance showdown comparison.

http://tinyurl.com/38cofzg

In the article it shows speeds over 100 times as fast when managing a fairly
large amount of data but the performance just goes up exponentially when
presented with even larger data sets. (1000x and more...)

The Cassandra (NoSQL) database (http://cassandra.apache.org/) might be one
of the best choices in this genre as it has the support of the big players
like FaceBook, IBM, Apache etc...

There is also an ever expanding group of experts and help forums
(http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/) on this
subject.

To add to the functionality there is the new super scaling and searching
tools called HPCC
(http://gigaom.com/cloud/lexisnexis-open-sources-its-hadoop-killer/) which
uses a combination of SQL and NoSQL when searching distributive data and
clusters of data servers.  

In your future plans it might well be worth considering such an option
especially as your data requirements and expected results continues to grow.


Jim



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Sunday, July 03, 2011 9:57 AM
To: Access Developers discussion and problem solving; VBA; Sqlserver-Dba
Subject: [AccessD] SSD, The Game Changer - SQL Man of Mystery -
SQLServerCentral.com


-- 
John W. Colby
www.ColbyConsulting.com
http://www.sqlservercentral.com/blogs/sqlmanofmystery/archive/2009/04/14/ssd
-the-game-changer.aspx
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the dba-Tech mailing list