Exponential growth of the slots table

[Phil Longstaff]

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.