Subject Re: Best Firebird Platform for our Environment
Author ssilouky
Thanks for the information. In regards to the Windows 2003 Server running RDP, it is running Firebird Superserver 2.1.3 32-bit. What I have noticed is it only uses 1 CPU and it is running at 60-100% utilization. In regards to the dbase Plus programs, there are some dbase files used in conjunction with the firebird files. We have experimented with a Windows 2008 Server, 64-bit with 8gb RAM, dual E5430 XEON processors and Firebird 2.5.2 64bit. Firebird utilized the multiple CPUs and the Utilization never went above 19%, but the performance was worse. We also encountered frequent not-responding messages during program execution. The screen goes white. There is no certain pattern to the not responding messages and in some cases the program ends normally, but in a few cases, the program ends without completing. If you run the same programs from a workstation with firebird 2.5.2 client-only install, they run properly, but run much slower. The test workstation is an Intel I5-661 with 4gb of memory and Windows 7 32-bit.

--- In firebird-support@yahoogroups.com, André Knappstein <Knappstein@...> wrote:
>
> If you have enough know-how to manage all the basic linux stuff, then
> go with a linux system. If you don't then better use windows.
>
> But something else needs your attention (or mine *g*).
> Are you using StoredProc objects in dBPlus 2.6 to deal with stored
> procedures in Firebird?
> If so you should be warned, there is an undocumented bug in dBase
> that - only on XEON systems - leads to exceptions in the dBase
> StoredProc object. The bug persists in the freshly released dBase plus
> 8.
>
> If your application experience is fine with RDP sessions, then keep
> it. Never change something you are satisfied with!
> If you will go real client/server, you might get a huge improvement,
> because a lot of workload is transmitted to the quite
> potential workstations. Depending on how complex your GUI stuff is,
> this can render a huge performance gain for the server, which in turn
> can much better use the power for the database stuff.
> But if your implementation is not too clean, you also might
> experience the opposite!
> 2.6.2 still is firmly tied to the BDE, which means you need a special
> approach to use dBase as front end for *any* SQL server backend.
>
> So far you only needed changes in pixels to go over the wire.
> Full client/server would also mean that the data you operate on will
> have to go over the wire.
> You better make sure that data is as small as you really need.
>
> Typical dbase/BDE behaviour is: create many many many indexes with the
> poorest of selectivity *and* doing a full table select as often as
> possible. This will break your neck in client/server.
>
>
>
> > We are trying to determine the best platform for Firebird SQL
> > 2.5.2. Our firebird databases are 40-60gb in size and are being
> > accessed by dbase plus 2.6.2 programs. Currently we are running on
> > Windows 2003 Server with dual Intel XEON E5430 quad-core processors
> > and 8gb RAM. This server is being accessed with Windows Remote
> > Desktop. We are in the process of replacing this server with a new
> > server using 2 Intel XEON E5-2640 processors and 16gb of RAM. We are
> > trying to determine whether we should go with Windows or Linux. We
> > also want to consider client/server versus the current model we are
> > using. We would use Intel I7-3770K processors with 8gb of ram for workstations.
>
>
>
> > ------------------------------------
>
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> > Visit http://www.firebirdsql.org and click the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
>
> > Also search the knowledgebases at http://www.ibphoenix.com
>
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > Yahoo! Groups Links
>
>
>
>
>
> mit freundlichen Grüßen,
>
> André Knappstein
> EDV und Controlling
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
> Hafenweg 4
> 59192 Bergkamen-Rünthe
>
> Telefon: +49 2389 9240 140
> Telefax: +49 2389 9240 150
> e-mail: knappstein@...
>
> Amtsgericht Hamm Nr. B 420
> Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus
>
> USt-IDNr.: DE 125215402
>