Subject AW: [firebird-support] Architecture
Author checkmail
Hello Thomas,

Thanks. For some Years, we have had in use the superserver, but since we
have a quadcore CPU, we are using cs.

UDFs can I replace with build in functions

Now, I have restored the database with 2.5, but.. Errors :( Now I have seen
the new switches -fix_fss_d and m, but now I get another error, no character
set were found. Is there another way to migrate? With the scripts while
running 2.1?


-----Urspr√ľngliche Nachricht-----
Gesendet: Freitag, 8. Januar 2016 16:37
Betreff: Re: [firebird-support] Architecture

Hello Olaf,

> Hello,
> I plan an update of firebird 2.1 cs 32 Bit with 32 Bit Server OS to
> Firebird 2.5. Is there a 64 Bit OS recommend and a 64 Bit installation
> of Firebird too?

From an operational POV, a main factor with moving from 32-bit to 64-bit is
if you are using (third-party) UDF libraries. You need them to be compiled
with a 64-bit compiler if you want to run Firebird 64-bit.

Other than that, I guess it depends on your planned load, especially
addressable RAM by the Firebird server process. If still intend to run with
ClassicServer, then each connection spawns its own process, thus you
probably won't hit the addressable RAM limit with Firebird 32-bit.
That might be different with Firebird SuperClassic (32-bit), because this is
a single process architecture.

I connect with odbc. Known Issues while migration,
> metadata etc. ?

The usual path is creating a gbak-based backup with Firebird 2.1 and restore
it under Firebird 2.5. The resulting ODS will be 11.2 (you can check with
gstat -h afterwards).

On the client side, make sure that you are using a version of the Firebird
client library matching the server version. Bitness (32-bit vs.
64-bit) of the client library is driven by your application and not by the
Firebird server. So, if you are application is 32-bit (Delphi
32-bit?) use a Firebird 32-bit client library and ODBC driver.

Hope this helps.

With regards,
Thomas Steinmaurer

Professional Tools and Services for Firebird FB TraceManager, IB LogManager,
Database Health Check, Tuning etc.




Visit 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


Yahoo Groups Links