Re: network saturation

On 27/01/06, Ludek Finstrle <luf(at)pzkagis(dot)cz> wrote:
>
> 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.
>

I have tested with the dlls changed (107) and WOW - what a difference!
Thanks! We tried with 102 on another system and it didn't work. We aren't
going to search to hard though cos, hey, we have the best solution!
Thanks heaps
Antoine

--
This is where I should put some witty comment.