QDeveloper Forum

Member Login

Username

Password

Forget Password

New Sign Up

Search Forum

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

Forum : Performance is very slow Search Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v7 Forum

New Topic

Post Reply

[1]

Performance is very slow

Author Message

  Randy



Group : Members

Posts : 11

Joined : 2007-08-18

Profile

Posted : 2007-09-15 06:42:25

I am doing 2 lookups for both the CustomerRefListID and SalesOrderLineItemRefListID and Inserts for each line item. It's taking 5-10 seconds to create a new sales order.   I am using Optimizer. I'm running a Pentium dual core 2.2ghz with 2gb RAM. Is there anything else I can do to improve performance?

Here is the example of one sales order insert:

DEBUG 2007-09-14 13:39:34
Job Number    : 10000
Reference Id : 16020002
Category      : Database
Message       : Executed sql: insert into SalesOrderLine (
                CustomerRefListID, ClassRefListID, TxnDate, RefNumber,
                BillAddressAddr1, BillAddressAddr2, BillAddressAddr3,
                BillAddressAddr4, BillAddressCity, BillAddressState,
                BillAddressPostalCode, BillAddressCountry, ShipAddressAddr1,
                ShipAddressAddr2, ShipAddressAddr3, ShipAddressAddr4,
                ShipAddressCity, ShipAddressState, ShipAddressPostalCode,
                ShipAddressCountry, TermsRefListID, DueDate,
                ShipMethodRefListID, FOB, Memo, IsToBePrinted,
                SalesOrderLineGroupItemGroupRefListID, SalesOrderLineGroupQuantity,
                SalesOrderLineItemRefListID, SalesOrderLineDesc,
                SalesOrderLineQuantity, SalesOrderLineRate, SalesOrderLineClassRefListID,
                SalesOrderLineAmount, FQSaveToCache)

                values('80000193-1185886571',NULL,NULL,'1401912031',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'WAL-MART SUPERCENTER 0697','2600
                SW 19TH

                AVE',NULL,NULL,'OCALA','FL','34474','US',NULL,NULL,NULL,NULL,'005004705690078742006796',NULL,NULL,NULL,'800000B7-1185886486',NULL,30,1.25,NULL,NULL,1)

_____________________________________________________________
DEBUG 2007-09-14 13:39:37
Job Number    : 10000
Reference Id : 16020002
Category      : Database
Message       : Executed sql: insert into SalesOrderLine (
                CustomerRefListID, ClassRefListID, TxnDate, RefNumber,
                BillAddressAddr1, BillAddressAddr2, BillAddressAddr3,
                BillAddressAddr4, BillAddressCity, BillAddressState,
                BillAddressPostalCode, BillAddressCountry, ShipAddressAddr1,
                ShipAddressAddr2, ShipAddressAddr3, ShipAddressAddr4,
                ShipAddressCity, ShipAddressState, ShipAddressPostalCode,
                ShipAddressCountry, TermsRefListID, DueDate,
                ShipMethodRefListID, FOB, Memo, IsToBePrinted,
                SalesOrderLineGroupItemGroupRefListID, SalesOrderLineGroupQuantity,
                SalesOrderLineItemRefListID, SalesOrderLineDesc,
                SalesOrderLineQuantity, SalesOrderLineRate, SalesOrderLineClassRefListID,
                SalesOrderLineAmount, FQSaveToCache)

                values('80000193-1185886571',NULL,NULL,'1401912031',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'WAL-MART SUPERCENTER 0697','2600
                SW 19TH

                AVE',NULL,NULL,'OCALA','FL','34474','US',NULL,NULL,NULL,NULL,'005004705690078742006796',NULL,NULL,NULL,'80000078-1185886482',NULL,24,2.05,NULL,NULL,1)

_____________________________________________________________
DEBUG 2007-09-14 13:39:39
Job Number    : 10000
Reference Id : 16020002
Category      : Database
Message       : Executed sql: insert into SalesOrderLine (
                CustomerRefListID, ClassRefListID, TxnDate, RefNumber,
                BillAddressAddr1, BillAddressAddr2, BillAddressAddr3,
                BillAddressAddr4, BillAddressCity, BillAddressState,
                BillAddressPostalCode, BillAddressCountry, ShipAddressAddr1,
                ShipAddressAddr2, ShipAddressAddr3, ShipAddressAddr4,
                ShipAddressCity, ShipAddressState, ShipAddressPostalCode,
                ShipAddressCountry, TermsRefListID, DueDate,
                ShipMethodRefListID, FOB, Memo, IsToBePrinted,
                SalesOrderLineGroupItemGroupRefListID, SalesOrderLineGroupQuantity,
                SalesOrderLineItemRefListID, SalesOrderLineDesc,
                SalesOrderLineQuantity, SalesOrderLineRate, SalesOrderLineClassRefListID,
                SalesOrderLineAmount, FQSaveToCache)

                values('80000193-1185886571',NULL,NULL,'1401912031',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'WAL-MART SUPERCENTER 0697','2600
                SW 19TH

                AVE',NULL,NULL,'OCALA','FL','34474','US',NULL,NULL,NULL,NULL,'005004705690078742006796',NULL,NULL,NULL,'80000023-1185886475',NULL,18,2.4,NULL,NULL,1)

_____________________________________________________________
DEBUG 2007-09-14 13:39:42
Job Number    : 10000
Reference Id : 16020002
Category      : Database
Message       : Executed sql: insert into SalesOrderLine (
                CustomerRefListID, ClassRefListID, TxnDate, RefNumber,
                BillAddressAddr1, BillAddressAddr2, BillAddressAddr3,
                BillAddressAddr4, BillAddressCity, BillAddressState,
                BillAddressPostalCode, BillAddressCountry, ShipAddressAddr1,
                ShipAddressAddr2, ShipAddressAddr3, ShipAddressAddr4,
                ShipAddressCity, ShipAddressState, ShipAddressPostalCode,
                ShipAddressCountry, TermsRefListID, DueDate,
                ShipMethodRefListID, FOB, Memo, IsToBePrinted,
                SalesOrderLineGroupItemGroupRefListID, SalesOrderLineGroupQuantity,
                SalesOrderLineItemRefListID, SalesOrderLineDesc,
                SalesOrderLineQuantity, SalesOrderLineRate, SalesOrderLineClassRefListID,
                SalesOrderLineAmount, FQSaveToCache)

                values('80000193-1185886571',NULL,NULL,'1401912031',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'WAL-MART SUPERCENTER 0697','2600
                SW 19TH

                AVE',NULL,NULL,'OCALA','FL','34474','US',NULL,NULL,NULL,NULL,'005004705690078742006796',NULL,NULL,NULL,'80000004-1185886474',NULL,16,3,NULL,NULL,1)

_____________________________________________________________
DEBUG 2007-09-14 13:39:44
Job Number    : 10000
Reference Id : 16020002
Category      : Database
Message       : Executed sql: insert into SalesOrderLine (
                CustomerRefListID, ClassRefListID, TxnDate, RefNumber,
                BillAddressAddr1, BillAddressAddr2, BillAddressAddr3,
                BillAddressAddr4, BillAddressCity, BillAddressState,
                BillAddressPostalCode, BillAddressCountry, ShipAddressAddr1,
                ShipAddressAddr2, ShipAddressAddr3, ShipAddressAddr4,
                ShipAddressCity, ShipAddressState, ShipAddressPostalCode,
                ShipAddressCountry, TermsRefListID, DueDate,
                ShipMethodRefListID, FOB, Memo, IsToBePrinted,
                SalesOrderLineGroupItemGroupRefListID, SalesOrderLineGroupQuantity,
                SalesOrderLineItemRefListID, SalesOrderLineDesc,
                SalesOrderLineQuantity, SalesOrderLineRate, SalesOrderLineClassRefListID,
                SalesOrderLineAmount, FQSaveToCache)

                values('80000193-1185886571',NULL,NULL,'1401912031',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'WAL-MART SUPERCENTER 0697','2600
                SW 19TH

                AVE',NULL,NULL,'OCALA','FL','34474','US',NULL,NULL,NULL,NULL,'005004705690078742006796',NULL,NULL,NULL,'800000E1-1185886487',NULL,13,4.5,NULL,NULL,1)

_____________________________________________________________
DEBUG 2007-09-14 13:39:48
Job Number    : 10000
Reference Id : 16020002
Category      : Database
Message       : Executed sql: insert into SalesOrderLine (
                CustomerRefListID, ClassRefListID, TxnDate, RefNumber,
                BillAddressAddr1, BillAddressAddr2, BillAddressAddr3,
                BillAddressAddr4, BillAddressCity, BillAddressState,
                BillAddressPostalCode, BillAddressCountry, ShipAddressAddr1,
                ShipAddressAddr2, ShipAddressAddr3, ShipAddressAddr4,
                ShipAddressCity, ShipAddressState, ShipAddressPostalCode,
                ShipAddressCountry, TermsRefListID, DueDate,
                ShipMethodRefListID, FOB, Memo, IsToBePrinted,
                SalesOrderLineGroupItemGroupRefListID, SalesOrderLineGroupQuantity,
                SalesOrderLineItemRefListID, SalesOrderLineDesc,
                SalesOrderLineQuantity, SalesOrderLineRate, SalesOrderLineClassRefListID,
                SalesOrderLineAmount, FQSaveToCache)

                values('80000193-1185886571',NULL,NULL,'1401912031',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'WAL-MART SUPERCENTER 0697','2600
                SW 19TH

                AVE',NULL,NULL,'OCALA','FL','34474','US',NULL,NULL,NULL,NULL,'005004705690078742006796',NULL,NULL,NULL,'8000006B-1185886482',NULL,24,2.15,NULL,NULL,0)

Top

  Tom



Group : Administrator

Posts : 5510

Joined : 2006-02-17

Profile

Posted : 2007-09-16 18:37:28

Try removing all the NULLS and stop using SalesOrderLineGroupItemGroupRefListID when the SalesOrderLIne has nothing to do with a group item.

Top

  Randy



Group : Members

Posts : 11

Joined : 2007-08-18

Profile

Posted : 2007-09-19 05:01:03

I removed the Nulls and SalesOrderLineGroupItemGroupRefListID. This definitely improved the performance to an average of 5 seconds now.

Top

New Topic

Post Reply

[1]

Jump to