Re: [PERFORM] [JDBC] Data Selection Slow From VB 6.0

2005-08-18 Thread Oliver Jowett
Mahesh Shinde wrote: Hi I am using Postgres version **PostgreSQL 7.4.5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5).* * for an multy user desktop application using VB 6.0 as a front end toll. To connect To the PostgreSQL I am u

Re: [PERFORM] [JDBC] Cursors performance

2004-07-09 Thread Oliver Jowett
Bill Chandler wrote: Now the mystery is why is this happening all of the sudden? I have been running w/ fetch size set to 5000 for the last couple of weeks and it did not appear to be doing this (i.e. re-running the entire select statement again). Is this what I should expect when using cursors?