Re: [Firebird-net-provider] Connection Pool

2006-11-06 Thread Jiri Cincura
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/ | http://www.ID3renamer.com

-
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool

2015-10-13 Thread 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. This would make connectionString.MaxPoolSize

You mean:
if (_available.Count() + 1 > connectionString.MaxPoolSize)
throw new
InvalidOperationException("Connection
pool is full.");
?

-- 
Mgr. Jiří Činčura
Independent IT Specialist

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool

2015-10-14 Thread Michał Ziemski
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. This would make connectionString.MaxPoolSize
>
> You mean:
> if (_available.Count() + 1 > connectionString.MaxPoolSize)
> throw new
>
> InvalidOperationException("Connection
> pool is full.");
> ?
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
>
> --
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool bug

2013-11-12 Thread Zvjezdan Tomičević
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
> problem, some memory leaks. I think I might go to rewrite the pooling
> (I implemented one earlier this year for another provider) and test
> it. Hopefully it will be simpler, faster and correct. BUT it might
> (will) not have exactly same API/behavior as the old one (and I don't
> wanna to try mimic it). So it will be huge breaking change if you rely
> on something like that. Of course the major version number will be
> incremented. And I hope I'll not introduce more bugs. ;)
>
> Is there anybody against it?
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> --
> November Webinars for C, C++, Fortran Developers
> Accelerate application performance with scalable programming models.
> Explore
> techniques for threading, error checking, porting, and tuning. Get the most
> from the latest Intel processors and coprocessors. See abstracts and
> register
> http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool bug

2013-11-12 Thread Danny Gorton
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 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
> problem, some memory leaks. I think I might go to rewrite the pooling
> (I implemented one earlier this year for another provider) and test
> it. Hopefully it will be simpler, faster and correct. BUT it might
> (will) not have exactly same API/behavior as the old one (and I don't
> wanna to try mimic it). So it will be huge breaking change if you rely
> on something like that. Of course the major version number will be
> incremented. And I hope I'll not introduce more bugs. ;)
>
> Is there anybody against it?
>

--
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool bug

2013-11-12 Thread Hernan Martinez
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" 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 one earlier this year for another provider) and test
>> it. Hopefully it will be simpler, faster and correct. BUT it might
>> (will) not have exactly same API/behavior as the old one (and I don't
>> wanna to try mimic it). So it will be huge breaking change if you rely
>> on something like that. Of course the major version number will be
>> incremented. And I hope I'll not introduce more bugs. ;)
>> 
>> Is there anybody against it?
>> 
>> --
>> Jiri {x2} Cincura (x2develop.com founder)
>> http://blog.cincura.net/ | http://www.ID3renamer.com
>> 
>> --
>> November Webinars for C, C++, Fortran Developers
>> Accelerate application performance with scalable programming models. Explore
>> techniques for threading, error checking, porting, and tuning. Get the most
>> from the latest Intel processors and coprocessors. See abstracts and register
>> http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
>> ___
>> Firebird-net-provider mailing list
>> Firebird-net-provider@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> --
> DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
> OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
> Free app hosting. Or install the open source package on any LAMP server.
> Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
> http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool bug

2013-11-13 Thread Jiri Cincura
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 connection pooling OFF and OLD provider the application
gained 324 bytes in ~30 minutes.
* [3] With connection pooling ON and OLD provider and explicitly
cleaning the pool the application gained about 1KB in ~33 minutes.
* [4] With connection pooling ON and NEW provider the application
*lost* about 2KB in ~30 minutes.

The application I'm using is not 100% deterministic. It's doing
network requests and running some timers. So it pretty much depends
when the snapshot was taken. I think results are looking good. The [2]
and [4] are basically same, similar [3] and [4].

The tests are all green and the test application (obviously) is not
crashing. That gives me like 50% confidence. :) You can find the build
here https://copy.com/Jh2ebP2sPjyv (.NET 4.5). It has same version
number, it's using same sources, only the connection pooling has been
altered. Thus you can just drop it in your application and try it run.
Or create new and stress it. Whatever you want. I'd like to hear
feedback from your. Even if it's just one quick run, let me know. It
will speed up the deploy greatly.

Also. Backporting the feature to .NET 4.0 is going to be easy. To 3.5
harder, because I rely on ConcurrentDictionary that's in 4.0 and
newer. Bummer. Ideas? Drop 3.5 support? I can implement it on my own
with locking (just for 3.5), but is it worth it?

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

--
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool bug

2013-11-13 Thread André Litfin
For me it's ok dropping 3.5 support - we took 4.0 when 2.0 support was
dropped.

4.0 support would be very appreciated.

I'll take a look right after delivering our update end of the week.

Thank you for your work!

André Litfin 


> -Ursprüngliche Nachricht-
> Von: Jiri Cincura [mailto:disk...@cincura.net]
> 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'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 connection pooling OFF and OLD provider the application gained
> 324 bytes in ~30 minutes.
> * [3] With connection pooling ON and OLD provider and explicitly cleaning
the
> pool the application gained about 1KB in ~33 minutes.
> * [4] With connection pooling ON and NEW provider the application
> *lost* about 2KB in ~30 minutes.
> 
> The application I'm using is not 100% deterministic. It's doing network
> requests and running some timers. So it pretty much depends when the
> snapshot was taken. I think results are looking good. The [2] and [4] are
> basically same, similar [3] and [4].
> 
> The tests are all green and the test application (obviously) is not
crashing.
> That gives me like 50% confidence. :) You can find the build here
> https://copy.com/Jh2ebP2sPjyv (.NET 4.5). It has same version number, it's
> using same sources, only the connection pooling has been altered. Thus you
> can just drop it in your application and try it run.
> Or create new and stress it. Whatever you want. I'd like to hear feedback
> from your. Even if it's just one quick run, let me know. It will speed up
the
> deploy greatly.
> 
> Also. Backporting the feature to .NET 4.0 is going to be easy. To 3.5
harder,
> because I rely on ConcurrentDictionary that's in 4.0 and newer. Bummer.
> Ideas? Drop 3.5 support? I can implement it on my own with locking (just
for
> 3.5), but is it worth it?
> 
> --
> Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ |
> http://www.ID3renamer.com
> 
>

