On Tue, Jan 13, 2015 at 7:18 AM, Andy Bradford <[email protected]> wrote:
> Thus said Stephan Beal on Tue, 13 Jan 2015 03:06:46 +0100: > > > [stephan@host:~/cvs/fossil/tcl]$ f-query -e "select sum(b.size) from > blob > > b, event e where e.type='ci' and b.rid=e.objid" > > sum(b.size) > > 233986926 > > Hmm, that number is considerably different than this: > > http://core.tcl.tk/tcl/stat > > What's the difference in how they are calculated? > That one does something slightly different: @ <tr><th>Uncompressed Artifact Size:</th><td> db_prepare(&q, "SELECT total(size), avg(size), max(size)" " FROM blob WHERE size>0 /*scan*/"); (all artifact types) and: @ <tr><th>Number Of Check-ins:</th><td> n = db_int(0, "SELECT count(*) FROM event WHERE type='ci' /*scan*/"); my query above was only counting the size of all manifests. -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
_______________________________________________ fossil-users mailing list [email protected] http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
