Improve ODBC Throughput ?
От
Arnaud Lesauvage
Тема
Improve ODBC Throughput ?
Дата
Msg-id
45377595.4070306@freesurf.fr
Список
Дерево обсуждения
Re: Improve ODBC Throughput ? "Benjamin Krajmalnik" <kraj@illumen.com>
Re: Improve ODBC Throughput ? Arnaud Lesauvage <thewild@freesurf.fr>
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). In bad situations, I am at ~50kB per second. If the queries / views return large resultsets, it can seconds for the table to open., even though the query ran in milliseconds on the server (explain analyze proves this). What can I do to improve this throughput ? Either on the server side, or on the ODBC client side ? As a side note : network congestion, server acitvity is not a good explanation. This server also is a file server, and I transfer files at 10MB per second all the time. Thanks for your advices ! -- Arnaud
В списке pgsql-odbc по дате отправления
От: rhair@bowmansystems.com
Дата: