Re: slowness in fetch from the psqlodbc driver

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "Ionut Giurea" <elrubio(at)unirea(dot)ro>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: slowness in fetch from the psqlodbc driver
Date: 2003-02-16 10:33:19
Message-ID: EKEJJICOHDIEMGPNIFIJCEAFKLAA.Inoue@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

> -----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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Ian Sealy 2003-02-16 20:18:52 Re: Views and Access 2000
Previous Message Peter Darley 2003-02-15 22:38:03 Possible ODBC Issue