Re: ASP/OraOLEDB performance

I don't know what "host variables" are, so I guess I'm not using them :-) In this case, I have no option but to put the object in an MTS package as I need access to the ASP context. However, no transactions are specified for the object so there should be no overhead there. I can't use a dedicated server connection the object is being used in an ASP page, and is therefore destroyed at the end of the page.

My thought was that OLEDB connection pooling was supposed to take care of this. Like I said, it works well enough within SQL server.

I've also tried just a plain ASP page that creates OraOLEDB, opens a DB, runs a select* command against a table with 5 rows; looks only at the first row, and uses a server side, read-only recordset. Again, performance here is terrible (10 pages/s). If I write the same code using the OCI, then I get much more like 200 pages/s.

Mark

"Jim Kennedy" <kennedy-family_at_home.com> wrote in message news:bFyB7.45366$Zb.22542367_at_news1.sttln1.wa.home.com...
> Are you using host variables? (probably not).
> Do you maintain the connection or do you open it up each time you do a
> query?
> Try not using MTS and use a dedicated server connection.
> Jim
> "Mark Weaver" <mark_at_npsl.co.uk> wrote in message
> news:c0oB7.58471$uh1.6356785_at_news6-win.server.ntlworld.com...
> > Thus far, I have got terrible performance out of Oracle. Using Oracle
> > 8.1.7.5, plus OraOLEDB 8.1.7.2. I can't find any later 8.1.7 patches -
> > please let me know if I'm missing something.
> >
> > The scenario is:
> >
> > COM object implemented in VB+ADO+OraOLEDB for storing session data.
> > ASP page requested retrieves a BLOB containing the session data (via ADO
> > with server side recordsets) and reads this into a dictionary.
> > BLOB is typically 4K.
> >
> > Connecting to a fairly well spec'd DB (7x10,000 RPM SCSI disks with
> > index/data/logs/os/redo spread about, dual PIII-800Mhz CPUs, 1GB) from
> > a-hopefully-up-to-the job webserver (2xPII 450Mhz CPUs, 1GB) which
doesn't
> > seem too stressed, then I get massive memory usage (~100Mb) with only
> about
> > 12 pages/second. Now with the same running under SQL server I get much
> > better than this, so I assume that I'm missing something. Oracle is
> running
> > in MTS mode to support the apparently very large number of connections
> > created by the webserver (typically around 500). For comparison
purposes,
> I
> > have a C/OCI app running in the webserver that uses persistent
> connections,
> > applies DB based security to every request received and gets around 200
> > pages/second - nearly 20x the performance).
> >
> > Now my questions are:
> >
> > 1) Why are there so many connections?
> > 2) Why is the performance so poor?
> > 3) What can I do to improve on this?
> >
> > Thanks,
> >
> > Mark
> >
> >
>
>
Received on Sat Oct 27 2001 - 07:32:12 CDT