You may need to implement connection pooling, to reduce the number of
connections your app makes to the database.  Some threads then have to wait
until a database session is available before proceeding. There's all sorts
of complex mechanisms for implementing this, but I wrote a super
unsophisticated method utilising the Tag property myself.

I haven't used Apollo, but I am using dbISAM from ElevateSoft, and have
found it to be enourmously reliable, stable, fast, easy to program with and
easy to deploy.


DaveMc
www.mcpond.co.nz





----- Original Message -----
From: "Robert Martin" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Thursday, June 19, 2003 11:15 AM
Subject: [DUG]: TSession


> Hi
>
> We have a multithreaded application that implements multiple sessions to
> handle BDE database activity.  Is there a limit to the number of sessions
> that can be currently active in an application?  I think the BDE is
crashing
> when about 50 Sessions are active.
>
> As an aside, does anyone have experience with the Apollo BDE replacement
> components?  We are looking at moving to them (now they support SQL) but
our
> initial testing shows performance to be far worse than BDE.
>
> Rob
>
> Software engineer
> Wild Software Ltd
> New Zealand
>
> Ph 03 377-0495
> Fax 03 377-0496
>
>
> --------------------------------------------------------------------------
-
>     New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
>                   Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
> Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
>

---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/

Reply via email to