Hi Eugene, On 12 Apr 2009, at 9:53 AM, Eugene Wee wrote:
> Hi, > > On Mon, Apr 13, 2009 at 12:40 AM, Tito Ciuro <tci...@mac.com> wrote: >> One question, when I run the command I see that the fragmentation in >> "All tables" is greater than "All tables and indices". How can that >> be? The sum of all tables and their indices doesn't add up (10.6% + >> 7.5% ≠ 9.6%): > > From the given information: > All tables > Percentage of total database.......... 66.4% > Fragmentation......................... 10.6% > > All indices > Percentage of total database.......... 33.6% > Fragmentation......................... 7.5% > > Now, > 0.664 * 10.6 + 0.336 * 7.5 = 9.5584 > > This rounds to 9.6, which corresponds to: > All tables and indices > Fragmentation......................... 9.6% Yup. That makes sense. Thanks! -- Tito _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users