Geoff wrote:
>You could upload a tarball to Webware's Patch page on SourceForge,
>in which case it'll get considered for inclusion in the next
>Webware release.
OK, I'll do this, thanks!
...Edmund.
___
Have big pipes? SourceForge.n
Edmund Lian wrote:
> I also rewrote DBPool a bit to properly implement the "State" pattern
> (separation of implementation from public interface). I
> wasn't happy about
> the mingling of interface and implementation in DBPool since
> it made it
> harder than necssary to add new methods, etc.
>
> Doesn't that limit you to a single ConnectionPool? What
> if you want
> multiple pools for different databases?
Here's how I do it (similar to a few other folks):
module (DatabaseWrap) which holds the connectionpools and
provides a few simplified query functions.
module level dictionary call
On Friday 03 May 2002 08:51 am, Tavis Rudd wrote:
> On a side note, how did the Application class get its name?
Taken from WebObjects. Also, I intended having multi-application
serving, but Jay beat me to the punch with Contexts and I never got
around to any architectural changes.
-Chuck
Ian Bicking wrote:
>One technique I've thought about in lieu of round-robin pooling is
>simply allocating one connection per thread. E.g.:
>
>def makeConnection():
>return dbadapter.connect(arg1, arg2, etc)
>
>_connectionPool = {}
>def getConnection():
>name = threading.currentThread().g
One technique I've thought about in lieu of round-robin pooling is
simply allocating one connection per thread. E.g.:
def makeConnection():
return dbadapter.connect(arg1, arg2, etc)
_connectionPool = {}
def getConnection():
name = threading.currentThread().getName()
if not _connecti
Geoff wrote:
>Doesn't that limit you to a single ConnectionPool? What if you want
>multiple pools for different databases?
I have some code that builds on a rewrite of DBPool to give multiple named
pools to different databases. With the code, one uses a configuration file
to specify DB pools,
Karl Putland wrote:
> Geoffrey Talvola wrote:
>
> >Karl Putland wrote:
> >
> >>The one thing that I never figured out was how to use DBPool
> >>in a fasion
> >>that actually allowed the pool to exits once and keep the pool of
> >>connections.
> >>This was my motication to write my own pooling
Geoffrey Talvola wrote:
>Karl Putland wrote:
>
>>The one thing that I never figured out was how to use DBPool
>>in a fasion
>>that actually allowed the pool to exits once and keep the pool of
>>connections.
>>This was my motication to write my own pooling mechanism.
>>I see now that you store
Karl Putland wrote:
> Chuck Esterbrook wrote:
>
> >On Friday 03 May 2002 06:55 am, Costas Malamas wrote:
> >
> >>Well, I am convinced, I'll go ahead and try it out.
> >>
> >>What I am not following from the docs though is how do you use
> >>DBPool; I am not familiar with threading (at all!), so I
uot; <[EMAIL PROTECTED]>,
>[EMAIL PROTECTED]
>Subject: Re: [Webware-discuss] DB Connection Pulling
>Date: Fri, 3 May 2002 07:51:30 -0700
>
>On Friday 03 May 2002 06:55 am, Costas Malamas wrote:
> > Well, I am convinced, I'll go ahead and try it out.
> >
> > What
Chuck Esterbrook wrote:
>On Friday 03 May 2002 06:55 am, Costas Malamas wrote:
>
>>Well, I am convinced, I'll go ahead and try it out.
>>
>>What I am not following from the docs though is how do you use
>>DBPool; I am not familiar with threading (at all!), so I don't get
>>the setup. E.g. do you
On May 3, 2002 07:51 am, Chuck Esterbrook wrote:
> Every time you think of subclassing Application just to store
> application wide resources, you could just as easily (or more easily)
> get along with a module for this purpose and put the objects in module
> level variables.
>
> This might also l
Sent: Friday, May 03, 2002 9:56 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [Webware-discuss] DB Connection Pulling
Well, I am convinced, I'll go ahead and try it out.
What I am not following from the docs though is how do you use DBPool; I am
not familiar with threadi
On Friday 03 May 2002 06:55 am, Costas Malamas wrote:
> Well, I am convinced, I'll go ahead and try it out.
>
> What I am not following from the docs though is how do you use
> DBPool; I am not familiar with threading (at all!), so I don't get
> the setup. E.g. do you call DBPool once in your app
On Thursday 02 May 2002 07:20 pm, Rolf Hanson wrote:
> At the risk of sounding stupid, how are you folks doing this type of
> testing?
> I.e. how are you telling for certain that the connections are being
> allocated in a
> round-robin fashion?
I only ever tested for speed, which I did via some b
ED]>
>To: [EMAIL PROTECTED]
>Subject: Re: [Webware-discuss] DB Connection Pulling
>Date: Thu, 2 May 2002 16:29:37 -0700
>
>I did, in fact, experience a speedup when using DBPool with MySQL, so I
>removed that comment from the source code.
>
>I use DBPool on my produc
Rolf wrote:
>At the risk of sounding stupid, how are you folks doing this type of
>testing?
>I.e. how are you telling for certain that the connections are being
>allocated in a round-robin fashion?
Speaking for myself only, I use ps aux to watch the thread/connection
allocation. Obviously, you
At the risk of sounding stupid, how are you folks doing this type of
testing?
I.e. how are you telling for certain that the connections are being
allocated in a
round-robin fashion?
Thanks,
Rolf
On Thursday, May 2, 2002, at 10:10 PM, [EMAIL PROTECTED] wrote:
>
> David Hancock wrote:
>
>>> My
David Hancock wrote:
>>My testing has shown about 10:1 performance boost using DBPool.py to pool
connections to Oracle. After looking at the database machine I'm connecting
to, I can tell you for certain that the connections are being pooled and
allocated in a nice round-robin fashion.<<
I agre
I did, in fact, experience a speedup when using DBPool with MySQL, so I
removed that comment from the source code.
I use DBPool on my production site (via a MiddleKit setting) with MySQL
at 20 connections.
-Chuck
On Thursday 02 May 2002 03:11 pm, Hancock, David \(DHANCOCK\) wrote:
> I only r
I only recollect that it was reported that there was no speed boost using
MySQL, and nobody else had reported any results.
My testing has shown about 10:1 performance boost using DBPool.py to pool
connections to Oracle. After looking at the database machine I'm connecting
to, I can tell you for c
On Thu, 2002-05-02 at 15:57, Costas Malamas wrote:
> I remember there was a conversation here about DBPool.py and how it is not
> really pooling DB Connections. Has anybody attacked this problem?
>
> Thanks,
>
I've got a ConnectionPool class that I wrote.
And your welcome to have a look at it
23 matches
Mail list logo
