When inserting 8700 recs into a table from a text file using an
TIBOQuery whose SQL property is insert into table A(Item1, ..) values
(:Val1, ...), it takes more than 6 minutes. The loop is in a
start/commit transaction and the query is prepared before the loop. When
replacing the SQL property with a select Item1, ... from tableA where
0=1 (I don't want to get records) and then in the loop using insert/post
methods of the query, it takes 1 minute. In both cases my database is
very small (< 2Mb) and is run on my dev machine.
Could someone explain this difference ? Thanks