Subject Re: [IBO] Slow Performance
Author Daniel Rail
Hi Chris,

Are you using TIB_Query just to navigate through the Ticket Line Items? If
so, maybe you can try the TIB_Cursor(use the APINext method to advance
through the records), unless you are showing fields visually while the
processing is done. And maybe use TIB_DSQL for the Edits and Inserts
(using parameterized statements).

Daniel Rail

At 09/05/2001 04:31 PM, you wrote:
>Hello Daniel,
>Thank you for your response. Yes, I am using explicit start transaction and
>commit transaction for each Ticket Line Item, because if there is failure I
>need to do rollback on all EDIT/INSERTS for the particular Ticket Line Item.
>Chris Hulsey
>Visible Changes, Inc.
>Yahoo! Groups Sponsor
>1680dc31.jpg 1680dc95.jpg
>1680dcd1.jpg Start here...
>3 4 5 6 7 8 ft 0 1 2 3 4 5 6 7 8 9 10 11 in
>lbs. kg.
>Your use of Yahoo! Groups is subject to the
><>Yahoo! Terms of Service.

[Non-text portions of this message have been removed]