Well I think I have sped it up a little. Because the data entry person does this pretty quickly, I am thinking of just using a string grid and keeping an array of the record ID and the new value, and then showing the new value in the string grid, but when the form closes, do a mass update to the DB then....this is if its still to slow. The interesting thing is, its slow wether its 5 rows of 55000 rows. I think it is def. passing back the result of the query after an update.
Jeremy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert martin Sent: Friday, 17 September 2004 10:26 To: [EMAIL PROTECTED]; NZ Borland Developers Group - Delphi List Subject: Re: [DUG] Slow updates I know very little about ADO but I think Rohit is right about reading the whole table in, probably not good (and should be fixed). However doesn't ADO have a async / synchronous option that allows program execution to flow on while a query executes? You could try this. p.s. Why are you Still using ADO, that is such a dated, at the end of its life, product. You should be using ADO.Net surely :)) (Says the man who is just moving from Dbase to Firebird !) Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com Wild Software Ltd ----- Original Message ----- From: "Rohit Gupta" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "NZ Borland Developers Group - Delphi List" <[EMAIL PROTECTED]> Sent: Friday, September 17, 2004 9:40 AM Subject: Re: [DUG] Slow updates > I havent used ADO, but one possible cause could be that it is reading > the whole table in after an update. There may be a property to turn > this behaviour off. > > > > > Hi All. > > I have a DB Grid (an InfoPower one) that is linked to a TADOQuery. I > > have made it so one of the cells can be edited to update a value or add one. > > This all works fine, UNTIL, it tries to do an update. If you enter > > in a value then press teh enter key > > or down arrow, it induces a delay while it updates the DB. As you > > can imagin, for a data entry person, its too slow. Is there a way to > > speed it up? > > > > Jeremy > > Regards > > Rohit > > ====================================================================== > CFL - Computer Fanatics Ltd. 21 Barry's Point Road, AKL, New Zealand > PH (649) 489-2280 > FX (649) 489-2290 > email [EMAIL PROTECTED] or [EMAIL PROTECTED] > ====================================================================== > > > _______________________________________________ > 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
