Subject Re: [firebird-support] Insert Statement Taking Time With TimeStamp values
Author Nico Callewaert
I think because every record is inserted as a separate transaction...

----- Original Message -----
From: Martijn Tonies
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
>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.


With regards,

Martijn Tonies
Upscene Productions

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

Database questions? Check the forum:

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