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
