Subject | Insert Statement Taking Time With TimeStamp values |
---|---|
Author | Vishal Tiwari |
Post date | 2010-03-30T10:17:04Z |
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]
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]