| From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
|---|---|
| To: | Bruce Holt <bj_holt(at)hotmail(dot)com> |
| Cc: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: Max LongVarChar |
| Date: | 2002-12-17 00:31:53 |
| Message-ID: | 3DFE7079.6D4A2028@tpf.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Bruce Holt wrote:
>
> What is the maximum value for 'Max LongVarChar' within the
> ODBC Advanced Options (DSN 1/2) dialog box?
There's no max value because the driver itself doesn't
provide any buffer beforehand with the MaxLongVarChar size.
However, most applications seem to have their own text
size limitations.
> What affect does this setting have on
> performance?
It depends on your application. If your application
binds a text item with the MaxLongVarChar sized buffer
,it may unnecessarily consume a large memory.
regards,
Hiroshi Inoue
http://w2422.nsk.ne.jp/~inoue/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | srihari | 2002-12-17 09:35:11 | Kylix-postgreSQL connectivity |
| Previous Message | Hiroshi Inoue | 2002-12-17 00:11:08 | Re: Problem with table name in capitals. |