Subject Superserver vs. Classic vs. NT vs. Linux on SMP
Author Sean Stromberg
We have been long time users of InterBase on the NT platform and up
until recently very pleased. Unfortunately, now we run up against some
poor design in the Superserver architecture on Windows NT which sounds
as if it spans other OSs as well. All of our clients are now running IB
5.6 on their servers, which the majority are dual (because IB 4.2 scaled
much better over these), and now run up against queries that will
completely lock the server until they complete or will cause processor
ping-pong. Both completely undesirable features.

With this is mind we are now forced to explore other platforms (support
nightmare), thus this brings me to my question. Is there a version of
IB 5.6 for Linux? If so how does it do on multi-processor systems?

Next, we are looking at offering an ASP (application service provider)
solution of or product. As it sits right now, there is no way that we
could cost effectively provide this as InterBase will not run
effectively on a multi-processor system. Has anyone actually ran in a
production environment using Linux with multiple databases on a
multi-processing machine? I am not looking for theoretically 'it will
work', I need hard facts.

In no way do I want to jump off of InterBase. I love the product and
enjoy the community. But if we can't scale with our clients, we lose
business. If we lose business, then we have to look at something else.

Any comments are appreciated.

Sean Stromberg
The HOEHNE Group
Director of Development
Email: sean@...