No Not using BeginTrans. Its not ness. I dont think. Jeremy
-----Original Message----- From: "Stephen Bertram" <[EMAIL PROTECTED]> To: "NZ Borland Developers Group - Delphi List" <[EMAIL PROTECTED]> Date: Fri, 2 Apr 2004 09:56:49 +1200 Subject: RE: [DUG] ADO Weired ness > 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 _______________________________________________ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
