Hi!
I've made a pull request on github with my proposal.
Cheers!
Michał
2015-10-14 7:52 GMT+02:00 Jiří Činčura :
> On Tue, Oct 13, 2015, at 22:53, Michał Ziemski wrote:
> > I would rather also test connectionString.MaxPoolSize with the
> > "_available"
> > stack
> > and not the "_busy" list. Th
On Tue, Oct 13, 2015, at 22:53, Michał Ziemski wrote:
> I would rather also test connectionString.MaxPoolSize with the
> "_available"
> stack
> and not the "_busy" list. This would make connectionString.MaxPoolSize
You mean:
if (_available.Count() + 1 > connectionString.MaxPoolSize)
Hi!
I've jest run into a problem with the connection pool.
When I reach the limit an exception is thrown.
It seems to me as an suboptimal thing to di in such a case.
Con pool is there to gain speed and random exceptions are IMHO too high a
price to pay.
I think in such a case new connections sh
> No, only in Prague.
OK, I will nevertheless try to put all required stuff on my yoga and
test it there and then.
I can't go to two FB-Seminars in 4 days, or my wife will close the
connection without doing a proper commit() :-) Otherwise I'd love to
join there.
If I should make a
On Mon, Nov 18, 2013 at 12:28 PM, André Knappstein
wrote:
> Did I get that right and you're in
> Siegburg?
No, only in Prague. :(
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Thanks to SMS-Timing and even more thanks to you.
I'll do some test installs later. Did I get that right and you're in
Siegburg? I'll install and test right there, then.
> OK guys, the new version is out. This work was fully supported by
> SMS-Timing. Big thanks to them.
> http://blog.cincura.n
Default,
planned to monitor some things for possible optimizations, but did not
find the time so far.
General response time and performance and resources consumption of
my C#/Firebird applications is more than fine with the users, so no hurry.
> And just a one quick "research" question. What'
OK guys, the new version is out. This work was fully supported by
SMS-Timing. Big thanks to them.
http://blog.cincura.net/233429-ado-net-provider-for-firebird-4-0-0-0-is-ready/
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
On Thu, Nov 14, 2013 at 5:50 PM, Danny Gorton
wrote:
> However, that shouldn't really affect what you're doing much since we're
Yeah, I just like to hear what are others doing and thinking.
> also not considering updating the Firebird provider at this time either.
> The version we have seems t
Thanks for the info Juri. I failed to mention that we're a
cross-platform solution, with Linux being the main one, so I'm more
concerned with compatibility on Mono than on Windows. It will just
require some test cycles we don't have right now.
However, that shouldn't really affect what you're
On Thu, Nov 14, 2013 at 11:46 AM, Zvjezdan Tomičević wrote:
> Polling with default value
I'm asking to know what "resolution" should the cleanup routine have.
Like if everybody uses lifetime 10s, than resolution 5s is fine, even
10s is fine, though the connection might be in a pool little longer.
I use firebird heavily in sports betting solution, with many simultaneous
connections, in desktop environment, web services and virtually everywhere.
Current deployed version is 2.6.0.0, 3.5 build. No major problems here at
all.
Polling with default value,and for events no polling.
Since DB is hit
And just a one quick "research" question. What's your common
connection lifetime value for pooling? Do you change it or do you use
the default one?
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
-
Hi,
On Wed, Nov 13, 2013 at 8:34 PM, Danny Gorton
wrote:
> If 4.0 backward compatibility is
> OK, then it would be OK
It's probbaly not 100%, but in case you're not relying on some "weird"
behavior you found, you should be OK. You can read:
http://msdn.microsoft.com/en-us/library/ee941656%28VS.1
I'm not sure about being able to lose 3.5 support. We haven't tested,
or planned to test, migrating forward. If 4.0 backward compatibility is
OK, then it would be OK, though we aren't using any 4.0 language features.
Danny Gorton II
Co-founder
Absolute Power and Control, LLC
www.absolutepowera
on: Jiri Cincura [mailto:[email protected]]
> Gesendet: Mittwoch, 13. November 2013 16:16
> An: For users and developers of the Firebird .NET providers
> Betreff: Re: [Firebird-net-provider] Connection pool bug
>
> OK guys. First thanks for the support. It's not an easy change and there&
OK guys. First thanks for the support. It's not an easy change and
there's a lot of code already and I need to squeeze myself in, with my
concept. But here are some first numbers:
* [1] With connection pooling ON and OLD provider the application
gained about 276KB in ~30 minutes.
* [2] With connec
I agree.
Hernán MF
> El 12/11/2013, a las 22:28, Zvjezdan Tomičević escribió:
>
> go ahead. do it properly.
>
>> On Nov 12, 2013 4:08 PM, "Jiri Cincura" wrote:
>> Hi *,
>>
>> I found a bug in connection pool. I *don't* know the root cause. But
>> anyway I think the code there isn't "good"
Sometimes you it's better to make breaking changes than to live with the
mess that results from trying to be too accommodating. I say fix it right.
Danny Gorton II
Co-founder
Absolute Power and Control, LLC
www.absolutepowerandcontrol.com
517-499-9069 (mobile)
On 11/12/2013 10:07 AM, Jiri Cincu
go ahead. do it properly.
On Nov 12, 2013 4:08 PM, "Jiri Cincura" wrote:
> Hi *,
>
> I found a bug in connection pool. I *don't* know the root cause. But
> anyway I think the code there isn't "good" or "nice", so to speak. But
> I currently have an application in front of me, that escalates the
>
Hi *,
I found a bug in connection pool. I *don't* know the root cause. But
anyway I think the code there isn't "good" or "nice", so to speak. But
I currently have an application in front of me, that escalates the
problem, some memory leaks. I think I might go to rewrite the pooling
(I implemented
On 3/18/08, sasha <[EMAIL PROTECTED]> wrote:
> > http://tracker.firebirdsql.org/browse/DNET-156 ???
>
>
> Yes, seems it is same problem...
I haven't time to look at this issue. But it's important.
--
Jiri {x2} Cincura (CTO x2develop)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
---
> http://tracker.firebirdsql.org/browse/DNET-156 ???
Yes, seems it is same problem...
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012000
http://tracker.firebirdsql.org/browse/DNET-156 ???
--
Jiri {x2} Cincura (CTO x2develop)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(
Hi, Jiri.
I'm trying to use provider 2.5 in ASP.NET application with FireBird 2.1
and sometimes this application hangs (i've got connection timeouts after
that).
Few years ago we had similar problem with connection pool and made patch
and sent it to Carlos. Carlos applied it into 1.7.1 or 2.0 (
Yes, I always keep connection opened forever in pool.
The reason I asked about ConnectionLifeTime is that, I saw a post about
changing ConnectionLifeTime for testing a problem, I was wondering if I
shall do it... Looks like there is no need.
"Jiri Cincura" <[EMAIL PROTECTED]> wrote in message
Sean wrote:
> So sorry for the confusion. The owner of the embedded database is server,
> which handles data reported from hundreds of clients. So the server keeps
> open connections, saves the data into db and close connections. (You can
> ignore that "10 minutes" thing completely.)
Humm, I'm
So sorry for the confusion. The owner of the embedded database is server,
which handles data reported from hundreds of clients. So the server keeps
open connections, saves the data into db and close connections. (You can
ignore that "10 minutes" thing completely.)
"Jiri Cincura" <[EMAIL PROTEC
Sean wrote:
> My application opens and closes db connections frequently. I think this is
> where connection pool can be of the most help, right?
In previous mails you said, that app. is reporting data into DB in
10mins. intervals. I'm confused.
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka
My application opens and closes db connections frequently. I think this is
where connection pool can be of the most help, right?
In which scenario should connection pool be used?
"Jiri Cincura" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Carlos Guzm=E1n =C1lvarez wrote:
>> Hop
Carlos Guzmán Álvarez wrote:
> Hope he means Connection Life Time ( when it's 0 connections never dead )
Ha, damn.
AFAIR my advice, you're application doesn't have any benefit from pool,
so connection lifetime is off-topic.
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3ren
Hello:
> What is the "Connection Lift Time"?
Hope he means Connection Life Time ( when it's 0 connections never dead )
>
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll
Sean wrote:
> BTW, shall I keep "Connection Lift Time" forever, or set it to some number?
What is the "Connection Lift Time"?
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
Take Surveys. Ea
BTW, shall I keep "Connection Lift Time" forever, or set it to some number?
"Jiri Cincura" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Sean wrote:
>> For every client tcp connection, a bunch of transactions are performed
>> consecutively to insert different types of data into di
Ok, I will try that. Thanks a lot for the suggestion.
I thought it didn't matter much since I was using connection pool.
"Jiri Cincura" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Sean wrote:
>> For every client tcp connection, a bunch of transactions are performed
>> consecut
Sean wrote:
> For every client tcp connection, a bunch of transactions are performed
> consecutively to insert different types of data into different tables. A db
> connection is opened and closed for each transaction. There is no explicit
Keep connection opened. There's no need to open/close i
For every client tcp connection, a bunch of transactions are performed
consecutively to insert different types of data into different tables. A db
connection is opened and closed for each transaction. There is no explicit
pause between transactions, so I guess the time between transactions can b
Sean wrote:
> In my case, I have a client-server architecture. Client collects data and
> server saves them into embedded firebird database.
> Clients collect data automaticly and report to server periodically. The
> number of clients are different in different deployment, from 1 to 500. When
>
In my case, I have a client-server architecture. Client collects data and
server saves them into embedded firebird database.
Clients collect data automaticly and report to server periodically. The
number of clients are different in different deployment, from 1 to 500. When
there are a lot of cl
Sean wrote:
> Question:
> In scenario 1, the average execution time for an iteration dropped from 1.2s
> to 4s when 2 threads competed for 1 connection from the pool. Is this a
> performance problem?
Theoretically yes, in real world IMO not so. The pool has great impact
on speed when line or s
Hi,
I have a program testing connection pool performance in multi-thread
context. I am using firebird 1.5 and .net provider 2.0.1.
I have a thread. The thread does "open-connection, insert-records,
close-connection" for 20 times to insert different data into different
tables, then loops back.
Pham Huu Le Quoc Phuc wrote:
> Hi!
>
> Can I use connection pool with “using keyword”. Is it leak memory?
>
>
>
> Using(FbConnection Connection = new FbConnection(ConnectionString)
>
> {
>
> }
>
Yes you can. It's not a memory leak.
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | ht
Hi!
Can I use connection pool with “using
keyword”. Is it leak memory?
Using(FbConnection Connection = new
FbConnection(ConnectionString)
{
}
Thanks.
-
Using Tomcat but need to do more? Need to support
43 matches
Mail list logo
