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 dim...@users.sourceforge.net
[firebird-support] escreveu:
> 19.12.2014 23:30, Hugo Eyng hugoe...@msn.com [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
------------------------------------
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
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-dig...@yahoogroups.com
firebird-support-fullfeatu...@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/
