Exponential growth of the slots table

[Elwood Hunt]

Sure, I don't mind.  I will send you a Dropbox link in a day or two.

On Tue, Dec 7, 2010 at 12:16 AM, Ian Waddington <iwaddox at gmail.com> wrote:
> 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.
>
>