From: Byron Nikolaidis <byron.nikolaidis@home.com>
To: Willy De la Court <Willy.DelaCourt@pandora.be>
Cc: pgsql-interfaces@postgreSQL.org <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] Serious problem with the odbc driver and VFP
Date: Tue, 29 Feb 2000 23:44:33 -0500
Message-ID: <38BCA031.BEAF9872@home.com> (raw)
References: <01BF8300.23525460.Willy.DelaCourt@pandora.be>
Willy De la Court wrote:
>
> After byron fixed the odbc driver to version 0009 I could use foxpro
> perfectly with small tables.
>
> Now another problem surfaces.
> I think the guys that wrote VFP only had microsoft SQL server in mind
> because when using the vfp interface to create views they frequently use
> SQLPREPARE "SELECT * FROM TABLE" and then use SQLNumResultCols to get a
> result.
>
> For small tables this is no problem but if you have a multi megabyte table
> with about 50000 records in you do have a problem.
> SQLPREPARE works OK but when VFP executes SQLNumResultCols directly after
> the Prepare the odbc driver submits the "SELECT * FROM TABLE" to the
> backend effectively executing the query. Result is 2 minutes waiting time
> and sometimes memory error on the backend.
>
> Any ideas how to solve this problem.
>
> ************
Set the "use declare/fetch" driver option to enabled. This will cause
the driver to only fetch 100 rows (or whatever you have the size set to
in the driver options) before returning control. It can then return the
result of SQLNumResultCols easily and cancel the statement or continue
processing.
Byron
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byron.nikolaidis@home.com, Willy.DelaCourt@pandora.be
Subject: Re: [INTERFACES] Serious problem with the odbc driver and VFP
In-Reply-To: <38BCA031.BEAF9872@home.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox