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
On Thu, 11 Aug 2011 03:13:47 -0400, Eric A. Bonney wrote:
"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, po
On Thursday 11 August 2011 08:13:47 Eric A. Bonney wrote:
> 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 ab
On Thursday 11 August 2011 13:09:14 David Houlden wrote:
> On Thursday 11 August 2011 08:13:47 Eric A. Bonney wrote:
> > 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 second
> 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,
On Thursday, August 11, 2011 20:15:43 Colin Wright wrote:
> > 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
On Thu, 11 Aug 2011 20:15:43 + (GMT)
Colin Wright wrote:
> It looks like it could be really slow in a large data set. If this
> is done a lot you'd want an index on kmmSplits(accountid, postDate)
> (or kmmSplits(accountid, txType, postDate) if it does lots of
> type-based searches and N is u
Thanks to everyone for the ideas and suggestions. I want to get the
Activities and layouts completed for the last three areas (Payees,
Accounts and Categories) and then I will go back over this one bottle
neck. If all goes well and depending on how much time I get to work on
it over the weekend
Hi,
on Friday 12 August 2011 15:24:43 Eric A. Bonney wrote:
> Thanks to everyone for the ideas and suggestions. I want to get the
> Activities and layouts completed for the last three areas (Payees,
> Accounts and Categories) and then I will go back over this one bottle
> neck. If all goes well a
I do not expect the traffic to increase much, mostly once I get to the
next phase of working with the XML file directly I am sure I will have a
lot of questions, but that is not for a long time from now. I am
sticking with the SQLite version only until I get a solid core.
As for the app and th
10 matches
Mail list logo
