Re: [DUG] Insert slowness

[Sandeep Chandra]

Neven MacEwan wrote:

Sounds like an Interbaseness, its not ANSI

 

Wouldn't say that, its in TDataset. It gets all the records before doing 
an insert.

Regards

Sandeep

Neven
----- Original Message ----- 
From: "Ross Levis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "NZ Borland Developers Group - Delphi List"
<[EMAIL PROTECTED]>
Sent: Wednesday, February 04, 2004 1:28 PM
Subject: Re: [DUG] Insert slowness

 

What is the purpose of an Append then?

----- Original Message ----- 
From: "Sandeep Chandra" <[EMAIL PROTECTED]>
To: "NZ Borland Developers Group - Delphi List" <[EMAIL PROTECTED]>
Sent: Wednesday, February 04, 2004 11:56 AM
Subject: Re: [DUG] Insert slowness

   

vss wrote:

     

Well using INSERT INTO is well.....BLODDY FAST !!! we are taling split
seconds rather than MINUTES now ! I cant believe it !
So I am now making the changes now.
       

were u using a Table? if u use a Table and do Append then it reads all
the records in memory before doing insert.
Regards

Sandeep
     

_______________________________________________
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi


   

_______________________________________________
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
 

_______________________________________________
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi