I have worked the last days on a generic connection pool for Pharo. The
objective is to improve performances for an application that uses a network data source (databases, LDAP, etc.).
Hi Olivier. First, let me say that we really appreciate your project and we are happy with it :)
Now, to avoid reinventing the wheel, I want to point you some stuff.
1) There is a GlorpDBX connection pool available. This is the package GlorpDBX-ConnectionPool. Documentation: http://www.squeakdbx.org/documentation/SqueakDBX%20connection%20pool%20for%2...
2) There is a general purpose pool (for any kind of object) that also work in Glorp or DBXTalk.
http://www.squeaksource.com/ObjectPool
There is a package ObjectPool-GlorpDBX :) I cc'ed Panu, the developer.
So...maybe you can join forces with him?
My work is now stable and the gain of performances is good. For exemple, I have a benchmark that uses a SqueakDBX/PostgreSQL database and a LDAP directory. Without the pool, the test take 6,61s, with the pool, only 0,367s :-)
I have made many stress tests for testing the fiability. This morning, the connection pools has processed 270000 requests without problems.
I think that my project can interest you.
sure it does!!!
I don't know if the code is ready for production.
It doesn't matter. It is good to know about it.
The projet is on squeaksource and I have added your account (and Stef also) as Guest.
MCHttpRepository location: 'http://www.squeaksource.com/FasterThatLight' user: '' password: ''
Thanks for remarks and critics.
Thanks. I will take a look. For the pools, the expert is Diogenes and Panu :)
Best regards,
squeakdbx@lists.squeakfoundation.org