Skip site navigation (1) Skip section navigation (2)

Re: "Official" version

From: Ing(dot) Martin Šramko <martin(at)soltec(dot)sk>
To: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
Cc: "psqlodbc" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: "Official" version
Date: 2005-08-20 16:44:27
Message-ID: 001c01c5a5a6$78658340$6401a8c0@martin (view raw or flat)
Thread:
Lists: pgsql-odbc
Yes, I've tried 08.01.0003 and logging is off, if new driver use parameters 
b2 and b3 to control this. (is this true?)

I'm using dataset with more tables connected to database through that 
driver. For each table I've created OdbcCommand with needed SQL statements 
(select, insert, update - some or all). On user form, I've 3 DataGrids to 
allow user to edit, add and delete records to appropriate table.  Tables are 
in relationship master-detail (1:N), so if user clicks on row in master 
datagrid (chooses record in master table), I need to show only appropriate 
child rows from detail table in detail datagrid. Sample - user clicks 
receipt with id 1 and I need to show receipt_items from receipt with 
receipt_id = 1. I'm using stored procs with few parameters to retrieve data 
from tables. Is it OK?

Thanks,

Martin

----- Original Message ----- 
From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <martin(at)soltec(dot)sk>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Sent: Saturday, August 20, 2005 5:51 PM
Subject: Re: [ODBC] "Official" version


> Have you tried 08.01.0003? Is all logging turned off?
>
> If it is still slower, can you describe your workload, and how you execute 
> queries (prepared?, declare/fetch etc?).
>
> Fwiw, the benchmarks I have run show very similar performance to the older 
> driver.
>
> Regards, Dave
>
> -----Original Message-----
> From: "Ing. Martin Sramko"<martin(at)soltec(dot)sk>
> Sent: 20/08/05 11:07:08
> To: "Dave Page"<dpage(at)vale-housing(dot)co(dot)uk>
> Subject: Re: [ODBC] "Official" version
>
> We are using psqlODBC 8.0.0102 and it is very stable to older versions...
> New driver (libpq) seems stable, but so slow (why?) to ODBC 08.00.0102. I
> can't find any reason for this. Can anyone help me? New driver has more
> futures (SSL and so on), so we'll happy if we can use it.
>
> Here is my system config:
>
> MS WIN XP SP2 +
> MS .NET Framework 1.1 SP1 +
> MS VS 2003 +
> psqlodbclibpq-08_01_0003
>
> Database server PostgreSQL 8.0.3 on Fedora 4
>
> My connection string (DSN less):
> DRIVER={PostgreSQL};SERVER=x;DATABASE=x;UID=x;PASSWORD=x;PORT=5432;
> A0=0;A1=6.4;A2=0;A3=0;A4=0;A5=0;A6=;A7=100;A8=4096;A9=0B0=254;B1=8190;B2=0;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_
>
>
> ----- Original Message ----- 
> From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
> To: <pgsql-odbc(at)postgresql(dot)org>
> Sent: Friday, August 19, 2005 9:40 PM
> Subject: [ODBC] "Official" version
>
>
>>I think it's fairly safe to say that the new libpq version of psqlODBC
>> is more stable than the previous release versions of the driver, and
>> also now offers more features such as SSL, Kerberos authentication (has
>> anyone tried this yet?), pgpass files and so on.
>>
>> In light of this, I think the libpq version should now take over as the
>> official driver, and lose the 'libpq' suffix that was added for testing.
>>
>> If anyone has any strong objections, please shriek soon!!
>>
>> Regards, Dave.
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 1: if posting/reading through Usenet, please send an appropriate
>>       subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>>       message can get through to the mailing list cleanly
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org
> 


In response to

pgsql-odbc by date

Next:From: Bernard Henry VoynetDate: 2005-08-20 18:53:39
Subject: Unexpected ADO properties
Previous:From: Dave PageDate: 2005-08-20 15:51:08
Subject: Re: "Official" version

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group