--
> DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
> OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access Free
> app hosting. Or install the open source package on any LAMP server.
> Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
> http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clk
> trk
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider



--
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool bug

2013-11-13 Thread Danny Gorton
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.absolutepowerandcontrol.com
517-499-9069 (mobile)

On 11/13/2013 10:15 AM, Jiri Cincura wrote:
> 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 connection pooling OFF and OLD provider the application
> gained 324 bytes in ~30 minutes.
> * [3] With connection pooling ON and OLD provider and explicitly
> cleaning the pool the application gained about 1KB in ~33 minutes.
> * [4] With connection pooling ON and NEW provider the application
> *lost* about 2KB in ~30 minutes.
>
> The application I'm using is not 100% deterministic. It's doing
> network requests and running some timers. So it pretty much depends
> when the snapshot was taken. I think results are looking good. The [2]
> and [4] are basically same, similar [3] and [4].
>
> The tests are all green and the test application (obviously) is not
> crashing. That gives me like 50% confidence. :) You can find the build
> here https://copy.com/Jh2ebP2sPjyv (.NET 4.5). It has same version
> number, it's using same sources, only the connection pooling has been
> altered. Thus you can just drop it in your application and try it run.
> Or create new and stress it. Whatever you want. I'd like to hear
> feedback from your. Even if it's just one quick run, let me know. It
> will speed up the deploy greatly.
>
> Also. Backporting the feature to .NET 4.0 is going to be easy. To 3.5
> harder, because I rely on ConcurrentDictionary that's in 4.0 and
> newer. Bummer. Ideas? Drop 3.5 support? I can implement it on my own
> with locking (just for 3.5), but is it worth it?
>

--
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool bug

