What they don't say explicitly is that if all you need is key/value capability
then an SQL database is overkill and only slows you down (bit of a duh factor
there though not obvious to neophytes). Generally speaking that's one thing
they don't teach in college is optimization. I can't count the # of projects
I've worked on where what was implemented was so slow as to be useless by the
time it was done only to have to redesign the thing for speed. The one I'm
working now I've sped up by 100X.
The bad part is you'd better really know that all you need is key/value
otherwise you have to re-do things and kill your performance which then could
mean rearchitecting your solution.
I know my boss is always changing requirements on our IR&D programs...:-)
Michael D. Black
Senior Scientist
NG Information Systems
Advanced Analytics Directorate
________________________________
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Eduardo Morras [nec...@retena.com]
Sent: Friday, July 29, 2011 2:50 AM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] LevelDB benchmark
At 02:53 29/07/2011, Richard Hipp wrote:
>On Thu, Jul 28, 2011 at 12:27 AM, <res...@googlemail.com> wrote:
>
>I suspect that I will come up with other suggestions once I have a chance to
>dig a little deeper into the benchmarks. If you have suggestions, please
>publish them here.
They are comparing orange with apples. They compare a <key,value>
data store with a Sql relational database. From their home page(1):
* This is not a SQL database. It does not have a relational data
model, it does not support SQL queries, and it has no support for indexes.
So, they support simple queries ( = simbol) and not complex queries
(<=, >=, <, >, !=). Why don't compare it with Hadoop, Pnuts/Sherpa,
or similar No-Sql data stores?
>Thanks for your help and support!
(1) http://code.google.com/p/leveldb/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
