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 |