Question: Why do I have very slow inserts of numerous records using Firebird (I have several hundred thousands of records)?
Answer: Please donít use TpFIBDataset, because this is a buffered dataset. You will also have memory problems with TpFIBDataset. Use pFIBQuery with parameterized inserts instead. A commit after 500 should be ok. We made a text-import component and are able to put 100.000 records in 4 seconds with this approach.
Tips:
  • Try set : TpFibDataset.Unidirectional:=true; before open.
  • Try Use TpFibQuery
  • If on local PC use the local connection

Preview text: 
Prices in Euro:

235 (1 copy)
1250 (unlimited)

Volume discounts are available...

Navigation



Well, the ballots are in and the votes for the 2003 Delphi Informant Readers Choice Awards have been tallied - Congratulations Devrace, you are the runner-up in Database Connectivity category! >>

Debbie Holmgren, VP of Sales, Delphi Informant Magazine
FOR CUSTOMERS
Download full versions and updates in your Personal Area