[firebird-support] Number of concurrent user connections

[Alain Bastien [e-mail] [firebird-support]]

Hi, How many concurrent users can connect to a FireBird database on a
Windows 2003 Std Server (Pentium III 666Mhz) 2GB RAM ?

*AlainBastien*

[Dimitry Sibiryakov [e-mail] [firebird-support]]

How many concurrent users can connect to a FireBird database on a Windows 2003 Std Server
(Pentium III 666Mhz) 2GB RAM ?

1024.
--
WBR, SD.


------------------------------------

------------------------------------

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

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.

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

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-***@yahoogroups.com
firebird-support-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-***@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[Alain Bastien [e-mail] [firebird-support]]

And in a WAN ?


*Kind Regards*


*Alain Bastien*



*34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: [phone]*
*Skype:alainbastien*
*Viber: [phone]*

Post by Alain Bastien ***@gmail.com [firebird-support]

Post by Alain Bastien ***@gmail.com [firebird-support]
How many concurrent users can connect to a FireBird database on a

Windows 2003 Std Server

Post by Alain Bastien ***@gmail.com [firebird-support]
(Pentium III 666Mhz) 2GB RAM ?

1024.
--
WBR, SD.
------------------------------------
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/
resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------
Yahoo Groups Links

[Dimitry Sibiryakov [e-mail] [firebird-support]]

Post by Alain Bastien ***@gmail.com [firebird-support]
And in a WAN ?

TCP/IP has no difference between LAN and WAN.
--
WBR, SD.


------------------------------------

------------------------------------

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

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.

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

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-***@yahoogroups.com
firebird-support-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-***@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[Alain Bastien [e-mail] [firebird-support]]

Is this factor the MAIN difference between DATABASE flavors ?

Capable of handling more users simultaneously


*Kind Regards*


*Alain Bastien*



*34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: [phone]*
*Skype:alainbastien*
*Viber: [phone]*

Post by Dimitry Sibiryakov ***@ibphoenix.com [firebird-support]

Post by Alain Bastien ***@gmail.com [firebird-support]
And in a WAN ?

TCP/IP has no difference between LAN and WAN.
--
WBR, SD.
------------------------------------
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/
resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------
Yahoo Groups Links

[Dimitry Sibiryakov [e-mail] [firebird-support]]

Post by Alain Bastien ***@gmail.com [firebird-support]
Is this factor the MAIN difference between DATABASE flavors ?

No. Knowledge of application developer is the only valuable factor.
--
WBR, SD.


------------------------------------

------------------------------------

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

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.

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

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-***@yahoogroups.com
firebird-support-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-***@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[Alain Bastien [e-mail] [firebird-support]]

I was looking on FaceBook 'sDATA storage and MySQL !!!

For sure millions simultaneous Users connected !!!


*Kind Regards*


*Alain Bastien*



*34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: [phone]*
*Skype:alainbastien*
*Viber: [phone]*

Post by Dimitry Sibiryakov ***@ibphoenix.com [firebird-support]

Post by Alain Bastien ***@gmail.com [firebird-support]
Is this factor the MAIN difference between DATABASE flavors ?

No. Knowledge of application developer is the only valuable factor.
--
WBR, SD.
------------------------------------
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/
resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------
Yahoo Groups Links

[Dimitry Sibiryakov [e-mail] [firebird-support]]

Post by Alain Bastien ***@gmail.com [firebird-support]
I was looking on FaceBook 'sDATA storage and MySQL !!!
For sure millions simultaneous Users connected !!!

There is a definite difference between web site users and database users.
--
WBR, SD.


------------------------------------

------------------------------------

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

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.

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

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-***@yahoogroups.com
firebird-support-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-***@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[Alain Bastien [e-mail] [firebird-support]]

Isn't the connection the same ?

Behind the WEB PAGE, if there is a login and Password, there is a DATABASE

it's either a BROWSER or an APPLICATION isn't it ?


*Kind Regards*


*Alain Bastien*



