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

From nconway@klamath.dyndns.org (Neil Conway)
Subject Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion
Date
Msg-id 20020706002914.GA13356@klamath.dyndns.org
Whole thread Raw
In response to Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion  (Jochem van Dieten <jochemd@oli.tudelft.nl>)
List pgsql-general
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?

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC



pgsql-general by date:

Previous
From: Jochem van Dieten
Date:
Subject: Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion
Next
From: Bruce Momjian
Date:
Subject: Re: I am being interviewed by OReilly