Subject Re: [firebird-support] Is there any benefit when using Firebird Classic in 64bit version?
Author Thomas Steinmaurer
> Hi guys,
> I just wanted to ask about that. Because every firebird process on my
> machine is taking about 8-20 MB RAM. The obvious reason to use 64 bit
> application is its ability to address more RAM. Since fb_inet_server is
> taking so little memory is there any point in installing 64 bit Firebird
> in Classic mode?

I guess you are running with the default 75 page buffers, as well with
low in-memory sort settings etc. A great playground for Firebird
consulting services. ;-)

IMHO it doesn't matter whether you are using 32-bit or 64-bit Firebird
in Classic mode. In SuperClassic (SC), using the single-process
approach, it does and 64-bit makes more sense with SC. For SuperServer
as well, but I wouldn't recommend using SS in production (SMP environments).

But when you are using third-party UDF libraries, they usually add a
dependency on the bitness for the Firebird server anyway. I have seen
customers using their home-grown UDF library built with Delphi, thus
32-bit in the old days, which results in using Firebird 32-bit as well.

You can't use Firebird 64-bit when you are using a 32-bit UDF library
and don't have a 64-bit version of the UDF library available. But I
guess, you know that.

With regards,
Thomas Steinmaurer

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