*34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: [phone]*
*Skype:alainbastien*
*Viber: [phone]*

Post by Dimitry Sibiryakov ***@ibphoenix.com [firebird-support]

Post by Alain Bastien ***@gmail.com [firebird-support]
I was looking on FaceBook 'sDATA storage and MySQL !!!
For sure millions simultaneous Users connected !!!

There is a definite difference between web site users and database users.
--
WBR, SD.
------------------------------------
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/
resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------
Yahoo Groups Links

[Dimitry Sibiryakov [e-mail] [firebird-support]]

Post by Alain Bastien ***@gmail.com [firebird-support]
Isn't the connection the same ?

No, they are completely unrelated.

Post by Alain Bastien ***@gmail.com [firebird-support]
Behind the WEB PAGE, if there is a login and Password, there is a DATABASE

Not necessary. Everything is up to a web site developer.

Post by Alain Bastien ***@gmail.com [firebird-support]
it's either a BROWSER or an APPLICATION isn't it ?

No. Browsers cannot connect to SQL servers.
--
WBR, SD.


------------------------------------

------------------------------------

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

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.

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

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-***@yahoogroups.com
firebird-support-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-***@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[Alain Bastien [e-mail] [firebird-support]]

First there was the command line

Then there was the application

Then came the Graphic User Interface

Then came the Browser

Where ever there is a Login and a Password to connect, there is a Table,
with fields, columns and data type and it a group of table is the starting
point of a DATABASE.

in 1985 I started with dBase II then Dbase III+ all tables were scattered
Password had to be maintained in encrypted tables

So I maintain BROWSERS connect to DATABASE.

SQL is just a language to retrieve data to build INFORMATION

Servers can be PC, it is just a Hardware hosting the DATA





*Kind Regards*


*Alain Bastien*



*34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: [phone]*
*Skype:alainbastien*
*Viber: [phone]*

Post by Dimitry Sibiryakov ***@ibphoenix.com [firebird-support]

Post by Alain Bastien ***@gmail.com [firebird-support]
Isn't the connection the same ?

No, they are completely unrelated.

Post by Alain Bastien ***@gmail.com [firebird-support]
Behind the WEB PAGE, if there is a login and Password, there is a

DATABASE
Not necessary. Everything is up to a web site developer.

Post by Alain Bastien ***@gmail.com [firebird-support]
it's either a BROWSER or an APPLICATION isn't it ?

No. Browsers cannot connect to SQL servers.
--
WBR, SD.
------------------------------------
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/
resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------
Yahoo Groups Links

[Dimitry Sibiryakov [e-mail] [firebird-support]]

Post by Alain Bastien ***@gmail.com [firebird-support]
First there was the command line
Then there was the application

Command line interpreter is an application too.

Post by Alain Bastien ***@gmail.com [firebird-support]
Where ever there is a Login and a Password to connect, there is a Table, with fields, columns and data type and it a group of table is the starting point of a DATABASE.

Tell me: where are tables, columns and data types behind login and password for Linux
console or Windows remote desktop?
--
WBR, SD.


------------------------------------

------------------------------------

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

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.

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

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-***@yahoogroups.com
firebird-support-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-***@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[Alain Bastien [e-mail] [firebird-support]]

Just try to create an existing user (either in Windows or LINUX) again,
the system will automatically reject it
because it is a UNIQUE field. managed by the System ? Kernel ? Application ?

Where are the stored password your Browser keeps each time it ask you
whether you want it to keep it or not.

In A TABLE and it can be viewed in >> Settings > preferences > Security >>
Saved LOGINS and A *BUTTON TO View Password.*

There you will see a Structured Table AND COLUMN : SITE, USERNAME,
LASTLOGIN, LAST CHANGED AND optionally not displayed PASSWORD but can be
viewed upon request.

Now where these are stored ? This is a SECRET

Because an application can be build to copy that table send it by e-mail
and read it.

that application is called a VIRUS







*Kind Regards*


