Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Unacceptable performance |
Author |
Message |
darh |
|
Group | : Members |
Posts | : 1 |
Joined | : 2008-08-08 |
|
Profile |
|
Posted : 2008-08-13 17:21:38 |
I need some guidance. I'm trying to build some WinForms read-only queries to display all "ItemService" and "ItemNonInventory" SalesLines for a selected customer. Just querying the list of customers for my combo box takes 10 seconds. This query:
SELECT TxnID, TxnNumber, CustomerRefListID, CustomerRefFullName, TxnDate, RefNumber, IsPending, PONumber, DueDate, Subtotal, Amount, IsPaid, Type, SalesLineType, SalesLineSeqNo, SalesLineTxnLineID, SalesLineItemRefListID, SalesLineItemRefFullName, SalesLineDesc, SalesLineQuantity, SalesLineAmount, SalesLineServiceDate FROM SalesLine
takes another 2 minutes. If I try something like:
SELECT SalesLine.TxnID, SalesLine.TxnNumber, SalesLine.CustomerRefListID, SalesLine.TxnDate, SalesLine.RefNumber, SalesLine.PONumber, SalesLine.DueDate, SalesLine.IsPaid, SalesLine.Type, SalesLine.SalesLineItemRefListID, SalesLine.SalesLineItemRefFullName, SalesLine.SalesLineDesc, SalesLine.SalesLineQuantity, Item.Type FROM SalesLine, Item WHERE (Item.Type = 'ItemService') OR (Item.Type = 'ItemNonInventory')
well, I won't live that long. The one time I tried to let it run to completion, it errored out first. I can watch the looping go by in the driver status pop-ups: it's querying all 80+ items for each sales line, and each loop takes about 3 seconds.
My environment is Visual Studio 2008 with SP1 Beta and QuickBooks Pro 2008 US version. QODBC optimizer is set to Use Optimizer, The start of every new connection with Load Updated Data First is checked, and Optimize data after insert or update checked. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-08-14 09:42:09 |
Well in both of these statements you are asking for every sale, credit and receipt line since year dot. This is every transaction out of QuickBooks in a XML document and, depending on the number of transactions you have, it will take a while or completely eat all the resources up on your computer and go nowhere! When you use QuickBooks you would never do this. Transactions are often seen as week to date, month to date, year to date or from this date to this date and so on.
You need to target the infromation you really want to see: Differentiate between a payment and a discount to pay commissions for what I mean. |
|
|
|
|