Thanks for your answers Martijn! A few more questions:

What do you mean by "any modern machine should do"? Modern machines range from $250 to the sky. Could you point me to a typical configuration?

Apart from having the most important fields indexed properly, what's the sinlge most important thing for making sure that my queries will perform well?

What bad experience do you have with using WLAN and FB together?

Thanks:
Zd

----- Original Message -----
From: Martijn Tonies
To: firebird-support@yahoogroups.com
Sent: Wednesday, September 05, 2007 6:02 PM
Subject: Re: [firebird-support] What hardware will I need for my DB?


Hi,

> This is the first time that I use Firebird for a commercial software that
will be sold to various offices employing 3 to 20 people.
>
> Since I have no exprience in what hardware I should use for my DB, I'd
like to ask for your advice.
>
> The program I've developped is largely DB oriented - there are thin
clients and a thick DB layer - almost everything is done by the DB, the
clients are solely for displaying and manipulating data.
>
> Mostly general textual records (contact info, calendar data etc.) and .DOC
format MS Word documents are stored in the DB. The .DOC documents are very
small, less than 30k on average.
>
> Thus the overall size growth of the database isn't expected to exceed 1 GB
/ year.
>
> Now the question is, what kind of server-hardware will I need to serve:
> a, 3 to 5
> b, 5 to 15
> c, 15 to 25
> concurrent clients properly?

Any modern machine should do, although it would depend on the
work you're doing. Make sure you're queries perform well and
are solid with regard to index usage and so on.

> Please note that since we are talking about smaller companies here, the
price of the server is a huge issue.
>
> There should be a fair comprise between data-security, performance and the
cost.

Do use an "ups" to make sure a power outtage doesn't trash your data.

> And finally, there is one more issue: the Network.
>
> I suppose for a smaller office (max. 8 people) a WLAN connection could be
used. Has anyone tried this? Is Firebird reliable on a wireless network?

Dump the WLAN, they're shite.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com





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