|Subject||Re: [firebird-support] Insert Statement Taking Time With TimeStamp values|
Why insert statement execution takes time for 2000 records.
--- On Tue, 30/3/10, Martijn Tonies <m.tonies@...> wrote:
From: Martijn Tonies <m.tonies@...>
Subject: Re: [firebird-support] Insert Statement Taking Time With TimeStamp values
Date: Tuesday, 30 March, 2010, 3:51 PM
>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.
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum:
http://www.database developmentforum .com
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]