Indexes on splits.account_guid and transactions.post_date

Phil Longstaff plongstaff at rogers.com
Thu Mar 18 18:32:31 EDT 2010


On Thu, 2010-03-18 at 21:59 +0000, Colin Law wrote:
> Hi
> 
> Could I put in a plea for indexes to be added to splits.account_guid
> and transactions.post_date when convenient?  Alternatively if someone
> could point me to where to do it I will submit a patch, assuming that
> the code is reasonably obvious.  Presumably at this time it is only
> necessary to add the index when a new db is saved.  There is no need
> for the code to update an existing db.
> 
> I am generating a budget type report direct from the db.  Without the
> indexes it takes 17.5 seconds to run, with them it is 4.5 secs.

OK - I'll add them as soon as I can.  Will be in 2.3.12.

Phil



More information about the gnucash-devel mailing list