about data streaming performance about simple-oracledb HOT 7 CLOSED

too bad.
i wrote down an item for myself to check and see if i can do something about the performance, because I believe there is some solution there.

from simple-oracledb.

Ya the performance should be not as good since i have to use getRow one at a time. However not sure about your numbers, will run some tests as well when i have time.
The stream is meant to save on memory, not time. So the decision on what to use is case by case basis.

from simple-oracledb.

by the way if you don't have LOBs in your query, check the connection.queryStream in the original oracledb library.
I wrote it as well, but there I don't convert LOBs to string/buffer so it should be a bit faster and give you same functionality.

from simple-oracledb.

@sagiegurari thank to your notation
no i have not any LOBs type column
is that you mean time mybe decrease and stream be faster than non stream query ?

from simple-oracledb.

if no LOBs, try using connection.queryStream and see if it improves your overall performance instead of connection.query.

from simple-oracledb.

@sagiegurari ok i check it

from simple-oracledb.

no sensible effect :)
thank you

from simple-oracledb.