Subject Insert Statement Taking Time With TimeStamp values
Author Vishal Tiwari
Hi All,
 
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.
 

Thanks in advance.

Vishal
 


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]