On 5/28/2014 12:26, Warren Young wrote:
On 5/28/2014 11:20, jose isaias cabrera wrote:
I would rather have the speed
then the size.
in today's L1/L2/L3 world, size *is* speed.
Also, there is a pretty hard limit on how much micro code optimizations
can help a DBMS. It's a fundamentally I/O limited problem. Disk is
many (4ish?) orders of magnitude slower than main RAM, and the CPU
caches are orders of magnitude faster than that.
http://www.eecs.berkeley.edu/~rcs/research/interactive_latency.html
That is to say, if you made every code path in SQLite zero length, it
would do approximately *squat* to improve the time it takes to get your
query results.
Only intelligent algorithms matter here, not micro-optimizations.
Better indexes, smarter query planners, etc.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users