2013-11-14 Thread Jiri Cincura
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.100%29.aspx
http://msdn.microsoft.com/en-us/library/ee855831%28VS.100%29.aspx

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

--
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool bug

2013-11-14 Thread Jiri Cincura
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

--
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool bug

2013-11-14 Thread Zvjezdan Tomičević
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 all the time, i guess it polls constantly.
I have not investigated details about possible leaks.


On Thu, Nov 14, 2013 at 11:35 AM, Jiri Cincura  wrote:

> 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
>
>
> --
> DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
> OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
> Free app hosting. Or install the open source package on any LAMP server.
> Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
> http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool bug

2013-11-14 Thread Jiri Cincura
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.

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

--
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool bug

2013-11-14 Thread Danny Gorton
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 doing much since we're 
also not considering updating the Firebird provider at this time either. 
  The version we have seems to be working just fine and when the time 
comes we'll plan a full component analysis, test cycle, and repackaging 
effort.  Even if circumstances force us into it sooner than we'd like.

Thanks again,
Danny


Danny Gorton II
Co-founder
Absolute Power and Control, LLC
www.absolutepowerandcontrol.com
517-499-9069 (mobile)

On 11/14/2013 05:34 AM, Jiri Cincura wrote:
> 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.100%29.aspx
> http://msdn.microsoft.com/en-us/library/ee855831%28VS.100%29.aspx
>

--
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool bug

2013-11-14 Thread Jiri Cincura
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 to be working just fine and when the time
> comes we'll plan a full component analysis, test cycle, and repackaging
> effort.  Even if circumstances force us into it sooner than we'd like.

Good.

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

--
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool bug

2013-11-18 Thread Jiri Cincura
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

--
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool bug

2013-11-18 Thread André Knappstein
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's your common
> connection lifetime value for pooling? Do you change it or do you use
> the default one?





mit freundlichen Grüßen,

André Knappstein
EDV und Controlling
~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe

Telefon: +49 2389 9240 140
Telefax: +49 2389 9240 150
e-mail:  knappst...@beta-eigenheim.de

Amtsgericht Hamm Nr. B 420
Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus

USt-IDNr.: DE 125215402


--
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool bug

2013-11-18 Thread André Knappstein
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.net/233429-ado-net-provider-for-firebird-4-0-0-0-is-ready/




mit freundlichen Grüßen,

André Knappstein
EDV und Controlling
~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe

Telefon: +49 2389 9240 140
Telefax: +49 2389 9240 150
e-mail:  knappst...@beta-eigenheim.de

Amtsgericht Hamm Nr. B 420
Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus

USt-IDNr.: DE 125215402


--
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool bug

2013-11-18 Thread Jiri Cincura
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

--
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool bug

2013-11-18 Thread André Knappstein

> 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  recommendation  for  you  guys for the evening
dinners:
We  have  only recently been here: http://www.krcmaupavouka.cz/ with a
group of IT guys.
Very   good  food  and beer and for the atmosphere: check the "galery"
and "interiour" section on the website :-)
















--
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool performance issue?

2007-03-12 Thread Jiri Cincura
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 server are busy, under load, etc. Doing this 
"batch" opening doesn't make in real app sense - if it's interactive 
aplication user is not able do to actions so fast and if it's batch app. 
there's no need to use connection pool.

Just my $0.02. But feel free to fetch sources and do any optimalization 
on pool.

-- 
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool performance issue?

2007-03-12 Thread Sean
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 clients reporting to server (say, 500), the server load 
is high. Could you suggest what I shall do?

Best,
Sean


"Jiri Cincura" <[EMAIL PROTECTED]> wrote in message 
news:[EMAIL PROTECTED]
> 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 server are busy, under load, etc. Doing this
> "batch" opening doesn't make in real app sense - if it's interactive
> aplication user is not able do to actions so fast and if it's batch app.
> there's no need to use connection pool.
>
> Just my $0.02. But feel free to fetch sources and do any optimalization
> on pool.
>
> -- 
> Jiri {x2} Cincura
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
>
> -
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share 
> your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> 



