| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Stephen Frost <sfrost(at)snowman(dot)net>, markw(at)mohawksoft(dot)com |
| Cc: | slutz(at)alacritude(dot)com, pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: FUD!! ODBC will not be supported by Microsoft in the future |
| Date: | 2003-10-01 12:41:46 |
| Message-ID: | 200310011341.46378.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
On Wednesday 01 October 2003 12:58, Stephen Frost wrote:
> * markw(at)mohawksoft(dot)com (markw(at)mohawksoft(dot)com) wrote:
>
> I tried using the postgres ODBC driver to open a table with a couple
> million rows. It ran the client machine out of memory. Same table w/
> the Oracle ODBC driver worked just fine.
This is probably less to do with ODBC and more with PG's approach to result
sets. With PG, if you ask for 10 million rows it will pass all of them to the
client in one go. Other systems tend to act as though you asked for a cursor
and return rows as you fetch them. In PG, if you want a cursor, you ask for a
cursor.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Harry Broomhall | 2003-10-01 12:51:18 | Re: Schemas, and visibility of tables in MS-Query. |
| Previous Message | Mike Mascari | 2003-10-01 12:39:31 | Re: FUD!! ODBC will not be supported by Microsoft in the future |