How do I increase number of rows returned per network roundtrip (PrefetchCount)?

[ephraimkwon]

I have been trying to use this driver to work with a database with a large query that pulls a lot of records (~600k). However, the program I wrote is very slow and I believe it is because I cannot stream records fast enough.

I attempted to adjust the count by setting "PrefetchCount" in the urlOptions but that did not work. Can someone let me know if there another method I could use to configure the driver to increase the fetch size for each database retrieval? From what I understand, I believe the default is around 100 rows per retrieval but I would like to have the option to increase this to around 1000 or more.

UPDATE: I was able to configure the prefetch count by putting "PREFETCH_COUNT" in all caps in the urlOptions and setting that to "1000". I had to scour the source code and found that this option was case sensitive (all caps).