Just wondering:

Is it that complicated to develop thread-safe IBX-like components ? Are there any ?





Tiberiu


----- Original Message ----
From: Thomas Steinmaurer <ts@...>
To: firebird-support@yahoogroups.com
Sent: Sunday, March 16, 2008 11:34:53 AM
Subject: Re: [firebird-support] about threads

Matt,

> Anderson Farias schrieb:
>> BUT, you can always use a database connection pool, that should speed up
>> things (connecting to db), and you don't even need to code your own, you can
>> use IBConnectionBroker that comes with IBX.
>
> Some time ago, I had built such a connection pool myself (create/open a
> connection when needed, reuse it somewhen later, and let it exist - and
> open! - until program termination) . It does work, but deep inside I have
> kind of a "bad feeling" - doesn't it really "hurt" FB if a database
> connection remains open for a looong time, for example, some weeks
> or even months?

If there is an active transaction involved, then for sure (if it is not
a read-only read committed one).

But, connection pool implementation usually have some kind of timeout
parameter which closes a physical connection in the pool after a period
of idle time.

--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene com






____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping