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

jwcolby jwcolby at colbyconsulting.com
Sun Jul 3 16:41:18 CDT 2011


Jim,

I read the first article and I don't see how it fits at all.

1) My data is very much a normal table, with rows and columns.  In one case (the people table) there 
is a small number of columns, and most of the columns are fully populated.  In the second table, 
there are pushing 700 fields and the columns are rarely fully populated.

2) The data is relational, though just barely.  One of my people tables is directly related to the 
data table.  All of my people tables may have people in the other tables.  Eventually I will be 
pulling all of my people into a single table with pointers back to the non people data in the 
original table.

3) I rarely update the data.  The people table is updated once per month as I validate the addresses 
looking for moves.  I get about 1.5% / month moves.  The data table is never updated, at least the 
data in the existing columns.  Very occasionally I add new columns.

4) I only have a single user (myself) and I never expect to have more.

In comparison, the NoSQL databases claim to store documents and make them searchable.  Blog posts, 
web pages etc.  They claim to be good as the numbers of people simultaneously *writing* to them 
climbs into the hundreds or thousands.

So while the technology is fascinating, it hardly seems like a fit for my application.


John W. Colby
www.ColbyConsulting.com

On 7/3/2011 3:13 PM, Jim Lawrence wrote:
> 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
>
>



More information about the AccessD mailing list