ORDS : SQL Developer WEB : Worksheet performance display

User_K5NM0

Hi,

I noticed that the GRID display is very slow, as well as SCROLLING display ( up and down ) .

The Browser consumes about 500M for SDW and over 2G-3G to display over 1000 lines.

Have you an explanation ?

Best Regards

thatJeffSmith-Oracle

Check out browser developer tools, you'll see what's happening under the covers.

Also, not all queries/resultsets are equal. Your 1000 lines could say have 999 columns and 500 LOBs included for example.

User_K5NM0

My query is "select * from dba_tables"

thatJeffSmith-Oracle

And that's a lot of columns...don't use SELECT * when really only ever look at 5-7 columns vs 30 or more.

Rendering those grids isn't 'cheap' because of all the features users demand.

However.

We do know they are resource intensive, and are always looking to optimize them as much as possible.