Re: slowness in fetch from the psqlodbc driver

> -----Original Message-----
> From: Of Ionut Giurea
>
> Hi,
>
> I am using PsqlODBC 7.2.5 and Postgres 7.2.2. While trying to run
> a Delphi
> 3 application using BDE I noticed some important differences in
> comparison
> to an MS Sql database in selecting multiple rows from a database.
> This can
> be noticed even in borland's database explorer when running a
> select * from
> large_table and displaying the results in a grid table. I looked at the
> traffic between the computer and the database usgina tcp/ip
> packet sniffer
> and the response I got from the MS SQL and Postgres SQL server are quite
> similiar as traffic and speed, BUT there are two differences:
>
> 1. In the postgres case, all the respone records are fetched from the
> database server by the odbc driver,while in the MS SQL case, not all the
> response records are transferred, only a part, and the rest are
> transferred
> when I move down in the application's grid table. This difference
> is not so
> important from the user's point of view, he didn't even notices it, it
> might became semnificative for very large tables when the traffic between
> the application and the database server is big.

Please turn on the *use declare/fetch* option.

regards,
Hiroshi Inoue