On 01/26/2013 05:06 AM, Petite Abeille wrote:
Hello,
[3.7.15.2 2013-01-09 11:53:05 c0e09560d26f0a6456be9dd3447f5311eb4f238f]
[sqlite-analyzer-osx-x86-3071502]
sqlite3_analyzer seems to, hmmm, overflow or something given a largish db.
Looks like the osx build on sqlite.org was dynamically linked against
Tcl 8.4.0, which is the version installed by default on OSX 10.5.x.
In that version, sometimes the [expr] command uses 32-bit integer
arithmetic, resulting in an overflow when calculating the bytes of
storage space used by a large db.
Please try the version on sqlite.org now, which is statically linked
against Tcl 8.6.
Dan.
For example, for a db of 8,434,233,344 bytes (8.43 GB on disk) :
--8<--
*** All tables and indices *******************************************
Percentage of total database.......... 100.000%
Number of entries..................... 143344555
Bytes of storage consumed............. -155705344
Bytes used after compression.......... 8434229248 -5416.8%
Bytes of payload...................... 6972547011 -4478.0%
-->8--
Note the negative 'Bytes of storage consumed' and associated negative
percentages.
Bug or feature?
Thanks in advance.
Cheers,
PA.
_______________________________________________
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
