>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