firebird-net-provider

[Firebird-net-provider] dispose

[Pavol S. <st...@ra...>]

hi,

DISPOSE IS WORKING... YESSSSSSSSSS.....

first i placed it in bad place....

Firebird is still growing, but not so fast... milion times slower :) Thanx
for this....

i think, that in one of yours post may be in help i dont know right now you
said, that you cannot close connection and still work with reader or
command, so what about to make connection.close() to dispose all associated
objects??? becouse before i was trying to force garbage collection in each
cycle (did not help), so i think, that disposing command and readers is too
dificult for GC (stupid GC)... i think that this is serious proble and HAVE
to be solved, becouse without this provider is useless for hevy load...

and sorry for HTML post before...

p.

PS: Still testing

[Firebird-net-provider] dispose

[Pavol S. <pa...@st...>]

hi,

as i wrote yesterday dispose helped much, but still not enought...

when there was no dispose porgram halted directly after 100 records 
(cycles)... now it halts after 16000 cycles... but it still halt :(

Did you think about problem i reported about that Expire method in 
fbconnectionpool??? i still think, that best method is to close 
connection and firebird will clear all resource for this.. By im afraid 
that connection lifetime is not working... I will do more tests...

i used explicit prepare, becouse you in IBX (delphi provider) you had to 
call this for preparing statement for parameter... If i dont need this 
in netprovider ist great...

p.

Re: [Firebird-net-provider] dispose

[<car...@te...>]

Hello:

> Did you think about problem i reported about that Expire method in 
> fbconnectionpool??? i still think, that best method is to close 
> connection and firebird will clear all resource for this.. By im afraid 
> that connection lifetime is not working... I will do more tests...

Can be a problem with the timer that i'm using for make the checkout, 
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 
program without pooling ??


> i used explicit prepare, becouse you in IBX (delphi provider) you had to 
> call this for preparing statement for parameter... If i dont need this 
> in netprovider ist great...

Your code is well :) you can make the call but it's not needed.




Best regards
Carlos Guzmán Álvarez
Vigo-Spain


P.S: Thanks for all your feedbak on this  issue.

Re: [Firebird-net-provider] dispose

[Pavol S. <pa...@st...>]

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.

Re: [Firebird-net-provider] dispose

[<car...@te...>]

Hello:

> Did you think about problem i reported about that Expire method in 
> fbconnectionpool???

I have commited a new change to the CVS for fix a problem with lifetime 
if can test it please ( thanks )




Best regards
Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] dispose

[<car...@te...>]

Hello:

> I have commited a new change to the CVS for fix a problem with lifetime 
> if can test it please ( thanks )

My english is really bad :) if you can please test your program with 
latest CVS sources.


Best regards
Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] dispose

[Pavol S. <pa...@st...>]

Carlos Guzm=E1n =C1lvarez wrote:

> Hello:
>
>> I have commited a new change to the CVS for fix a problem with=20
>> lifetime if can test it please ( thanks )
>
>
> My english is really bad :) if you can please test your program with=20
> latest CVS sources.

dont be affraid, im not native english speaking :) i understand you :)=20
Bad english is problem only when you speak with native guy...

As i said, i have problem with compiling your sources right now... So im=20
working on reinstall framework and all things around... It will take few=20
hours... But then i will test it...

>
>
> Best regards
> Carlos Guzm=E1n =C1lvarez
> Vigo-Spain

[Firebird-net-provider] compiling

[Pavol S. <pa...@st...>]

can you send me compiled version??? I still have problems to compile it 
and get working result...
p.

[Firebird-net-provider] Re: compiling

[<car...@te...>]

Hello:


> can you send me compiled version??? I still have problems to compile it 
> and get working result...

Dou you continue to need it ??? i have no problem on send a new package



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] dispose

[Pavol S. <pa...@st...>]

hi guy,

what did you done to provider???? It is creating new ibserver proccess 
for every one cycle :) huh :)

hihih really great i have on server 1435 proccesses of ibserver :)

p.

Re: [Firebird-net-provider] dispose

[<car...@te...>]

Hello:


> DISPOSE IS WORKING... YESSSSSSSSSS.....

Great!! :)

> Firebird is still growing, but not so fast... milion times slower :) Thanx
> for this....

Try without Forced writes, it will be faster but less secure :)

> i think, that in one of yours post may be in help i dont know right now you
> said, that you cannot close connection and still work with reader or
> command, so what about to make connection.close() to dispose all associated
> objects??? 

I can see it.

> becouse before i was trying to force garbage collection in each
> cycle (did not help), so i think, that disposing command and readers is too
> dificult for GC (stupid GC)... 

This is not a real GC problem, the resources that i free in Dispose call 
are allocated in Firebird server and i can make it in class finalizares 
because all object are already collected when it's executed, this is the 
reason for call to Dispose ( as i know this is needed in all .net 
providers :) ).


> i think that this is serious proble and HAVE
> to be solved, becouse without this provider is useless for hevy load...
> 
> and sorry for HTML post before...

it's Nothing :)


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.