inoffensive_2006 wrote:

> --- In firebird-support@yahoogroups.com, Milan Babuskov <milanb@...>
> wrote:
>
> Thanks Milan and Alexandre:
>
> How much faster? My code is more like the latter.
>

In a very simple test case, Inserts became 3x faster with prepared queries.

If you commit in batches (1000, 2000 inserts per commit) you could get
easily 10x more inserts/second than doing a commit for each record

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br