Re: Fastest way to read tuples - Mailing list pgsql-odbc

From Simeó Reig
Subject Re: Fastest way to read tuples
Date
Msg-id 002f01c2f2e6$3b3341d0$0500a8c0@incofisa.com
Whole thread Raw
In response to Fastest way to read tuples  ("Joachim Zauner" <j.zauner@epcom.cc>)
List pgsql-odbc
You should play with a 'limit' in the sql .
Best regards

Simeó Reig



----- Original Message -----
From: "Joachim Zauner" <j.zauner@epcom.cc>
To: <pgsql-odbc@postgresql.org>
Sent: Tuesday, March 25, 2003 9:39 AM
Subject: [ODBC] Fastest way to read tuples


> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


pgsql-odbc by date:

Previous
From: "Dave Page"
Date:
Subject: Re: FW: Message for: dpage
Next
From: günter strubinsky
Date:
Subject: Re: FW: Message for: dpage