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