Why do I have very slow inserts of numerous records using Firebird (I have several hundred thousands of records)?
Fast, flexible and high-performance component library for Delphi, C++ Builder and Kylix intended for work with InterBase and Firebird using Direct InterBase API.
|
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
FIBPlus has taken the headache out of this project. When I got the current contract, FIBPlus was included on the work computer from the client. I quickly found it easier to use and more powerful than any other Firebird component suite I had tested. When I ran into a problem setting up a persistent calculated field, the tech support people saved the day. I would also add that I tested Zeos, IBX, DBGo, UIB, and other FBconnectors. FIBPlus outperformed all of them, and FIBPlus was run on an older machine than the others were. That was most impressive.
>>Frank Luke, Big Creek software, LLC
