Hi,
I have an application which dials a modem, and connects to Postgres using
ODBC. When I call the SQLExecDirect function to get the (quite large: 10000
rows) result set, it takes a long time to execute. The query itself is
indexed and runs very quickly from psql. I presume the delay is because the
ODBC is downloading all the rows. Is there any way to either:
1) Use compression on the recordset to make the call faster?
2) Download each row one at a time, when SQLFetch is called?
Also I don't seem to be able to find an ODBC function to return the number
of records in a results set. Is there one?
TIA,
Mark.