Subject Re: [firebird-support] Best Server hardware to Firebird
Author Dalton Calford
Hi Rodrigo;

Is the XP box being used for any other functions? ie, is it also a
workstation or is it a dedicated server?

What type of hard disk /hard disk controller do you use?

What is your setting for virtual memory?

What is your setting for Windows memory cache?

How much RAM do you have?

What page size are you using for your database?

What filing system are you using on your drive?

What block size are you using on your filing system?

What is your buffers setting?

What type of processor/number of processors do you have?

You would be surprised how much of a performance improvement you can
have with just a few changes to the settings of your software when you
know exactly the hardware specifications.

best regards


On Thu, 2008-12-11 at 09:34 -0300, Rodrigo Aparecido Cardoso wrote:

> "First, please don't hijack other threads (you posted a reply to 'Flame
> Robin versus IB Expert' and only changed the subject)."
> R: Sorry, I don't know that it cause problems, it won't happen again.
> "Please tell us more about how your customer uses Firebird. 40 users
> adding one record each every hour to one table is nothing, 40 users
> constantly updating tables when using Firebird as the basis for a flight
> simulator is something quite different (I don't know if anyone uses
> Firebird this way, I just used it as an example since I expect it to be
> quite intensive)."
> R: We use Superserver version(running on Windows XP SP3). The customer
> is a store, like Wal Mart(not so big as) but with queryes running all
> day long. I forgot to say before, but, this server makes backups with
> gbak every hour in other hard disk, but when it happen, the system
> become slowly...
> What can we do with it?
> Thank you and sorry about my bad English...
> Rodrigo Cardoso
> Data System
> ------------------------------------
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Visit and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
> Also search the knowledgebases at
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links

[Non-text portions of this message have been removed]