-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool performance issue?

2007-03-12 Thread Jiri Cincura
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 
> there are a lot of clients reporting to server (say, 500), the server load 
> is high. Could you suggest what I shall do?

What's the time between connections from one client?

-- 
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool performance issue?

2007-03-12 Thread Sean
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 be 
as small as 10 ms. It takes 10ms ~ 500ms to finish one transaction.

Clients report to server every 10 minutes.  Since clients are started 
randomly, on server side there is no pattern of client connections.

(Do I answer your question?)

"Jiri Cincura" <[EMAIL PROTECTED]> wrote in message 
news:[EMAIL PROTECTED]
> 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
>> there are a lot of clients reporting to server (say, 500), the server 
>> load
>> is high. Could you suggest what I shall do?
>
> What's the time between connections from one client?
>
> -- 
> Jiri {x2} Cincura
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
>
> -
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share 
> your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> 



-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool performance issue?

2007-03-12 Thread Jiri Cincura
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 it between trans.

> pause between transactions, so I guess the time between transactions can be 
> as small as 10 ms. It takes 10ms ~ 500ms to finish one transaction.
> 
> Clients report to server every 10 minutes.  Since clients are started 
> randomly, on server side there is no pattern of client connections.
> 
> (Do I answer your question?)

Yep. :)

-- 
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool performance issue?

2007-03-13 Thread Sean
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
>> 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 it between trans.
>
>> pause between transactions, so I guess the time between transactions can 
>> be
>> as small as 10 ms. It takes 10ms ~ 500ms to finish one transaction.
>>
>> Clients report to server every 10 minutes.  Since clients are started
>> randomly, on server side there is no pattern of client connections.
>>
>> (Do I answer your question?)
>
> Yep. :)
>
> -- 
> Jiri {x2} Cincura
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
>
> -
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share 
> your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> 



-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool performance issue?

2007-03-13 Thread Sean
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 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 it between trans.
>
>> pause between transactions, so I guess the time between transactions can 
>> be
>> as small as 10 ms. It takes 10ms ~ 500ms to finish one transaction.
>>
>> Clients report to server every 10 minutes.  Since clients are started
>> randomly, on server side there is no pattern of client connections.
>>
>> (Do I answer your question?)
>
> Yep. :)
>
> -- 
> Jiri {x2} Cincura
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
>
> -
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share 
> your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> 



-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool performance issue?

2007-03-13 Thread Jiri Cincura
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. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool performance issue?

2007-03-13 Thread Carlos Guzmán Álvarez
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 get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool performance issue?

2007-03-13 Thread Jiri Cincura
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.ID3renamer.com

-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool performance issue?

2007-03-13 Thread Sean
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:
>> 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.ID3renamer.com
>
> -
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share 
> your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3DDE=
> VDEV
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> 



-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool performance issue?

2007-03-13 Thread Jiri Cincura
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/ | http://www.ID3renamer.com

-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool performance issue?

2007-03-13 Thread Sean
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 PROTECTED]> wrote in message 
news:[EMAIL PROTECTED]
> 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/ | http://www.ID3renamer.com
>
> -
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share 
> your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> 



-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool performance issue?

2007-03-13 Thread Jiri Cincura
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 little bit lost. But why not to keep connection opened 
"forever"? If it's server, there's no problem with this.

-- 
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool performance issue?

2007-03-13 Thread Sean
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 
news:[EMAIL PROTECTED]
> 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 little bit lost. But why not to keep connection opened
> "forever"? If it's server, there's no problem with this.
>
> -- 
> Jiri {x2} Cincura
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
>
> -
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share 
> your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> 



-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool in 2.5

2008-03-18 Thread Jiri Cincura
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(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Connection pool in 2.5

2008-03-18 Thread sasha
> 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/vse012070mrt/direct/01/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider



Re: [Firebird-net-provider] Connection pool in 2.5

2008-03-18 Thread Jiri Cincura
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

-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider