pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedSerious problem with the odbc driver and VFP
2+ messages / 2 participants
[nested] [flat]
* Serious problem with the odbc driver and VFP
@ 2000-02-29 20:58 Willy De la Court <Willy.DelaCourt@pandora.be>
0 siblings, 1 reply; 2+ messages in thread
From: Willy De la Court @ 2000-02-29 20:58 UTC (permalink / raw)
To: pgsql-interfaces
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [INTERFACES] Serious problem with the odbc driver and VFP
@ 2000-03-01 04:44 Byron Nikolaidis <byron.nikolaidis@home.com>
parent: Willy De la Court <Willy.DelaCourt@pandora.be>
0 siblings, 0 replies; 2+ messages in thread
From: Byron Nikolaidis @ 2000-03-01 04:44 UTC (permalink / raw)
To: Willy De la Court <Willy.DelaCourt@pandora.be>; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-03-01 04:44 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-02-29 20:58 Serious problem with the odbc driver and VFP Willy De la Court <Willy.DelaCourt@pandora.be>
2000-03-01 04:44 ` Byron Nikolaidis <byron.nikolaidis@home.com>
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