Simulated test of 100 clients on 10 workstations with a 80GB Database
running on a Dual Xeon Box with RAID5 and plenty of harddisks and Win2k/FB
0.94 (its some months ago).

Response time for queries was typically under 1 second (even for joins)
provided the plans were ok and the result-sets not too large.
OLTP was not significantly slower than MSSQL on the same box and was
drastically faster for less connections (5 users).

100+ users on IB/FB will give you quite some headaches if you don't design
the app/db well.
Take care of the MGA and a non advancing OAT. Keep transactions short and
have the OAT advancing and FB will run smoothly even under heavy load.

Nick Josipovic

CRM Administration
BIT-Institute
Prof. Dr. Franz Steffens
Schloss
68163 Mannheim
Germany
Phone: ++49 621 181-1621
Fax: ++49 621 181-1618
mailto:nick.josipovic@...

> -----Original Message-----
> From: Duleep [mailto:geocalicut@...]
> Sent: Monday, December 24, 2001 3:56 PM
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] Porting
>
>
> Thanks for the advice mate.
>
> Anyone here who handles over 200 clients with 4 GB plus data on a
> non web environment ?
>
> regards
> Duleep
> ----- Original Message -----
> From: Artur Anjos
> To: ib-support@yahoogroups.com
> Sent: Monday, December 24, 2001 8:29 PM
> Subject: Re: [ib-support] Porting
>
>
>
> Merry Xmas. And an Happy New Year!
>
> You may want to fill in a new line in your '2002 - Thinks I
> will Do' List:
>
> - Be more carefull when choosing Sales Partners
>
> Artur Anjos
>
> ----- Original Message -----
> From: "Duleep" <geocalicut@...>
> Subject: [ib-support] Porting
>
>
> > Hi everyone.
> >
> > Merry Xmas.
> >
> > I am being asked by one of our sales partners to port an existing FB
> application to sql-2000, as he claims that fb is 'unknown' and
> not scalable
> (250+ workstations). Can someone comment on this ?
> >
> > regards
> > Duleep
> >
>
>
>
> Yahoo! Groups Sponsor
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
> ----------
>
> ****** Message from InterScan E-Mail VirusWall NT ******
>
> ** No virus found in attached file noname.htm
> ** No virus found in attached file noname.htm
>
> This is a virus free message scanned by Zyberway
> ***************** End of message ***************
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>