In classic, each connection forks a new process. So a lot of
connections (e.g. users) will create a lot of processes which are
resource (memory) intensive.
As to what is "a lot" it depends on your configuration file (e.g. cache
settings, etc.) and how much memory is installed.
Run a test and find out how many active connections, fill up available
memory, and use that as the limit on your application server's
connection pool.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of toddmxz
Sent: Thursday, January 31, 2008 1:51 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Firebird and SMP support

Rick,

Your right there mst be multiple connections. The best way to reslove
this is to setup a test machine which I will do and see if classic will
give me a performance increase over superserver.

I was wondering if someone could expound on this comment:
"Doesn't scale that good when a of lot users are connected." What is
alot of users?

Thanks again,
Todd
--- In firebird-support@yahoogroups.com, "Rick Debay" <rdebay@...>
wrote:

>
> > the application server make a single connection to the database

thus

> making classic mode not feasible
>
> I'm sure if there is more than one query to the database, your

server is

> making multiple connections*. If the simultaneous load is such that
> there is only one active connection at a time, then SMP isn't going

to

> help anything.
>
> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of toddmxz
> Sent: Thursday, January 31, 2008 1:27 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Re: Firebird and SMP support
>
> Hi,
>
> I now understand better where one of my problems lies. We use an
> application server to connect to the database the application server
> make a single connection to the database thus making classic mode

not

> feasable. Or at least not beneficial for us that I can tell. Is

work

> being done to make Superserver mode support SMP in the model I

stated

> above?
>
> Thanks,
> Todd
>
> Disclaimer: This message (including attachments) is confidential

and may be privileged. If you have received it by mistake please notify
the sender by return e-mail and delete this message from your system.
Any unauthorized use or dissemination of this message in whole or in
part is strictly prohibited. Please note that e-mails are susceptible to
change. RxStrategies, Inc. shall not be liable for the improper or
incomplete transmission of the information contained in this
communication or for any delay in its receipt or damage to your system.
RxStrategies, Inc. does not guarantee that the integrity of this
communication has been maintained nor that this communication is free
from viruses, interceptions or interference.

>

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item on the
main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links