Subject Re: [firebird-support] Re: Is ESQL Faster than Dynamic SQL.
Author Alexandre Benson Smith
inoffensive_2006 wrote:
> --- In, 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
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil