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.

>