r18181 - gnucash/trunk/src/backend/sql - Make split queries stupid - depend only on account. This makes them *much* faster on sqlite3.

[Phil Longstaff]

Author: plongstaff
Date: 2009-07-06 20:14:45 -0400 (Mon, 06 Jul 2009)
New Revision: 18181
Trac: http://svn.gnucash.org/trac/changeset/18181

Modified:
   gnucash/trunk/src/backend/sql/gnc-transaction-sql.c
Log:
Make split queries stupid - depend only on account.  This makes them *much* faster on sqlite3.
Once they can be sped up, the stupidity can be removed.


Modified: gnucash/trunk/src/backend/sql/gnc-transaction-sql.c
===================================================================
--- gnucash/trunk/src/backend/sql/gnc-transaction-sql.c	2009-07-06 23:11:56 UTC (rev 18180)
+++ gnucash/trunk/src/backend/sql/gnc-transaction-sql.c	2009-07-07 00:14:45 UTC (rev 18181)
@@ -53,6 +53,8 @@
 #include "splint-defs.h"
 #endif
 
+#define SIMPLE_QUERY_COMPILATION 1
+
 /*@ unused @*/ static QofLogModule log_module = G_LOG_DOMAIN;
 
 #define TRANSACTION_TABLE "transactions"
@@ -987,11 +989,19 @@
 
 				if( strcmp( paramPath->data, QOF_PARAM_BOOK ) == 0 ) continue;
 
+#if SIMPLE_QUERY_COMPILATION
+				if( strcmp( paramPath->data, SPLIT_ACCOUNT ) != 0
+						|| strcmp( paramPath->next->data, QOF_PARAM_GUID ) != 0 ) continue;
+#endif
+
                 if( need_AND ) g_string_append( sql, " AND " );
 
 				if( strcmp( paramPath->data, SPLIT_ACCOUNT ) == 0
 						&& strcmp( paramPath->next->data, QOF_PARAM_GUID ) == 0 ) {
                 	convert_query_term_to_sql( "s.account_guid", term, sql );
+#if SIMPLE_QUERY_COMPILATION
+					goto done_compiling_query;
+#endif
 
 				} else if( strcmp( paramPath->data, SPLIT_RECONCILE ) == 0 ) {
                 	convert_query_term_to_sql( "s.reconcile_state", term, sql );
@@ -1042,7 +1052,13 @@
 			}
         }
 
+#if SIMPLE_QUERY_COMPILATION
+done_compiling_query:
+#endif
 		if( sql->len != 0 ) {
+#if SIMPLE_QUERY_COMPILATION
+			g_string_append( sql, ")" );
+#endif
 			query_sql = g_strdup_printf(
 					"SELECT DISTINCT t.* FROM %s AS t, %s AS s WHERE s.tx_guid=t.guid AND %s",
 					TRANSACTION_TABLE, SPLIT_TABLE, sql->str );