That looks likely - also check whether you have started a transaction with TADOConnection.BeginTrans
Stephen -----Original Message----- From: Steven Knight [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 9:54 a.m. To: 'NZ Borland Developers Group - Delphi List' Subject: RE: [DUG] ADO Weired ness Don't you need to do a 'clear' before you do the 'add' ?? > -----Original Message----- > From: vss [mailto:[EMAIL PROTECTED] > Sent: 02 April 2004 9:35 am > To: [EMAIL PROTECTED] > Subject: [DUG] ADO Weired ness > > > Hi All. > We have been tracking down a problem that had occured off and > on with an > app. we have written that used ADO. > Basically it was comming up with Times outs, and I FINALLY tracked it > down to the ADOQuery CommandTimeout which is because of an > internal issue. > Anyway, we fixed the internal issue (hardware), but I have > left a wee app > running all yeasterday and overnight, and then today when I > got to work, > its had gone from like milliseconds to do the insert, to 20 seconds ! > Its seems to just increase over time. > All I am doing is :- > > ADOQuery1.close; > ADOQuery1.sql.add('UPDATE TESTTABLE SET TEST = TEST+1'); > ADOQuery1.ExecSQL; > > And thats it. Oh this gets triggered on a timer that fires after 10 > seconds. > > This seems really strange if not BAD behaviour of the control. > > Anyone seen this before? or have any suggestions. > I am going to try actually creating the query object each > time it needs > to use it and then free it when its finished, but this seems > a bit over > the top. > I think its the problem with out app. and why I have never > been able to > reporduce it. I.e. the client doesnt close the app. down, > because they > operate 24/7 and then they say its slow, and they get the > time out error. > > Jeremy > > _______________________________________________ > Delphi mailing list > [EMAIL PROTECTED] > http://ns3.123.co.nz/mailman/listinfo/delphi > Visit us online at http://www.ecan.govt.nz ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. The contents of this email and any attachments are not formal policy of Environment Canterbury, unless otherwise stated. ********************************************************************** _______________________________________________ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi Disclaimer : This communication contains information that is confidential and the copyright of ensynergy Limited or a third party. If you are not the intended recipient of this communication please delete and destroy all copies and telephone ensynergy Limited on +64 9 3551591 immediately. If you are the intended recipient of this communication you should not copy, disclose or distribute this communication without the authority of ensynergy Limited. Any views expressed in this communication are those of the individual sender, except where the sender specifically states them to be the views of ensynergy Limited. Except as required by law, ensynergy Limited does not represent, warrant and/or guarantee that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. _______________________________________________ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
