Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion - Mailing list pgsql-general

From Jochem van Dieten
Subject Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion
Date
Msg-id 3D26D764.1040203@oli.tudelft.nl
Whole thread Raw
In response to Performance of ODBC-Driver /w IIS5.0/ColdFusion  ("Markus Wollny" <Markus.Wollny@computec.de>)
List pgsql-general
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

http://www.macromedia.com/support/forums/team_macromedia/




pgsql-general by date:

Previous
From: "Nigel J. Andrews"
Date:
Subject: Re: OID Errors
Next
From: Tom Lane
Date:
Subject: Re: