On 6/26/13 11:49 AM, Ed Leafe wrote: > On Jun 26, 2013, at 1:25 PM, Paul McNett <[email protected]> wrote: > >>> What would you use NoSQL for versus a traditional RDBMS? >> >> I have no clue: I love traditional RDBMS's and don't see the benefit of >> NoSQL, other >> than massive scalability which I don't need. But I also know that me not >> seeing the >> benefit is a deficiency in me, not in NoSQL. > > Different use cases. Sometimes you need to store massive amounts of > data with little regard to the structure of that data, or with data whose > structure may change over time, and relational DBs really suck at that. What > helped me grok NoSQL was imagining the denormalized data that would be > created by a report, and then sticking that as a single entry. It would make > retrieving that information so much faster than having to do multiple joins, > and writing would be much faster than having to update multiple tables.
In one of my projects I've taken to zipping and pickling numpy arrays (30 cols wide by 1400 rows tall) in addition to making each of those rows a record in a child table. We need the records in the child table for an external interface, but it is like 1,000 times faster to unzip and unpickle those arrays versus reading the data from SQL. Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
