How can I tell which Firebird architecture is installed (classic or super-server) for win32?

Posted on 2009-12-17
Medium Priority
Last Modified: 2013-12-09
1. How can I tell if an existing Firebird installation is configured/installed/running in Classic Server / Super-Server mode?
2. How can I switch between the two?
3. Which versions of Firebird and which architectures support multi-threaded applications on multi-processor servers?
4. How to configure Firebird on multi-processor servers?
Question by:samenglish
  • 4

Author Comment

ID: 26078264
re Q1:

Look for fbserver.exe (and potentially fbguardian.exe) in firebird_dir\bin fodler for Super-Server installations; and look for fb_inet_server for Classic Server installations.

re Q2:

doesn't look it's possible to "switch modes". Might have to uninstall/reinstall, or potentially install multiple instances (2nd install has to be done manually - not with the installer - refer to http://www.firebirdsql.org/rlsnotes/Firebird-2.1.3-Installation.pdf

still working on Q3 and Q4.

Author Comment

ID: 26078838
re Q3: Only Classic Server architecture supports multiple cpu's and there's a comparison chart here http://www.iblogmanager.com/download/misc/articles/fb25_architecture_comparison.pdf

Author Comment

ID: 26079024
re Q2: You can switch between modes by effectively uninstalling the service and reinstalling it with different parameters as Andrei advised here http://stackoverflow.com/questions/1926731/firebird-architecture

Accepted Solution

samenglish earned 0 total points
ID: 26290313
Here's the answer... (thanks Andrei)

Close all client connections. Got to Firebird\Bin directory. Execute specified sequence of commands:

instsvc stop
instsvc remove
then either:

instsvc install -s -a   -- for Super Server

instsvc install -c -a   -- for Classic
after that:

instsvc start
3 -- Super Server always runs on single processor or core and can not scale. Use Classic architecture in SMP environment. In latter case dont specify page buffers more than 800-1000.

Be aware that performance of Classic Server depends on performance of disk subsystem. For big databases use RAID controllers with internal cache memory, battery and "write back" mode enabled.

Featured Post

Reclaim your office - Try the MB 660 headset now!

High level of background noise often makes it difficult for employees to concentrate fully on their jobs – or to communicate clearly on calls. The MB 660 headset helps you create a disruption free workspace.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
In this article, we’ll look at how to deploy ProxySQL.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question