Why insert statement execution takes time for 2000 records.

--- On Tue, 30/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: 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/internetexplorer/

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