Why do I have very slow inserts of
numerous records using Firebird (I have several hundred thousands of
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.
Try set :
TpFibDataset.Unidirectional:=true; before open.