Devart Forums

I noticed that ScrollableCursor is slow.
I want export over 3 billions records from table in CSV.
Oracle sql developer exported it at 1 hour, TOraQuery with ScrollableCursor=True as tortoise.
I have tried to adjust FetchRows parameter.
Problem in implementation ScrollableCursor or setup TOraQuery?

Hello,

You can use the UniDirectional property instead of ScrollableCursor and choose an optimal value for FetchRows for maximum performance. In addition, if a grid is connected to DataSet, the DisableControls method should be called before starting export

Thank you, it's great working!

Hello,

Glad to see that the problem was solved. If you have any other questions, feel free to contact us.