Thanks Dave

In between posting my previous email I have completely rewritten the part of
the software where lots of sessions were being generated, the BDE no longer
dies under the strain and performance seems slightly better.

I don't know much about dbISAM but the attraction of Apollo was
1.  100% VCL compatible TTable / TQuery components
2.  Dbase access.


Rob

Software engineer
Wild Software Ltd
New Zealand

Ph 03 377-0495
Fax 03 377-0496
----- Original Message -----
From: "David McNeill" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Thursday, June 19, 2003 12:37 PM
Subject: Re: [DUG]: TSession


> 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/
>
>


---------------------------------------------------------------------------
    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