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.