*Alain Bastien*



*34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: [phone]*
*Skype:alainbastien*
*Viber: [phone]*

Post by Dimitry Sibiryakov ***@ibphoenix.com [firebird-support]

Post by Alain Bastien ***@gmail.com [firebird-support]
First there was the command line
Then there was the application

Command line interpreter is an application too.

Post by Alain Bastien ***@gmail.com [firebird-support]
Where ever there is a Login and a Password to connect, there is a Table,

with fields, columns and data type and it a group of table is the starting
point of a DATABASE.
Tell me: where are tables, columns and data types behind login and password for Linux
console or Windows remote desktop?
--
WBR, SD.
------------------------------------
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/
resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------
Yahoo Groups Links

[Elmar Haneke [e-mail] [firebird-support]]

Post by Alain Bastien ***@gmail.com [firebird-support]
I was looking on FaceBook 'sDATA storage and MySQL !!!
For sure millions simultaneous Users connected !!!

I would guess nobody is running an database server with millions of
connections simultaneously open.

On huge Systems as Facebook there are some application servers between
users and database which do serialize database access to an lower number
of connections - it does not make sense to let DB server process
millions of queries simultaneously since the hardware has not that much
parallelity.

Elmar

['Louis van Alphen' [e-mail] [firebird-support]]

It is good practice to only have an open connection to the DB when you need to access or update data. So you have to design your application to, when a request from client is received:

- create and open a connection to the DB (this usually comes from the connection pool)

- select the data your need

- update the data

- close the connection and return it to the pool



It’s a bad idea to keep DB connection permanently open while your app is open. In this way your connection is open for a very short period of time and you can service many user requests with a relatively small number of simultaneous open connections to the DB



Louis







From: firebird-***@yahoogroups.com [mailto:firebird-***@yahoogroups.com]
Sent: 27 October 2016 04:12 PM
To: firebird-***@yahoogroups.com
Subject: Re: {Disarmed} Re: [firebird-support] Number of concurrent user connections

Post by Alain Bastien ***@gmail.com [firebird-support]
I was looking on FaceBook 'sDATA storage and MySQL !!!
For sure millions simultaneous Users connected !!!

I would guess nobody is running an database server with millions of
connections simultaneously open.

On huge Systems as Facebook there are some application servers between
users and database which do serialize database access to an lower number
of connections - it does not make sense to let DB server process
millions of queries simultaneously since the hardware has not that much
parallelity.

Elmar





[Non-text portions of this message have been removed]

[Dimitry Sibiryakov [e-mail] [firebird-support]]

It’s a bad idea to keep DB connection permanently open while your app is open. In this way
your connection is open for a very short period of time and you can service many user
requests with a relatively small number of simultaneous open connections to the DB

And you waste a lot of time and server power for endless connect/disconnect which are
quite heavy operations.
--
WBR, SD.


------------------------------------

------------------------------------

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

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.

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

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-***@yahoogroups.com
firebird-support-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-***@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

['Louis van Alphen' [e-mail] [firebird-support]]

That is why you use the conneciton pool

-----Original Message-----
From: firebird-***@yahoogroups.com
[mailto:firebird-***@yahoogroups.com]
Sent: 27 October 2016 04:31 PM
To: firebird-***@yahoogroups.com
Subject: Re: {Disarmed} Re: [firebird-support] Number of concurrent user
connections

It's a bad idea to keep DB connection permanently open while your app
is open. In this way your connection is open for a very short period
of time and you can service many user requests with a relatively small
number of simultaneous open connections to the DB

And you waste a lot of time and server power for endless
connect/disconnect which are quite heavy operations.
--
WBR, SD.


------------------------------------

------------------------------------

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

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu
there.

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

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links

[Alain Bastien [e-mail] [firebird-support]]

One thing is for sure YOU can't login FACEBOOK with two different IDs from
the SAME PC at the same TIME.

