Exponential growth of the slots table

Ian Waddington iwaddox at gmail.com
Tue Dec 7 03:16:48 EST 2010


Hi,

Sorry, I know this is off topic, but....

Are you able to share any of the reporting work you have done?

I'm curious to see how it works and how I might develope something myself, I
am also very interesting to learn whether any of your budgeting reports go
anywhere towards doing any forecast reporting.

Regards

Ian
On Tue, Dec 7, 2010 at 2:39 AM, Elwood Hunt <elwood.hunt at gmail.com> wrote:

> Phil / John,
>
> I followed John's advice before I saw Phil's email, but it worked
> nicely.  I now have 1,500 records in the slots table instead of 17,000
> and the data in the app looks good.
>
> I've created a couple of tools for budget reporting using Python and
> MySql and so far I've managed to avoid the slots table.
>
> Thanks so much for your help.
>
> Elwood
>
> On Sun, Dec 5, 2010 at 8:28 PM, Phil Longstaff <plongstaff at rogers.com>
> wrote:
> > Or just save to a new database.
> >
> >  Phil
> > ---------
> > I used to be a hypochondriac AND a kleptomaniac. So I took something for
> it.
> >
> >
> >
> >
> > ________________________________
> > From: John Ralls <jralls at ceridwen.us>
> > Cc: Gnucash user list <gnucash-user at gnucash.org>
> > Sent: Sun, December 5, 2010 11:18:08 PM
> > Subject: Re: Exponential growth of the slots table
> >
> >
> > On Dec 5, 2010, at 7:37 PM, Elwood Hunt wrote:
> >
> >> John,
> >>
> >> I downloaded and installed gnucash-2.3.17-svn-r19908-setup.exe.  I
> >> started GC, opened my budget, added another budget period, added
> >> amounts for 2 accounts, and saved / exited.  Before, the count in my
> >> slots tables was 17,023.  After, it was 17,025.  So it didn't seem to
> >> to clean-up the extra records, but at least it didn't add another
> >> 15,000.  The query you gave does not return any rows after adding the
> >> budget period (I didn't run it before added the budget period).
> >>
> >
> > Hmm. So it's most of a fix. I thought about that possibility afterwards:
> The
> > extra records are disconnected, by which I mean that the top-level slot
> entries
> > that they refer to have been deleted, so there's nothing connecting them.
> You
> > might be able to delete them from the data base with a carefully made
> outer
> > join, but it would risk deleting stuff that you want.
> >
> > But a save as xml followed by a save as sql might do it, since as there's
> > nothing to pull those extra slot records into memory they won't get
> written out
> > to xml.
> >
> > Regards,
> > John Ralls
> >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


More information about the gnucash-user mailing list