Windows 32bit Server Large Address Aware

[Ertan Küçükoglu]

Hello,

I got a problem with 32bit server RAM limits recently. It can be argued to change config settings. It is not always an option to switch using a 64 bit server.

I wonder if there are any limiting reasons not to activate the subject option? If nothing, I would kindly vote for enabling it.

Thanks & Regards,

Ertan

[Paul Reeves]

I recall that we looked into this a long time ago but I can't find any
trace of the discussion. AFAICT no official releases have ever been built
with /LARGEADDRESSAWARE passed to the linker. You could try it. I believe it
works. However, at most, it will only buy you time. It allows firebird to use
an extra gigabyte of memory.

64-bit processors have been widely available since 2005 and the first 64-bit
versions of Firebird became available in 2007. Power users quickly switched to
64-bit and since then talk of the 32-bit memory limit has largely disappeared.

If you have firebird running on 32-bit physical hosts that are hitting
the 2GB RAM limit the only realistic solution is to switch to a 64-bit CPU.
The business case seems clear cut to me. Other than the financial aspect,
what are the other obstacles to you moving these users to 64-bit hosts?


Paul
--

Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird

[Ertan Küçükoglu]

Hi,

Thank you for your email.

We install the FirebirdSQL server ourselves (custom TCP port and custom windows service name) but using released versions only. I do not know how to build FirebirdSQL from sources. There are still 32bit OS users for us and so we cannot just switch to the 64bit version even if we want to do that very much. It is not our financial aspect but users are sticking to their existing systems. We cannot just say "You should switch to the 64bit version of Windows or you cannot use our software".

It is not only a 32bit physical hardware problem. Some systems have 64bit physical hardware and a 32bit OS installed on it with all other software that users need. They do not want to switch 64bit versions because of the downtime needed.

After reading your reply, I just could not be sure if adding /LARGEADDRESSAWARE parameter helps even on a 32bit OS to have an extra gigabyte of memory. I agree it is not much, but still an additional 1GB.

Regards,

Ertan

'Paul Reeves' via firebird-devel <firebir...@googlegroups.com>, 23 Eki 2023 Pzt, 14:12 tarihinde şunu yazdı:

--
You received this message because you are subscribed to the Google Groups "firebird-devel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-deve...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/firebird-devel/20231023131239.59b7a44f%40coutances.fleetriver.com.

[Dimitry Sibiryakov]

Ertan Küçükoglu wrote 23.10.2023 15:31:
> It is not only a 32bit physical hardware problem. Some systems have 64bit
> physical hardware and a 32bit OS installed on it with all other software that
> users need. They do not want to switch 64bit versions because of the downtime
> needed.

Are you aware that bitness of Firebird server can be different from bitness
of Firebird client and user application?

--
WBR, SD.

[Vlad Khorsun]

23.10.2023 16:31, Ertan Küçükoglu:

> Hi,
>
> Thank you for your email.
>
> We install the FirebirdSQL server ourselves (custom TCP port and custom windows service name) but using released versions only. I do
> not know how to build FirebirdSQL from sources. There are still 32bit OS users for us and so we cannot just switch to the 64bit
> version even if we want to do that very much. It is not our financial aspect but users are sticking to their existing systems. We
> cannot just say "You should switch to the 64bit version of Windows or you cannot use our software".
>
> It is not only a 32bit physical hardware problem. Some systems have 64bit physical hardware and a 32bit OS installed on it with all
> other software that users need. They do not want to switch 64bit versions because of the downtime needed.
>
> After reading your reply, I just could not be sure if adding /LARGEADDRESSAWARE parameter helps even on a 32bit OS to have an extra
> gigabyte of memory. I agree it is not much, but still an additional 1GB.

You may make any existing binary "Large address aware" - it is about change 1 bit in
the exe header. It could be done using editbin tool:

https://learn.microsoft.com/en-us/cpp/build/reference/largeaddressaware

If you decide to go this way, you should understand that Firebird never tested for
large address awareness, and you do it on you own risk.

Regards,
Vlad

[Ertan Küçükoglu]

Hi,

Yes, I am aware of that. Our case, FirebirdSQL runs on the same system as our software. It is installed as a service just because we also have our own services and a GUI interface.

Thanks & Regards,

Ertan

'Dimitry Sibiryakov' via firebird-devel <firebir...@googlegroups.com>, 23 Eki 2023 Pzt, 16:49 tarihinde şunu yazdı:

--
You received this message because you are subscribed to the Google Groups "firebird-devel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-deve...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/firebird-devel/036e4e82-3114-4e4c-af1d-1b458037d7d7%40ibphoenix.com.

[Ertan Küçükoglu]

Hi,

I didn't know that. I will check it out. Thank you.

Regards,

Ertan

Vlad Khorsun <fbv...@gmail.com>, 23 Eki 2023 Pzt, 17:03 tarihinde şunu yazdı:

--
You received this message because you are subscribed to the Google Groups "firebird-devel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-deve...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/firebird-devel/74c04996-8dc6-46a6-90f6-41281b919fe0%40gmail.com.