Devart Forums

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

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.