Forums Active Threads
Print Thread
Export tables SLOW?
#57417 01/09/18 01:49 PM
Joined: Nov 2008
Posts: 14
F
fctb Offline OP
Member
OP Offline
fctb
Member
F
Joined: Nov 2008
Posts: 14
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!
Re: Export tables SLOW?
fctb #57422 01/10/18 09:53 AM
Joined: Aug 1999
Posts: 22,208
Marco Kalter Offline
Member
Offline
Marco Kalter
Member
Joined: Aug 1999
Posts: 22,208
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).

Marco Kalter
Allround Automations
Re: Export tables SLOW?
Marco Kalter #57442 01/18/18 11:37 AM
Joined: Nov 2008
Posts: 14
F
fctb Offline OP
Member
OP Offline
fctb
Member
F
Joined: Nov 2008
Posts: 14
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 wink )

Regards!

Last edited by fctb; 01/18/18 11:40 AM.
Re: Export tables SLOW?
fctb #57460 01/24/18 04:21 PM
Joined: Nov 2008
Posts: 14
F
fctb Offline OP
Member
OP Offline
fctb
Member
F
Joined: Nov 2008
Posts: 14
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!

Moderated by  support 

Link Copied to Clipboard
Privacy Policy · Forum Rules · Mark All Read Contact Us · Forum Help ·
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.037s Queries: 14 (0.012s) Memory: 2.5155 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-05-04 08:32:50 UTC
Valid HTML 5 and Valid CSS