Indexes on splits.account_guid and transactions.post_date

[Colin Law]

On 18 March 2010 22:32, Phil Longstaff <plongstaff at rogers.com> wrote:
> 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.

Many thanks, no rush.  If they are in for 2.4 I will be very happy.

Colin
>
> Phil
>
>