Toad World® Forums

Performance of "Create insert statements for selected rows"

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.

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.

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.

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