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

----- 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]