Fastest way to read tuples

From: "Joachim Zauner" <j(dot)zauner(at)epcom(dot)cc>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Fastest way to read tuples
Date: 2003-03-25 08:39:14
Message-ID: GJEKKBOHHLHLNLHFHPLFAEHACAAA.j.zauner@epcom.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi List,
I want to retrieve (readonly) 500 - 1500 Tuples via ODBC in an Visual Basic
6 Program over a 64kBit Line. The Raw Data of 500 Tuples is ~ 52kb but it
takes 7 Seconds to fill the Recordset.
Currently I use ADO to access the DB. I played around with Cursors but no
effect (with Serverside Cursor the execution of the SQL String is faster but
walking throug the Rows is slower).

The Problem is not the SQL String - the Server takes only 0.2 Seconds for
the Query but the Transfer of the Dataset is slow. Is RDO or DAO (or
whatever) faster?

Now some Info about my System:
ODBC Version: 07.02.0005
VB 6.0 Enterprise SP5
W2k Pro SP3
PostgreSQL 7.2.1 on SuSE Linux (for Development / 7.3 for Production)

My Connectionstring:
DRIVER={PostgreSQL+ (Beta)};DATABASE=ticket;SERVER=myServer
;PORT=5432;UID=myuser;PWD=mypass;ReadOnly=1;Protocol=6.4;FakeOidIndex=1;Show
OidColumn=1;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socke
t=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=8190;Debug=0;Com
mLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=1;TextAsLongVarchar=1;UnknownsAsLo
ngVarchar=0;BoolsAsChar=0;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=d
d_;;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=
0'

Regards,
j.zauner

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message günter strubinsky 2003-03-25 15:05:10 FW: Message for: dpage
Previous Message Hollysugar Webmaster 2003-03-24 23:47:13 errors syncing postgresql with pocketpc database