Hi Martijn,
 
I am trying with new code, let me see how it works.
 
Thanks for the replay.
 
Have A Nice Day.
 
Vishal

--- On Wed, 31/3/10, Martijn Tonies <m.tonies@...> wrote:


From: Martijn Tonies <m.tonies@...>
Subject: Re: [firebird-support] Insert Statement Taking Time With TimeStamp values
To: firebird-support@yahoogroups.com
Date: Wednesday, 31 March, 2010, 7:10 PM


 



>Why insert statement execution takes time for 2000 records.

I would certainly expect it to take time. What are you expecting?

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene. com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.database developmentforum .com

--- On Tue, 30/3/10, Martijn Tonies <m.tonies@upscene. com> wrote:

From: Martijn Tonies <m.tonies@upscene. com>
Subject: Re: [firebird-support] Insert Statement Taking Time With TimeStamp
values
To: firebird-support@ yahoogroups. com
Date: Tuesday, 30 March, 2010, 3:51 PM

>I have total 35 columns in one table, out of that 18 columns are of type
>TimeStamp.
>First two columns are of type Date and Varchar and are primary key.
>None of the timestamp type column is an indexed column.
>When i am trying to insert 2000 records with all columns values, it takes
>time, but the data is posted correctly.
>I am making timestamp value which looks like '03/15/2010, 09:20:22:000' .
>I tried making timestamp value like '2010/03/15, 09:20:22:000' , but the
>same amount of time was taken to insert the data.

>Any reason why it takes time to insert the data.

What?

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene. com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.database developmentforum .com

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

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

------------ --------- --------- ------

++++++++++++ +++++++++ +++++++++ +++++++++ +++++++++ +++++++++ +++++++++

Visit http://www.firebird sql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoeni x.com

++++++++++++ +++++++++ +++++++++ +++++++++ +++++++++ +++++++++ +++++++++
Yahoo! Groups Links









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]