| Subject | Re: [firebird-support] Insert Statement Taking Time With TimeStamp values |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2010-03-31T16:07:30Z |
Vishal Tiwari wrote:
Generally, preparing the insert statement once and passing
just the data on subsequent calls is faster than generating,
parsing, compiling, optimizing, and executing a series of
separate statements. Running each statement in its own
transaction is slower still.
Best regards,
Ann
> Why insert statement execution takes time for 2000 records.How much time?
>
Generally, preparing the insert statement once and passing
just the data on subsequent calls is faster than generating,
parsing, compiling, optimizing, and executing a series of
separate statements. Running each statement in its own
transaction is slower still.
Best regards,
Ann