Slowdown invoking Large Data Editor in v7.0.3

[Elwin Oost]

Hi,

After upgrading from .2 to .3, we experience a serious slowdown in opening the large data editor.

When clicking on the ellipsis button, Windows' csrss.exe gets active at a high CPU usage level for some seconds before the window is opened.

This wasn't the case in .2, and also happens for quite small objects such as varchar2(200). It's serious enough for us to consider downgrading.

Any idea why this happens? If so, are there workarounds?

Best wishes,

Elwin

 

[Marco Kalter]

I'm not sure what could cause this. What happens if you go to Tools > Preferences > Oracle / Options and disable the "Unicode enabled" option?

 

[johnsok]

We are experiencing this slowdown with .3 as well.

1. Highlight a table, right-click and choose Edit Data
2. Returns 26 rows, click on the ellipsis of any varchar column, it takes 13-15 seconds before the editor pops up allowing changes.
3. Subsequent clicks on other ellipsis is fine (not slow).

I didn't go as faw as the OP and look at processes, but this definitely occured on the 7.0.2 to 7.0.3 upgrade.

--Kate

 

[Elwin Oost]

I've tried disabling Unicode, but it unfortunately doesn't solve the problem.

For us, the problem remains persistently present on all subsequent clicks. I've timed it at about seven seconds for every opening of a field.

 

[dragonsoft]

I have the same experience.
It takes a long time to open the large data editor from an elipsis button in the grid.

Using Version 7.0.3.1123 (MBCS)
ODACHome1 (D:\oracle\product\10.2.0\client_1)
OraHome92 (D:\oracle\ora92)
Homes
ODACHome1 (D:\oracle\product\10.2.0\client_1)
OraHome92 (D:\oracle\ora92)
DLLs
D:\oracle\product\10.2.0\client_1\bin\oci.dll
Using
Home: ODACHome1
DLL: D:\oracle\product\10.2.0\client_1\bin\oci.dll
OCI: version 9.2
Oracle9i Enterprise Edition Release 9.2.0.7.0
Character size: 1 byte(s)

I have tried to use different homes and disabling Unicode but no cigar.

Pl/sql dev rules.
/Olof Lager

 

[rene.heusser]

I have the same problem after we have changed the network configuration 3 weeks ago. Before that the editor opened within seconds, now it lasts in average 30 seconds.
Checking on the network traffic we cannot see anything leaving my PC.