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
> attachments)
> > 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
> them.
>
> 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.
>
> Regards,
>
> --
> Milan Babuskov
>
> ==================================
> The easiest way to import XML, CSV
> and textual files into Firebird:
> http://www.guacosoft.com/xmlwizard
> ==================================
>
>
>


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