Re: Performace problem after upgraded from 8.0.5 to 8.1.7

I hv 4 tables (created by the vendor) that returns estimated 170,000 rows.

Table A

a.parentproductid,
d.description,
a.description,
a.makerid,
a.unit,
b.addr,
c.description

It used to be 40sec to return all sets in Oracle 8.0.5 but after upgraded it took 1min 15 sec to complete. We used PowerBuilder 7 Native Driver as ODBC are even slower.

Thanks

Sam

"Jon Armstrong" <jma00002_at_rochester.rr.com> wrote in message news:<3Cro8.27847$8%1.10716797_at_typhoon.nyroc.rr.com>...
> Sam,
>
> Details of the query in question and DDL (schema description)
> would be helpful, along with some indication of the volume of
> data involved.
>
> Regards... Jon
>
> Jon Armstrong (Java, C, C++, Oracle, MySQL and much more)
> [ 24/7 Solutions - Any problem, on any platform, any time. ]
>
> "Sam" <hinfun_at_hotmail.com> wrote in message
> news:e53193a9.0203270529.ccce008_at_posting.google.com...
> > I have a performance problem that used to be 40 sec now comes to 90
> > sec after upgraded to 8i. Generally i have 1 table that outer join to
> > other four tables that is giving the performance penalty and i have
> > noded that transferring of rows from server to client is slower on
> > 8.1.7
> >
> > The hardware platforms is the same except I hv allocated lots of
> > memory to 8i and still plenty for the OS (NT 4 SP6).
> >
> > Is there any tricks in tunning up the server ?
> >
> > Thanks
> >
> > Sam
Received on Thu Mar 28 2002 - 05:00:02 CET