Re: network saturation

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