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/
