Performance of "Create insert statements for selected rows"

[PeterLang]

It takes longer than expected to display the Data Export dialog, freezes sometimes while preparing it and cannot be cancelled.

Steps to reproduce:

1. CREATE TABLE toad_test AS
   ( SELECT ROWNUM AS r FROM dual CONNECT BY ROWNUM <= 2000 );

2. Show Data in describe window.

3. Select all rows and "Create insert statements for selected rows".
   This takes about ten seconds for me.

When I close the Describe dialog and repeat steps 2 and 3 it happens sometimes that updating the scrollbar stops after some seconds and/or that die Data Export dialog is displayed behind the Describe window.

[JohnDorlon]

I can't think of any reason why the export would get 'stuck' or die.

Is this option checked? If so, uncheck it. It will go faster with this box unchecked.

[PeterLang]

Don't see much difference there - also, since this is a different dialog, how are they related?

Here is what it looks like, freezing and opening behind describe window. Dialog is only visible because I made the describe window so small, otherwise it becomes tricky because it opens in a modal state, but still behind the describe window.

[JohnDorlon]

Oops, you're right, it's a different dialog. They share code behind the scenes. (The code that actually creates the insert statements).

I do see some slowness as the window is opening and will investigate. I think I know what that is.

For me, the 'create as insert' dialog comes up on top of describe, but I will check on the z-order problem as well.

Update: I have found the problem and will have it fixed soon. Maybe not next beta, but soon.

Workaround: If you want to export all rows to inserts, make sure that no rows (not even 1) is selected in the grid. Then the dialog will come up fast.

-John