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

Reply via email to