Re: "Official" version - Mailing list pgsql-odbc

From Ing. Martin Šramko
Subject Re: "Official" version
Date
Msg-id 001c01c5a5a6$78658340$6401a8c0@martin
Whole thread Raw
In response to Re: "Official" version  ("Dave Page" <dpage@vale-housing.co.uk>)
List 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@vale-housing.co.uk>
To: <martin@soltec.sk>
Cc: <pgsql-odbc@postgresql.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@soltec.sk>
> Sent: 20/08/05 11:07:08
> To: "Dave Page"<dpage@vale-housing.co.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@vale-housing.co.uk>
> To: <pgsql-odbc@postgresql.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@postgresql.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
>


pgsql-odbc by date:

Previous
From: "Dave Page"
Date:
Subject: Re: "Official" version
Next
From: Bernard Henry Voynet
Date:
Subject: Unexpected ADO properties