[Kmymoney-devel] Anyone good with SQL?

[Eric A. Bonney]

I need help with speeding up this query. This query is run in my app 
when the user wants to display the ledger view after selecting the 
account. It takes about 3-5 seconds so far to run in my emulator on a 
sqlite database that has about 14k splits, 6500 transactions and 150 
accounts.

Here is the sql query that I am running:
"SELECT transactionId AS _id, payeeId, valueFormatted, memo, postDate, 
name FROM kmmSplits, kmmPayees WHERE (kmmSplits.payeeID = kmmPayees.id 
AND accountId = ? AND txType = 'N') UNION SELECT transactionId, payeeId, 
valueFormatted, memo, postDate, checkNumber FROM kmmSplits WHERE payeeID 
IS NULL AND accountId = ? AND txType = 'N' ORDER BY postDate DESC LIMIT 50"

The '?' get filled in with the actual accountId the user has selected. I 
am currently limiting the return to 50 records as you can see but this 
does nothing to speed up the query, so it might as well be dropped. Is 
there anything I can do make this faster or am I just stuck with this 
being a limitation to the sqlite database?

Thanks,
-Eric