From: | Antoine <melser(dot)anton(at)gmail(dot)com> |
---|---|
To: | Ludek Finstrle <luf(at)pzkagis(dot)cz> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: network saturation |
Date: | 2006-01-27 15:07:10 |
Message-ID: | 92d3a4950601270707l4006fcb6v@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Ludek Finstrle | 2006-01-27 15:09:46 | Re: Odbcapi30.c - 64 bit compiler warning cleanup |
Previous Message | Tom Lane | 2006-01-27 15:02:11 | Re: Disallow premature is broken |