Export tables SLOW? - Allround Automations forums

Hi,

I don't know if this is happening only to me but it seems like export table (SQL Inserts) is VERY SLOW.

For example a 60k rows are exported in 20 minutes. The table has only 35 columns with no LOBs/CLOBs. A complete select/"parse" in the grid takes about 30sec.

Is there something I can check? Does anyone else has the same problem?

Thanks and Regards!

To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer 12\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the %APPDATA%\PLSQL Developer 12 directory (e.g. C:\Users\<User>\AppData\Roaming\PLSQL Developer 12).

Hi Marco,

in the debug file during the export I can see

Code

00:00:20.269 TOracleQuery $0AA29A80 Start Query.Next for up to 100 records
00:00:20.272 TOracleQuery $0AA29A80 End  (100 records processed)
             Duration = 0
00:00:22.839 TOracleQuery $0AA29A80 Start Query.Next for up to 100 records
00:00:22.842 TOracleQuery $0AA29A80 End  (100 records processed)
             Duration = 0
00:00:25.411 TOracleQuery $0AA29A80 Start Query.Next for up to 100 records
00:00:25.413 TOracleQuery $0AA29A80 End  (100 records processed)
             Duration = 0
00:00:27.943 TOracleQuery $0AA29A80 Start Query.Next for up to 100 records
00:00:27.945 TOracleQuery $0AA29A80 End  (100 records processed)
             Duration = 0


.................................................................................

             Duration = 0
00:22:44.892 TOracleQuery $0AA29A80 Start Query.Next for up to 100 records
00:22:44.898 TOracleQuery $0AA29A80 End  (100 records processed)
             Duration = 0
00:22:47.023 TOracleQuery $0AA29A80 Start Query.Next for up to 100 records
00:22:47.026 TOracleQuery $0AA29A80 End  (100 records processed)
             Duration = 0
00:22:49.144 TOracleQuery $0AA29A80 Start Query.Next for up to 100 records
00:22:49.147 TOracleQuery $0AA29A80 End  (100 records processed)
             Duration = 0
00:22:51.273 TOracleQuery $0AA29A80 Start Query.Next for up to 100 records
00:22:51.275 TOracleQuery $0AA29A80 End  (100 records processed)
             Duration = 0
00:22:53.394 TOracleQuery $0AA29A80 Start Query.Next for up to 100 records
00:22:53.396 TOracleQuery $0AA29A80 End  (100 records processed)
             Duration = 0
00:22:55.508 TOracleQuery $0AA29A80 Start Query.Next for up to 100 records
00:22:55.510 TOracleQuery $0AA29A80 End  (66 records processed)

Changing the "Commit every" (to 1000) does not change the "(100 records processed)". Seems like the fetch is ok but the conversion the data to sql is very slow.

P.S. the computer where I'm executing the export is an I7-4790 CPU with 16GB of RAM (it's a decent computer

)

Regards!

Hi,

As I had some time today, I installed an older version of PLSQLDev (11.0.6) and I tried the export. It is 10x faster (same table, same database, same computer).

Code

00:00:05.801 TOracleQuery $0C042FC0 End  (100 records processed)
             Duration = 2.032
00:00:05.803 TOracleQuery $0C042FC0 Start Query.Next for up to 100 records
00:00:05.805 TOracleQuery $0C042FC0 End  (100 records processed)
             Duration = 0
00:00:05.806 TOracleQuery $0C042FC0 Start Query.Next for up to 100 records
00:00:05.807 TOracleQuery $0C042FC0 End  (100 records processed)
             Duration = 0
00:00:05.808 TOracleQuery $0C042FC0 Start Query.Next for up to 100 records
00:00:05.809 TOracleQuery $0C042FC0 End  (100 records processed)
             Duration = 0
00:00:05.811 TOracleQuery $0C042FC0 Start Query.Next for up to 100 records
00:00:05.812 TOracleQuery $0C042FC0 End  (100 records processed)
             Duration = 0

.......................................

00:02:07.499 TOracleQuery $0C043C20 Start Query.Next for up to 100 records
00:02:07.500 TOracleQuery $0C043C20 End  (100 records processed)
             Duration = 0
00:02:07.675 TOracleQuery $0C043C20 Start Query.Next for up to 100 records
00:02:07.677 TOracleQuery $0C043C20 End  (100 records processed)
             Duration = 0
00:02:07.849 TOracleQuery $0C043C20 Start Query.Next for up to 100 records
00:02:07.850 TOracleQuery $0C043C20 End  (100 records processed)
             Duration = 0
00:02:08.023 TOracleQuery $0C043C20 Start Query.Next for up to 100 records
00:02:08.025 TOracleQuery $0C043C20 End  (100 records processed)
             Duration = 0
00:02:08.199 TOracleQuery $0C043C20 Start Query.Next for up to 100 records
00:02:08.201 TOracleQuery $0C043C20 End  (100 records processed)
             Duration = 0
00:02:08.348 TOracleQuery $0C043C20 Start Query.Next for up to 100 records
00:02:08.350 TOracleQuery $0C043C20 End  (66 records processed)
             Duration = 0
00:02:08.444 TOracleQuery Query Start Query.Execute

Did you tried the "Table export" with the latest version. Is the export ok on your side?

Regards!