Or even (correct if I'm wrong) SAME ID on to different PCs

There should be a UNIQUE field such MAC ADDRESS + IP + ID managed by the
DATABASE in a TABLE !!!

So there is a TABLE


*Kind Regards*


*Alain Bastien*



*34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: [phone]*
*Skype:alainbastien*
*Viber: [phone]*

Post by Elmar Haneke ***@haneke.de [firebird-support]

Post by Alain Bastien ***@gmail.com [firebird-support]
I was looking on FaceBook 'sDATA storage and MySQL !!!
For sure millions simultaneous Users connected !!!

I would guess nobody is running an database server with millions of
connections simultaneously open.
On huge Systems as Facebook there are some application servers between
users and database which do serialize database access to an lower number
of connections - it does not make sense to let DB server process
millions of queries simultaneously since the hardware has not that much
parallelity.
Elmar

['paul.mercea-almexa.ro' [e-mail] [firebird-support]]

FYI

Post by Alain Bastien ***@gmail.com [firebird-support]
One thing is for sure YOU can't login FACEBOOK with two different IDs
from the SAME PC at the same TIME.

You can, try to use different browsers.

Post by Alain Bastien ***@gmail.com [firebird-support]
Or even (correct if I'm wrong) SAME ID on to different PCs

You can, use you PC and tablet and phone, works.

Post by Alain Bastien ***@gmail.com [firebird-support]
There should be a UNIQUE field such MAC ADDRESS + IP + ID managed by
the DATABASE in a TABLE !!!
So there is a TABLE

Not necessary.

Paul

[Elmar Haneke [e-mail] [firebird-support]]

Post by Alain Bastien ***@gmail.com [firebird-support]
One thing is for sure YOU can't login FACEBOOK with two different IDs
from the SAME PC at the same TIME.

I would assume that to be true for using une WEB-Browser. It shpild be
no Problem to login with two IDs using e.g. chrome for one and foirefox
for the other and there is nothing preventing you to login with an third
ID using konqueror.

Post by Alain Bastien ***@gmail.com [firebird-support]
There should be a UNIQUE field such MAC ADDRESS + IP + ID managed by
the DATABASE in a TABLE !!!

That would suprise me. They certainly do not manage such an table for
current logins.

Client does have an cookie to identify. This cookie is known at
application server which stores such information in RAM. Keyed by that
cookie there is more information about user session stored in RAM.

You should read some basic information about how to make WEB-Applications.

Elmar

[Alain Bastien [e-mail] [firebird-support]]

WEB application uses a BROWSER that's all

It can connect to Static data or to a DATABASE


*Kind Regards*


*Alain Bastien*



*34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: [phone]*
*Skype:alainbastien*
*Viber: [phone]*

Post by Elmar Haneke ***@haneke.de [firebird-support]

Post by Alain Bastien ***@gmail.com [firebird-support]
One thing is for sure YOU can't login FACEBOOK with two different IDs
from the SAME PC at the same TIME.

I would assume that to be true for using une WEB-Browser. It shpild be
no Problem to login with two IDs using e.g. chrome for one and foirefox
for the other and there is nothing preventing you to login with an third
ID using konqueror.

Post by Alain Bastien ***@gmail.com [firebird-support]
There should be a UNIQUE field such MAC ADDRESS + IP + ID managed by
the DATABASE in a TABLE !!!

That would suprise me. They certainly do not manage such an table for
current logins.
Client does have an cookie to identify. This cookie is known at
application server which stores such information in RAM. Keyed by that
cookie there is more information about user session stored in RAM.
You should read some basic information about how to make WEB-Applications.
Elmar

[Dimitry Sibiryakov [e-mail] [firebird-support]]

Post by Alain Bastien ***@gmail.com [firebird-support]
WEB application uses a BROWSER that's all

No, they don't. Web-applications are executed on web-server. There is no browser on server.
--
WBR, SD.


------------------------------------

------------------------------------

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

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.

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

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-***@yahoogroups.com
firebird-support-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-***@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[Alain Bastien [e-mail] [firebird-support]]

I meant client access the (information/Data/Database) Server with a Browser


*Kind Regards*


*Alain Bastien*



*34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: [phone]*
*Skype:alainbastien*
*Viber: [phone]*

Post by Dimitry Sibiryakov ***@ibphoenix.com [firebird-support]

Post by Alain Bastien ***@gmail.com [firebird-support]
WEB application uses a BROWSER that's all

No, they don't. Web-applications are executed on web-server. There is
no browser on server.
--
WBR, SD.
------------------------------------
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/
resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------
Yahoo Groups Links

[Dimitry Sibiryakov [e-mail] [firebird-support]]

Post by Alain Bastien ***@gmail.com [firebird-support]
I meant client access the (information/Data/Database) Server with a Browser

The only protocols supported by browsers are HTTP and FTP. No DBMS can they talk with.
--
WBR, SD.


------------------------------------

------------------------------------

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

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.

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

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-***@yahoogroups.com
firebird-support-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-***@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[Helen Borrie [e-mail] [firebird-support]]

How many concurrent users can connect to a FireBird database on a Windows 2003 Std Server
(Pentium III 666Mhz) 2GB RAM ?

1024.

Actually, in Fb 3, it is 2048. And the "hard limit" applies only to
Superserver mode. The other modes can take as many connections as the
machine can resource. With 2GB RAM, that is not a lot. That machine
would be seriously under-resourced for Classic and not suitable for SC
at all.

HB.

[Dimitry Sibiryakov [e-mail] [firebird-support]]

Post by Helen Borrie ***@iinet.net.au [firebird-support]
Actually, in Fb 3, it is 2048.

Ok.

Post by Helen Borrie ***@iinet.net.au [firebird-support]
That machine
would be seriously under-resourced for Classic and not suitable for SC
at all.

That's why I assumed Superserver and old hardcoded limit.
--
WBR, SD.


------------------------------------

------------------------------------

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

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.

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

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-***@yahoogroups.com
firebird-support-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-***@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[liviuslivius [e-mail] [firebird-support]]

No - you can have aplication server between to serve data to web server
and it e.g. run limited number of connection (espessialy 1 connection to database)
and login and password can be not the db user only application user (table of users and paswsword hash)
 
regards,
Karol Bieniaszewski
 
 
 
W dniu 2016-10-27 15:45:33 uÅŒytkownik Alain Bastien ***@gmail.com [firebird-support] <firebird-***@yahoogroups.com> napisał:
 
Isn't the connection the same ?
Behind the WEB PAGE, if there is a login and Password, there is a DATABASE
it's either a BROWSER or an APPLICATION isn't it ?
 
Kind Regards
 
Alain Bastien
34 Dr Ross Avenue
Rose Hill 72102
Mauritius
Mobile Tel: +230  5 719 30 30
Skype:alainbastien
Viber: [phone]
 
 

Post by Alain Bastien ***@gmail.com [firebird-support]
I was looking on FaceBook 'sDATA storage and MySQL !!!
For sure millions simultaneous Users connected !!!

   There is a definite difference between web site users and database users.
--
   WBR, SD.
------------------------------------
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------
Yahoo Groups Links
    Individual Email | Traditional
    https://info.yahoo.com/legal/us/yahoo/utos/terms/

 

['Paul Beach' [e-mail] [firebird-support]]

1024.

<<Actually, in Fb 3, it is 2048. And the "hard limit" applies only to
Superserver mode. The other modes can take as many connections as the
machine can resource. With 2GB RAM, that is not a lot. That machine
would be seriously under-resourced for Classic and not suitable for SC
at all.>>

Being pedantic - 2.5.3+ and 3.0+ http://tracker.firebirdsql.org/browse/CORE-4439
The limit applies to Windows... SS & SC. But not Classic.
This limit could be increased if needed. Its not a hard limit

https://msdn.microsoft.com/en-us/library/windows/desktop/ms739169%28v=vs.85%29.aspx

Paul