Re: Load Balancing and Scalability (ora7 or ora8)

If you have consistently and intelligently used triggers and stored procedures, then I would question your client's concern over the two-tier architecture. I typically think of this arrangement as being one flavor of multi-tier, since there are units of application logic executing on the server-side. SP's and triggers will always execute faster than doing the same application logic in the client side or in an external middle tier (unless the middle-tier is on a different server with a high-speed interconnect to the db server). Implementing business rules in triggers is by the far the easiest way to manage the business logic (that I'm aware of), if it provides logic that is complex enough to handle their real-life business rules.

As far as the insert intensity goes, inserts on a large table go at exactly the same speed as inserts on a small table, everything else held constant. The difference shows up in selects, updates, and deletes (since these are the operations that would use or not use indexes).

Hope this helps,
Dave

Tim Romano wrote in message <3523DD3A.E81585B7_at_superstream.net>...
>A potential client recently described as "unscalable"
>our two-tier architecture, in which business rules were
>implemented in Oracle via insert and update triggers.
>
>They expect a very large number of concurrent users
>(500-1000) in an insert-intensive operation, against
>large tables. Each insert-transaction will consist of a
>header record with hundreds of related detail records,
>with simple money-arithmetic calculations performed by
>stored procedures.
>
>What load-balancing options are there in Oracle? Can a
>single stored-procedure be somehow farmed out for
>execution by multiple compute engines, with which
>server does what based on a user or role? And is it
>possible to distribute a single table over multiple
>servers in Oracle 7 or 8, thereby distributing the disk
>i/o?
>
>TIA
>Tim
Received on Sun Apr 05 1998 - 00:00:00 CST