ScrollableCursor is slow

[sinys]

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?

[AlexP]

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

[sinys]

Thank you, it's great working!

[AlexP]

Hello,

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