| From: | Jochem van Dieten <jochemd(at)oli(dot)tudelft(dot)nl> |
|---|---|
| To: | Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> |
| Cc: | Markus Wollny <Markus(dot)Wollny(at)computec(dot)de>, cfdev(at)oosha(dot)com, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion |
| Date: | 2002-07-06 11:41:24 |
| Message-ID: | 3D26D764.1040203@oli.tudelft.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-odbc |
Neil Conway wrote:
> On Sat, Jul 06, 2002 at 02:07:34AM +0200, Jochem van Dieten wrote:
>
>>If you have queries returning multiple rows, make sure you have a
>>blockfactor set, this can make up a significant difference. Are you
>>returning text fields in queries? What if you explicitly cast them to
>>varchar fields (SELECT textfield::varchar ...)?
>
> What is the reasoning behind that?
No reasoning, just personal experience with ColdFusion 4.5.1 SP2,
PostgreSQL 7.1, the Windows ODBC driver 7.01.00.06 and query timeouts.
Jochem
--
Jochem van Dieten
Team Macromedia Volunteer fro ColdFusion
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-07-06 15:00:07 | Re: |
| Previous Message | Nigel J. Andrews | 2002-07-06 10:53:42 | Re: OID Errors |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hiroshi Inoue | 2002-07-06 15:43:03 | Re: UI patch (Was: ODBC Patch to prevent setting of KSQO on 7.3+ servers) |
| Previous Message | Neil Conway | 2002-07-06 00:29:14 | Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion |