I think because every record is inserted as a separate transaction...

----- Original Message -----
From: Martijn Tonies
To: firebird-support@yahoogroups.com
Sent: Tuesday, March 30, 2010 12:21 PM
Subject: Re: [firebird-support] Insert Statement Taking Time With TimeStamp values



>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.databasedevelopmentforum.com





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