| 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 |