Implementing a data connection pool - Zeos 7alpha or Cary Jensen's
method?
lazarus / 16-Databases

----------------------------------------------------------------------
JD · 2012-02-03 14:42

Hi there everyone,

I wonder if anyone is currently using a connection pool for concurrent
access to a database server over a network or the Internet.

I just started a project using Cary Jensen's connection pool (written
in Delphi) located at the URL below:
http://edn.embarcadero.com/article/30027

However, then I noticed that Zeos 7 alpha has TZConnectionGroup and
TZGroupedConnection. The problem is there are no examples of its
usage. Is anyone here on this forum using the Zeos' connection pool
method at the moment?

What I would also like to know is which is the simpler of the two
implementations?

Thanks for your kind assistance.

JD

----------------------------------------------------------------------
Zoran · 2012-02-03 21:22

I found this topic from Zeos forum which seems to be how these
components started: http://zeos.firmos.at/viewtopic.php?t=2760
I never used these components, though.

----------------------------------------------------------------------
JD · 2012-02-08 14:47

Quote from: Zoran on February 03, 2012, 10:22:14 pmI found this topic
from Zeos forum which seems to be how these components started:
http://zeos.firmos.at/viewtopic.php?t=2760
I never used these components, though.

I'll probably stick with Carl Jensen's method because I'm already
using it and it works fine for now.

----------------------------------------------------------------------
esvignolo · 2017-09-01 12:59

hello JD, how u used the unit ZDbcPooled.pas ?

Thanks!

----------------------------------------------------------------------
JD · 2017-09-03 17:42

Quote from: esvignolo on September 01, 2017, 02:59:06 pmhello JD, how
u used the unit ZDbcPooled.pas ?

Thanks!

Hi there esvignolo. I asked the same question on the Zeos forums and I
did not get a satisfactory answer. I then settled for a Delphi/Lazarus
based connection pool (initially Cary Jensen's connection pool and
later another one) that created several Zeos objects at startup for
the project. The initial pool size is 20 connections with the ability
to grow if needed. It is still in use to this day (Sept 2017).

JD