Re: Web Based applications

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3be800ba$0$8510$ed9e5944_at_reading.news.pipex.net...
> This is a general enquiry. I'd kinda like feedback from both DBA's and
> Developers.
>
> One of my responsibilities is to look after web sites running on IIS
> typically talking to Oracle using ADO/OLEDB. These sites get maybe 2500
> visitors a day ( say 50,000 get requests).
> My questions are
>
> 1. Do folk recommend OLDEB or do they use OO4O? What are the
> advantages/disadvantages of each.

OO4O if written properly is more scalable and will give you better performance. You can use host variables with it and that will give you a heck of a lot more performance and scalability.

> 2. Typically our developers have almost no error trapping in their .asp
> pages (both internally and externally developed). I view this as terrible
> coding. it does however seem to be almost standard in a web environment.
Is
> this me or is this in fact common.

Unfortunately it is all too common. That doesn't make it right.

> 3. What sort of hardware do folk use for a web server experiencing the
above
> sort of load?
> 4. Most code tends to sit in the asp page itself rather than in a
middleware
> layer written in (say) VB. MY understanding is that after a certain point
> this becomes unscalable. The question is is there a way to predict when we
> will reach this point.

> 5. How well if at all does Oracle interface with Microsft Transaction
> Server - this last is for a new project that we are assessing - my
concerns
> are about the oracle/MTS combination under intensive processing in a
> compressed timescale.
>
> So far my cynical impression of the web based revolution is that it
delivers
> poor quality, untested, unscalable code albeit in a quick timeframe.
Perhaps
> this is just me though?

Nope, you are just perceptive.

>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission Uk
>
>
>
>
Received on Tue Nov 06 2001 - 23:25:11 CST