Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Improve ODBC Throughput ?
- From: Arnaud Lesauvage <thewild(at)freesurf(dot)fr>
- To: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
- Cc: pgsql-odbc(at)postgresql(dot)org
- Subject: Re: Improve ODBC Throughput ?
- Date: Fri, 20 Oct 2006 09:29:19 +0200
Hiroshi Inoue a écrit :
Arnaud Lesauvage wrote:Hi list ! I mostly use my PostgreSQL as a backend DB with Access2000 frontends. The tables are linked via psqlODBC.The problem I have is that even though queries / views run very fast, the data take a long time to arrive to the client. In the best situations, data is sent/received at ~500kB per second (for instance, tables with only one column, which is a very large text field >10.000 bytes per field).How are you setting the "Text As LongVarchar" option ? Are the columns text or memo using Access ?
TextAsLongVarchar=0 but the columns are VarChar in Access.
- Follow-Ups:
- Re: Improve ODBC Throughput ?
- From: Hiroshi Inoue
- Re: Improve ODBC Throughput ?
- References:
- Improve ODBC Throughput ?
- From: Arnaud Lesauvage
- Re: Improve ODBC Throughput ?
- From: Hiroshi Inoue
- Improve ODBC Throughput ?
- Prev by Date: Re: Improve ODBC Throughput ?
- Next by Date: Re: Improve ODBC Throughput ?
- Previous by thread: Re: Improve ODBC Throughput ?
- Next by thread: Re: Improve ODBC Throughput ?
- Indexes: