From: | nconway(at)klamath(dot)dyndns(dot)org (Neil Conway) |
---|---|
To: | Jochem van Dieten <jochemd(at)oli(dot)tudelft(dot)nl> |
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 00:29:14 |
Message-ID: | 20020706002914.GA13356@klamath.dyndns.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-odbc |
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(at)rogers(dot)com>
PGP Key ID: DB3C29FC
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-07-06 02:13:45 | Re: I am being interviewed by OReilly |
Previous Message | Jochem van Dieten | 2002-07-06 00:07:34 | Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion |
From | Date | Subject | |
---|---|---|---|
Next Message | Jochem van Dieten | 2002-07-06 11:41:24 | Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion |
Previous Message | Jochem van Dieten | 2002-07-06 00:07:34 | Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion |