On Fri, Nov 15, 2013 at 7:33 AM, RSmith <rsm...@rsweb.co.za
<mailto:rsm...@rsweb.co.za>> wrote:
Yes there would be a space-saving, but it is rather minimal. The real
advantage is removing one complete lookup reference
cycle from a Query...
That was my original theory too. But experimental evidence inverts this.
There is a program called "wordcount.c" (see http://www.sqlite.org/src/artifact/2c2cc111?ln) that tests the performance of WITHOUT
ROWID. It constructs a table like this:
etc.
Why yes of course there is no more need for an entire index and all the baggage accompanying it which makes for a ~50% reduction in
a table with just those columns, but surely any normally useful data table (as opposed to this experimental type) consisting of many
columns would receive a rapidly diminishing benefit in terms of size reduction?
I am also convinced after some testing that the speed benefit might be somewhat bigger for these larger tables where more bytes
distance exist for pages etc, but I might be wrong - will do some more testing later.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users