From: Pavol S. <pa...@st...> - 2003-02-11 13:19:22
|
Carlos Guzm=E1n =C1lvarez wrote: > Hello: > >> Did you think about problem i reported about that Expire method in=20 >> fbconnectionpool??? i still think, that best method is to close=20 >> connection and firebird will clear all resource for this.. By im=20 >> afraid that connection lifetime is not working... I will do more=20 >> tests... > > > Can be a problem with the timer that i'm using for make the checkout,=20 > huumm, i'm thinking in use a thread for this but first i > want to be sure that the this is the problem can you try to run your=20 > program without pooling ?? there is problem, that you are calling EXPIRE each CheckOut function if=20 that funny time tests pass... I think, that there is problem in this=20 tests... In checkout you are using now.ticks and in CleanUp you are using only=20 now... Of course im not sure will modify your sources to make exact tests= ... > > >> i used explicit prepare, becouse you in IBX (delphi provider) you had=20 >> to call this for preparing statement for parameter... If i dont need=20 >> this in netprovider ist great... > > > Your code is well :) you can make the call but it's not needed. > > > > > Best regards > Carlos Guzm=E1n =C1lvarez > Vigo-Spain > > > P.S: Thanks for all your feedbak on this issue. |