Hello Dmitry

Thank you for your answer.

I added the settings SharedDatabase = true and SharedCache = false like
you told and everything worked fine.

Shouldn´t those settings be present in firebird.conf? I had to add them
manually.

About your question 'why not superserver', I performed two simple tests
to measure FB performance, running
in the environment that I described.

Just one user (me) was connected to the server and no other significant
process was running.

With these tests, of course, I don´t intended to give the 'final
solution' about FB performace. They are simple tests only.
I believe better tests could be more illustrative, like processes
running at the same time and concurrently, but ...


The test:

I performed the tests in FB 2.5.3 and FB 3.0.0

First test: I restored the DB from a 'fbk' file.
Second test: I runned a very hard SQL sentence using IBExpert.

This is what I saw:

+------------------+-------------------------------------------+------------------------+--------------------------+
Firebird 2.5.3 : DEFAULT DBCACHEPAGES : Restoring :
SQL :
+------------------+-------------------------------------------+------------------------+--------------------------+
SuperClassic 4500 21:30 minutes : 02:43 minutes :
+------------------+------------------------------------------+-------------------------+--------------------------+
Classic 4500 30:02 minutes : 02:45
minutes :
+------------------+------------------------------------------+-------------------------+--------------------------+
SuperServer 122880 32:01 minutes : after 07:50 minutes
crashed out of resources:
+------------------+------------------------------------------+-------------------------+--------------------------+

+------------------+-------------------------------------------+------------------------+--------------------------+
Firebird 3.0.0 : DEFAULT DBCACHEPAGES : Restoring :
SQL :
+------------------+-------------------------------------------+------------------------+--------------------------+
Classic : 4500 : 15:20 minutes :
03:05 minutes :
+------------------+------------------------------------------+-------------------------+--------------------------+
SuperServer : 32768 : 15:48
minutes : 02:49 minutes :
+------------------+------------------------------------------+-------------------------+--------------------------+

Currently I am using FB 2.5.3 and 60 simultaneous connections.

Than I ask: should I use SuperServer?


Hugo

Em 20/12/2014 07:29, Dmitry Yemanov dimitr@...
[firebird-support] escreveu:

> 19.12.2014 23:30, Hugo Eyng hugoeyng@... [firebird-support] wrote:
>> I am testing FB 3.0.0.31374 BETA.
>> Instalation Classic
> Out of curiosity, why not SuperServer?
>
>> When I try to open the database in a second session I get the error message:
>>
>> Servidor de banco de dados não foi encontrado! *(Database server not found)*
>> I/O error during "CreateFile (open)" operation for file
>> "C:\TEXTIL\DADOS\DM\SGBT\DADOS\DATAMAIS.FDB" *(Entire path for my database)*
>> Error while trying to open file
>> O arquivo já está sendo usado por outro processo. *(File is in use by
>> another process) *
> Check your firebird.conf, for Classic it should have settings
> SharedDatabase = true and SharedCache = false.
>
>
> Dmitry
>
>
>
>
> ------------------------------------
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>
>

--


Atenciosamente,

Hugo Eyng