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/
