Re: questions on scalability

From: Bob Jones <email_at_me.not>
Date: Sat, 22 Apr 2006 00:23:42 GMT
Message-ID: <iIe2g.50859$_S7.4270@newssvr14.news.prodigy.com>

"NetComrade" <netcomradeNSPAM_at_bookexchange.net> wrote in message news:d7uh42hf7gqtieisp5hdhc6dnk4h1t4c1s_at_4ax.com...
> On Fri, 14 Apr 2006 08:00:18 +0200, Magnus Warker <magnus_at_warker.co>
> wrote:
>
>>2) Scaling up
>>
>>How can we ensure that the hardware equipment is always capable to meet
>>the
>>requirements? How should we upgrade the hardware? And the most important
>>thing: What can we do when the PP 250 machine is at its maximum upgradable
>>limit?
>
> If your application is not total crap (you have proper schema design,
> you have proper indices, you have tuned sql, you use bind variables,
> most of your SQL doesn't do more than 500 logical reads, you do as
> much with 1 SQL statement as possible), and you're building an OLTP
> type of an application with scalability in mind (read Tom Kyte's
> books), 2-4 CPU machines should be able to handle thousands to
> hundreds thousands of users concurrently.
>

Well said, but some OLTP apps are very compute intensive. Without enough info, I am only willing to bet a cheap watch on the 2-4 CPU estimate. Received on Fri Apr 21 2006 - 19:23:42 CDT