Fastest way to read tuples
От | Joachim Zauner |
---|---|
Тема | Fastest way to read tuples |
Дата | |
Msg-id | GJEKKBOHHLHLNLHFHPLFAEHACAAA.j.zauner@epcom.cc обсуждение исходный текст |
Ответы |
Re: Fastest way to read tuples
|
Список | 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
В списке pgsql-odbc по дате отправления: