Exponential growth of the slots table

[Elwood Hunt]

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.
>