From: Mike Mascari <mascarm@xxxxxxxxxxx>
To: Stephen Frost <sfrost@xxxxxxxxxxx>
CC: markw@xxxxxxxxxxxxxx, slutz@xxxxxxxxxxxxxx,pgsql-odbc@xxxxxxxxxxxxxx
Subject: Re: [ODBC] FUD!! ODBC will not be supported by Microsoft in the
future
Date: Wed, 01 Oct 2003 08:39:31 -0400
Stephen Frost wrote:
> * markw@xxxxxxxxxxxxxx (markw@xxxxxxxxxxxxxx) wrote:
>>That is not a PostgreSQL ODBC issue. There is a setting, I forget the
>>name, that enables a cursor in the query.
>
> It should be on by default then, and I didn't see that option when I was
> looking, can you tell me where it is?
Nothin' like RTFM:
http://gborg.postgresql.org/project/psqlodbc/genpage.php?doc-config
>>On a side not, you will be hard pressed to find a commercial ODBC
>>application, i.e. Access, that can handle large tables.
>
> Uh, Access and Oracle ODBC works just fine on the same table that
> Postgres ODBC grinds the machine to a halt on.
Use Declare/Fetch
>>For what its worth, I use the PGODBC driver to create an index of tables
>>with Millions of rows.
>
> 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.
Use Declare/Fetch
HTH,
Mike Mascari
mascarm@xxxxxxxxxxx
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
