| From: | David Gardner <david(dot)gardner(at)yucaipaco(dot)com> |
|---|---|
| To: | Patrick Hatcher <PHatcher(at)macys(dot)com> |
| Cc: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: Driver seems to hang fetching data |
| Date: | 2007-02-28 23:02:41 |
| Message-ID: | 45E60A11.6060501@yucaipaco.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
I seem to remember having problems with Declare/Fetch, after turning it
off I had a huge performance boost when running large reports.
Patrick Hatcher wrote:
> driver version 8.02.02
>
> I have a query that returns around 30K records. I have set the cache to
> 1000 records. It appears that while pulling data, the driver hangs for
> around 30 seconds or more and then continues to the next batch of records.
> It does this same sort of behavior whether it caching is set to 100 or
> 1000. I am using DECLARE/FETCH.
> Is there anywhere I can check for the bottle neck?
>
> Thanks.
>
> Patrick Hatcher
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrick Hatcher | 2007-03-01 00:59:36 | Re: Driver seems to hang fetching data |
| Previous Message | Patrick Hatcher | 2007-02-28 22:19:33 | Driver seems to hang fetching data |