Subject | Re: [IBO] Slow Performance |
---|---|
Author | Daniel Rail |
Post date | 2001-09-05T20:24:05Z |
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:
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,[Non-text portions of this message have been removed]
>
>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.
>chulsey@...
>
>
>
>Yahoo! Groups Sponsor
>ADVERTISEMENT
>1680dc31.jpg 1680dc95.jpg
>1680dcd1.jpg Start here...
>1680dce5.jpg
>Height:
>3 4 5 6 7 8 ft 0 1 2 3 4 5 6 7 8 9 10 11 in
>1680dcf9.jpg
>Weight:
>lbs. kg.
>
>1680dd17.jpg
>1680dd2b.jpg
>1680dd49.jpg
>
>Your use of Yahoo! Groups is subject to the
><http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.