I have a "Select" SQL statement.
It will take a long time. (more than 3 minutes)
When I execute it on pgAdmin III, it won't consumes a lot of memory.
But "dotConnect for PostgreSQL Express 7.18.1730" will.
(I use the sample code of "dotConnect for PostgreSQL - DataReader".)
The same problem happened to "dotConnect for Oracle Standard 9.13.1098".
Best Regards,
Tachiro
Consumes a lot of memory when execute Select SQL which takes a long time
Consumes a lot of memory when execute Select SQL which takes a long time
Last edited by Tachiro on Thu 12 Nov 2020 11:38, edited 2 times in total.
Re: Consumes a lot of memory when execute Select SQL which takes a long time
pgAdmin III may fetch data on a per-page basis while dotConnect for PostgreSQL retrieves the full result set.
You can set PgSqlCommand.FetchAll=false and control a number of rows that will be transferred across the network at a time via PgSqlCommand.FetchSize. Refer to https://www.devart.com/dotconnect/postg ... mbers.html.
You can set PgSqlCommand.FetchAll=false and control a number of rows that will be transferred across the network at a time via PgSqlCommand.FetchSize. Refer to https://www.devart.com/dotconnect/postg ... mbers.html.