* * *

Author Topic: Implementing a data connection pool - Zeos 7alpha or Cary Jensen's method?  (Read 4358 times)

JD

  • Hero Member
  • *****
  • Posts: 1607
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
Windows (10, 7) - Lazarus 1.8RC5/FPC 3.0.4 (also Delphi occasionally), NewPascal
Linux Mint Cinnamon  - Lazarus 1.8RC5/FPC 3.0.4
Indy 10.6 series; mORMot; Zeos 7.2.1; SQLite, Firebird, PostgreSQL & MariaDB

Zoran

  • Hero Member
  • *****
  • Posts: 1148
    • http://wiki.lazarus.freepascal.org/User:Zoran
Re: Implementing a data connection pool - Zeos 7alpha or Cary Jensen's method?
« Reply #1 on: February 03, 2012, 10:22:14 pm »
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

  • Hero Member
  • *****
  • Posts: 1607
Re: Implementing a data connection pool - Zeos 7alpha or Cary Jensen's method?
« Reply #2 on: February 08, 2012, 03:47:35 pm »
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.

I'll probably stick with Carl Jensen's method because I'm already using it and it works fine for now.
Windows (10, 7) - Lazarus 1.8RC5/FPC 3.0.4 (also Delphi occasionally), NewPascal
Linux Mint Cinnamon  - Lazarus 1.8RC5/FPC 3.0.4
Indy 10.6 series; mORMot; Zeos 7.2.1; SQLite, Firebird, PostgreSQL & MariaDB

esvignolo

  • Full Member
  • ***
  • Posts: 132
  • Using FPC in Windows, Linux, Macos
Re: Implementing a data connection pool - Zeos 7alpha or Cary Jensen's method?
« Reply #3 on: September 01, 2017, 02:59:06 pm »
hello JD, how u used the unit ZDbcPooled.pas ?

Thanks!

JD

  • Hero Member
  • *****
  • Posts: 1607
Re: Implementing a data connection pool - Zeos 7alpha or Cary Jensen's method?
« Reply #4 on: September 03, 2017, 07:42:01 pm »
hello 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
« Last Edit: September 03, 2017, 07:44:59 pm by JD »
Windows (10, 7) - Lazarus 1.8RC5/FPC 3.0.4 (also Delphi occasionally), NewPascal
Linux Mint Cinnamon  - Lazarus 1.8RC5/FPC 3.0.4
Indy 10.6 series; mORMot; Zeos 7.2.1; SQLite, Firebird, PostgreSQL & MariaDB

 

Recent

Get Lazarus at SourceForge.net. Fast, secure and Free Open Source software downloads Open Hub project report for Lazarus