Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
April 13–15 - Dare to Unleash a New Professional You at Qlik Connect 2026: Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Cursor size in TOracleInput

Hi All ,
What is standard size for cursor size in to
toracleInput ? what happens if we keep it as maximum and by keeping it as minimum?
Labels (2)
1 Reply
Anonymous
Not applicable
Author

This attribute name is a bit misleading. Actually it means the fetch size for the result set. The fetch size describes how much datasets will be read at once. The default value differs a bit and is mostly 64 or 100.
In case of reading a lot of datasets it is recommended to use a fetch size about 10000.
There is a individual maximum which value increase the performance. Please keep in mind all datasets inside the fetch size window will be kept in memory.