Hi Ann,
 
Okay now i got the idea that preparation should be done once, i was not awared of it.
 
Thanks for your replay.
 
With Warm Regards Have A Nice Day.
 
 
Vishal

--- On Wed, 31/3/10, Ann W. Harrison <aharrison@...> wrote:


From: Ann W. Harrison <aharrison@...>
Subject: Re: [firebird-support] Insert Statement Taking Time With TimeStamp values
To: firebird-support@yahoogroups.com
Date: Wednesday, 31 March, 2010, 9:37 PM


 



Vishal Tiwari wrote:
> 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








Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/

[Non-text portions of this message have been removed]