At 14:19 29/07/2011, Black, Michael (IS) wrote:
>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.

A <key,value> data storage can work with O(1)  algorithms while 
B-Tree indexes are O(nlogn). It can't do everything you can do with a 
B-Tree but it does what you need.

>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...:-)

Jejejeje, a boss is always O(n^2) or worse in time implementation :) 


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to