Not to sure what the Append is, but if it's a TDataset Append then it will first scroll to the end of the dataset (which may or may not require fetching more data from the database) and then add the record to the dataset in that position. Using TDataset.Insert won't and would probably be nice and fast, just like a direct insert into the database.
Stacey > -----Original Message----- > From: Neven MacEwan [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 4 February 2004 14:52 > To: NZ Borland Developers Group - Delphi List > Subject: Re: [DUG] Insert slowness > > > Sounds like an Interbaseness, its not ANSI > > 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
