Exponential growth of the slots table

[John Ralls]

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