Subject Re: [firebird-support] Insert Statement Taking Time With TimeStamp values
Author Martijn Tonies
>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: