Re: network saturation - Mailing list pgsql-odbc

From Ludek Finstrle
Subject Re: network saturation
Date
Msg-id 20060127145701.GD19397@soptik.pzkagis.cz
Whole thread Raw
In response to Re: network saturation  (Antoine <melser.anton@gmail.com>)
Responses Re: network saturation  (Antoine <melser.anton@gmail.com>)
List pgsql-odbc
Fri, Jan 27, 2006 at 03:40:06PM +0100, Antoine napsal(a):
> > It could be interesting to see what settings do you use for psqlodbc.
> > BTW 08.01.0102 isn't very good. Please try 08.01.0107 development
> > snapshot from pgfoundry.org. There is fixed a lot of bugs
> > (Parse Statement, get values, stability, ...).
> > Then you can try different options like use declare/fetch, Parse
> > Statement,
> > ... Different tasks need different options turned on.
>
> I would love to try it, seeing as declaire/fetch doesn't change anything...
> Do I simple replace the dlls in C:\Program Files\psqlODBC\bin?

Yes. It's enough.

But it's strange that declare/fetch doesn't change anything.
Driver fetch "cache size" (option on Page1 in left bottom corner) rows
from backend after open. "cache size" is 100 by default. So if you have
less rows in selects you could try to play with the cache size parameter.

Regards,

Luf

pgsql-odbc by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Odbcapi30.c - 64 bit compiler warning cleanup
Next
From: Tom Lane
Date:
Subject: Re: Disallow premature is broken