Performance of "Create insert statements for selected rows"

Toad for Oracle - Beta
1

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.

2

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.

image
image430×698 16.5 KB

3

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.

2020-11-02_TOAD_Export_as_insert
2020-11-02_TOAD_Export_as_insert631×509 317 KB

4

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