Ignore my ignorance, what is DSQL, which component am I looking at ?

Mal

-----Original Message-----
From: Josipovic, Nikica [mailto:nikica.josipovic@...]


Best done with DSQL...use a parametrized insert-statement, prepare it, and
loop this:
set the parameters and call execute

This is extremely fast, and if you commit your transaction only every
x-loops (e.g. every 10k records), you'll get brilliant results. The
parameters are variants, so take care what you assign to what....

the Query has more overhead to this and will slow the insertion down pretty
much.