r18156 - gnucash/trunk/src/backend/sql - Fix bug 586768 – Opening transaction list takes a very long time with MySQL backend

[Phil Longstaff]

Author: plongstaff
Date: 2009-06-24 20:27:23 -0400 (Wed, 24 Jun 2009)
New Revision: 18156
Trac: http://svn.gnucash.org/trac/changeset/18156

Modified:
   gnucash/trunk/src/backend/sql/gnc-transaction-sql.c
Log:
Fix bug 586768 – Opening transaction list takes a very long time with MySQL backend

Redo transaction queries as joins based on suggestion by Mauro Leibelt to improve query performance
on mysql.