Re: bad performance

From: R.Schierbeek <bytelife_at_worldonline.nl>
Date: Wed, 14 Oct 1998 13:37:12 +0200
Message-ID: <7021fu$nht$1@news.worldonline.nl>

Hello Sbaiz,

Windows or WNT screen drawing can take a lot of time ! Hide your Sqlplus window fully or partially behind another window and check the speed.

Or try:
SQL>SELECT count(*)

    FROM "CUSTOMERS",

                 "ORGANIZATION_STRUCTURE_NODES"
    WHERE  ( "ORGANIZATION_STRUCTURE_NODES"."CUSTOMER_ID" =
                    "CUSTOMERS"."CUSTOMER_ID" )

    ORDER BY "CUSTOMERS"."CUSTOMER_ID" ASC ; Should be faster.

Also, working throug a telnet terminal emulator directly on the Unix box can speed up results.

Sbaiz heeft geschreven in bericht <01bdf68d$0f5aea40$b8cd5997_at_sbaiz>...
>I'm using Oracle 7.3 on Unix 4.0B platform with 512Mb RAM.
>
>The previous select works and display 6000 rows. But my problem is that
>Oracle display only 200 rows
>each time after it waits for 2 seconds and then display next 200 rows and
>so on. For this reason it takes
>a lot of time waiting for the displaying all rows (about 60 seconds)!
>
Received on Wed Oct 14 1998 - 06:37:12 CDT