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