From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "Stergios Zissakis" <szis(at)intranet(dot)gr>, <pgsql-odbc(at)postgresql(dot)org>, "Kostas Lykiardopoulos" <klyk(at)intranet(dot)gr>, "Dimitris Pantermalis" <dpant(at)intranet(dot)gr> |
Subject: | Re: Mutli-threading and performance of ODBC |
Date: | 2004-03-09 16:45:51 |
Message-ID: | 03AF4E498C591348A42FC93DEA9661B889F622@mail.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: 09 March 2004 16:35
> To: Dave Page
> Cc: Stergios Zissakis; pgsql-odbc(at)postgresql(dot)org; Kostas
> Lykiardopoulos; Dimitris Pantermalis
> Subject: Re: [ODBC] Mutli-threading and performance of ODBC
>
> "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> writes:
> > I removed KSQO long ago for servers >= 7.3 - for < 7.3 it
> is a config
> > option. GEQO is set via a config option - it is not forced on.
>
> I just looked through the unixODBC 2.2.8 sources, and I can't
> see anywhere that the behavior for KSQO is made
> version-dependent. It seems to be there and default to ON
> regardless of backend version.
It's not in unixODBC, it's in psqlODBC (and the above should have read
7.1).
From:
http://gborg.postgresql.org/project/psqlodbc/cvs/co.php/psqlodbc/connect
ion.c?r=1.67
/* KSQO (not applicable to 7.1+ - DJP 21/06/2002) */
if (ci->drivers.ksqo && PG_VERSION_LT(self, 7.1))
{
result = PGAPI_ExecDirect(hstmt, "set ksqo to 'ON'",
SQL_NTS);
if ((result != SQL_SUCCESS) && (result !=
SQL_SUCCESS_WITH_INFO))
status = FALSE;
mylog("%s: result %d, status %d from set ksqo\n", func,
result, status);
}
It's in tip as well...
Regards, Dave.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-03-09 16:58:29 | Re: Mutli-threading and performance of ODBC |
Previous Message | Tom Lane | 2004-03-09 16:34:54 | Re: Mutli-threading and performance of ODBC |