Subject | Re: bulk insert or update |
---|---|
Author | Adam |
Post date | 2005-11-29T11:14Z |
--- In firebird-support@yahoogroups.com, "women_lover_best"
<talbronstien@g...> wrote:
You can create a file in the format of an external file, then import
that table in a single sql statement, otherwise, start a transaction,
prepare the insert then pump the records through one at a time.
Atomicity is guaranteed by the transaction, so the only downside is
the performance of bouncing between client and database server between
each record. To be honest, with only 10 records you will not notice
it. At a couple of thousand there may be some use if it was available.
Adam
<talbronstien@g...> wrote:
>no it is not supported.
> Hi,
>
> i want to send data for bulk insert..say 10 records at a go..using
> .net..how can i do that?does firebird support it?
You can create a file in the format of an external file, then import
that table in a single sql statement, otherwise, start a transaction,
prepare the insert then pump the records through one at a time.
Atomicity is guaranteed by the transaction, so the only downside is
the performance of bouncing between client and database server between
each record. To be honest, with only 10 records you will not notice
it. At a couple of thousand there may be some use if it was available.
Adam