|Subject||Re: [firebird-support] Re: Server specs|
On Thu, Jun 27, 2013 at 8:45 AM, mbabuskov <milanb@...> wrote:
> Mags Phangisa wrote:
> > One of my clients has about 6000 locations but between 1000 and 1500 will
> > be connecting at the same time at any given stage. Most transactions will
> > be selects for reports on a daily basis and inserts (with file
> > will only be happening at month ends for progress updates.
> > Please advise me on specifications for a server that can handle this.
> It's impossible to recommend anything without knowing the SQL statements
> you would run, their frequency and number of rows in tables and indexes on
> Without that information, one can only say "the more CPU, RAM and faster
> HDD, the better". Or "spend as much as you possibly can, extra power never
> hurt anyone".
> One thing I will recommend though. If database size is larger than RAM,
> get at least a SAS disk. It improves performance drastically.
> Milan Babuskov
> The easiest way to import XML, CSV
> and textual files into Firebird:
[Non-text portions of this message have been removed]