[Firebird-devel] fb3 access modes under windows

2014-01-29 Thread Paul Reeves
I was playing with the different access configurations for FB 3 in firebird.conf. (with Alpha2) With this configuration: SharedCache = true SharedDatabase = true and server installed as SS. (ie, instsvc i ) Access via localhost is denied: C:\Program Files\Firebird\Firebird_3_0isql -user

Re: [Firebird-devel] fb3 access modes under windows

2014-01-29 Thread Vlad Khorsun
The reason I was trying this was to try and answer Pavel's question - how do you run SuperClassic under FB3 on Windows? AFAICT it is not possible. Really ? :) I don't mind - SuperClassic seems to share the worst features of SuperServer and ClassicServer, and we should officially

Re: [Firebird-devel] fb3 access modes under windows

2014-01-29 Thread Paul Reeves
On Wednesday 29 January 2014 15:03:02 Vlad Khorsun wrote: But the questions will be asked - how can we run SC under FB3? Isn't it was explained when shared page cache was committed ? Possibly - but I don't think it has been fully documented since then. I'm just an ordinary clueless user

[Firebird-devel] [OmniAccounts Priority Support] Re: fb3 access modes under windows

2014-01-29 Thread m...@omniaccounts.co.za
Thank you for your email sent to prior...@omniaccounts.co.za Please be aware that we will only be respond to emails to this address if you have purchased a Support option which includes Priority Email Support. Should you not have valid Priority Email Support then your email will be returned

Re: [Firebird-devel] fb3 access modes under windows

2014-01-29 Thread Dmitry Yemanov
29.01.2014 18:37, Paul Reeves wrote: I guess what we really need is to document in firebird.conf how the -m switch affects the other two settings. There would seem to be a total of eight combinations. Lack of -m switch along with SharedDatabase = false means that only the first connection

Re: [Firebird-devel] fb3 access modes under windows

2014-01-29 Thread Paul Reeves
On Wednesday 29 January 2014 17:20:16 Dmitry Yemanov wrote: 29.01.2014 18:37, Paul Reeves wrote: I guess what we really need is to document in firebird.conf how the -m switch affects the other two settings. There would seem to be a total of eight combinations. Lack of -m switch along with

Re: [Firebird-devel] fb3 access modes under windows

2014-01-29 Thread Dmitry Yemanov
29.01.2014 20:51, Paul Reeves wrote: # SharedCache SharedDatabase -m Mode # false false * SC single attach only Interesting. Does that differ internally from # truefalse - ? SS single attach only Mostly it doesn't, except the fact that

Re: [Firebird-devel] fb3 access modes under windows

2014-01-29 Thread Dimitry Sibiryakov
29.01.2014 18:02, Dmitry Yemanov wrote: 29.01.2014 20:51, Paul Reeves wrote: # SharedCache SharedDatabase -m Mode # false false * SC single attach only Interesting. Does that differ internally from # truefalse - ? SS single attach only

Re: [Firebird-devel] fb3 access modes under windows

2014-01-29 Thread Dmitry Yemanov
29.01.2014 21:07, Dimitry Sibiryakov wrote: How about difference latch only vs latch+lock? Does it still exist in v3? Page locks are not used until the second connection appears. And other lock types don't affect single-threaded performance. Dmitry

Re: [Firebird-devel] fb3 access modes under windows

2014-01-29 Thread Leyne, Sean
My last post got munged: It should have read: The reality is that there are only 2 set of options:: EngineMode/EngineType = Classic | SuperServer | SuperClassic DatabaseAccess = Shared | Single The install options should take their cue from the config settings, and not require inline

Re: [Firebird-devel] fb3 access modes under windows

2014-01-29 Thread Dmitry Yemanov
29.01.2014 21:10, Leyne, Sean wrote: EngineMode/EngineType = Classic | SuperServer | SuperClassic DatabaseAccess = Shared | Single The install options should take their cue from the config settings, and not require inline switches. Config options are database wise, so using them at the

Re: [Firebird-devel] fb3 access modes under windows

2014-01-29 Thread Leyne, Sean
On Wednesday 29 January 2014 17:20:16 Dmitry Yemanov wrote: 29.01.2014 18:37, Paul Reeves wrote: I guess what we really need is to document in firebird.conf how the -m switch affects the other two settings. There would seem to be a total of eight combinations. Lack of -m switch

Re: [Firebird-devel] fb3 access modes under windows

2014-01-29 Thread Leyne, Sean
29.01.2014 21:10, Leyne, Sean wrote: EngineMode/EngineType = Classic | SuperServer | SuperClassic DatabaseAccess = Shared | Single The install options should take their cue from the config settings, and not require inline switches. Config options are database wise, so using

Re: [Firebird-devel] fb3 access modes under windows

2014-01-29 Thread Dimitry Sibiryakov
29.01.2014 18:30, Leyne, Sean wrote: how will a less experienced user/developer? They will never change the settings from default which is optimal for most configurations. -- WBR, SD. -- WatchGuard Dimension

Re: [Firebird-devel] fb3 access modes under windows

2014-01-29 Thread Alex Peshkoff
On 01/29/14 21:35, Dimitry Sibiryakov wrote: 29.01.2014 18:30, Leyne, Sean wrote: how will a less experienced user/developer? They will never change the settings from default which is optimal for most configurations. In posix we have shell script making it possible to easily switch