Exponential growth of the slots table

[Elwood Hunt]

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

Thanks,
Elwood

On Sat, Dec 4, 2010 at 6:29 PM, John Ralls <jralls at ceridwen.us> wrote:
>
> Done, I think. I've committed r19908 which recurses down the FRAMES and GLISTS to clear out child slots.
> Elwood, if you're able, build it (or if you're a windows user you can get tomorrow's nightly at http://code.gnucash.org/builds/win32/trunk/). Running your budget function should clear out the duplicate slots. It will probably take a while, so be patient.
>
> Do note that many of the slot names are duplicated for bank/brokerage accounts, so there will be some duplication. This query
>
>  select obj_guid, name, count(*) from slots group by obj_guid, name  having count(*) > 1;
>
> should produce no results.