Subject | Re: [IBO] Slow Performance |
---|---|
Author | Artur Anjos |
Post date | 2001-09-05T19:00:42Z |
I had a identical problem. For resolving the problem I use a combination of:
1) IB_Cursor: You just need to update, don't need bidirectional, don't you? Even if you are using IBO TDatasets, it's faster to use them just to have results, pass them to a IB_Cursor and use this last one.
2) After 'n' inserts, I close IB_Cursor and reopen again with no values. Use the where clause with something that you are shure that will not return any values from the server.
I don't remember what I use more, but this two things help a lot.
Regards,
Artur
1) IB_Cursor: You just need to update, don't need bidirectional, don't you? Even if you are using IBO TDatasets, it's faster to use them just to have results, pass them to a IB_Cursor and use this last one.
2) After 'n' inserts, I close IB_Cursor and reopen again with no values. Use the where clause with something that you are shure that will not return any values from the server.
I don't remember what I use more, but this two things help a lot.
Regards,
Artur
----- Original Message -----
From: Chris Hulsey
To: IBObjects@yahoogroups.com
Sent: Wednesday, September 05, 2001 6:47 PM
Subject: [IBO] Slow Performance
Hello All,
I am developing an C++ Builder 5.0 application with IBO 3.6 that has to update multiple sales tables from a ticket line item record. Unfortunately there are about 100,000 ticket line items and there are about 7 different sales tables with about 6 different time periods for each. Currently I have a TIB_Database connection and TIB_Query to retrieve the Ticket line items and a TIB_Query for my EDIT/INSERT of the different sales tables. Each Ticket Line Item has the possibilty of doing about 40-42 EDIT/INSERT operations. It takes 3 days to run this process which surely I am doing something wrong here. Any suggestions as to how I can speed this process up? It starts out at a slow speed but gets even slower as time passes?
Hardware Specifications
Windows 2000 Server
Pentium 4 (1.7 Ghz)
2GB of Memory
Interbase 6 running as Local Server
Chris Hulsey
Visible Changes, Inc
chulsey@...
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
Start here...
Height:
345678 ft 01234567891011in
Weight:
lbs. kg.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]