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.
Jeremy -----Original Message----- From: "vss" <[EMAIL PROTECTED]> To: "NZ Borland Developers Group - Delphi List" <[EMAIL PROTECTED]> Date: Wed, 04 Feb 2004 10:23:37 +1300 Subject: Re: [DUG] Insert slowness > Yeah I was going to see what people said before doing the Insert INTO > thing. I know its the obvious thing to try, but FIRST I wanted to know > why appends are slow. > I shall indeed seek the advise of the mighty Google..... :-) > > Jeremy > > -----Original Message----- > From: Craig Goodall <[EMAIL PROTECTED]> > To: NZ Borland Developers Group - Delphi List <[EMAIL PROTECTED]> > Date: Wed, 04 Feb 2004 08:08:15 +1100 > Subject: Re: [DUG] Insert slowness > > > Hi Jeremy, > > > > Type 'interbase slow append' (without the quotes) into Google Groups > > (not std search) and you will get a heap of threads regarding Append > > problems. A lot of it says that you should not be using Append, but > > Insert or Update instead. Also that you may be reading the whole > table. > > Not sure why this would happen on some systems and not others, but > some > > of the threads might give you a lead. > > > > HTH, > > Craig. > > > > _______________________________________________ > > 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
