thisllub wrote:

> #1 SUSE 10.2 has a problem with some or all multi core cpus.
> #2 Firebird on some or all dual core machines is unstable.
> #3 Firebird on SUSE 10.2 on some or all dual core machines is unstable.

Let's not call it unstable, but that there are issues.

> 20GB database, 50 Windows - odbc users ~ 250000 transactions a day.
> 2 intranet & 2 internet servers running about 100000 transactions a day.
>
> If so what distribution , kernel & version of Firebird are you using?

Currently, the only safe bet for everything to run smoothly in such
environment is to use some recent 2.4 kernel with SMP support and
Firebird 2.x Classic. And you you go down that route, make sure you
don't run ReiserFS (it has some issues which are fixed in kernel 2.6.7
and above).

If you can't use 2.4 kernel, you might try your luck with Firebird
SuperServer - there were reports of it working fine on some SMP
configurations.

--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com