From: | Arnaud Lesauvage <thewild(at)freesurf(dot)fr> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Improve ODBC Throughput ? |
Date: | 2006-10-19 12:54:45 |
Message-ID: | 45377595.4070306@freesurf.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | rhair | 2006-10-19 13:30:16 | Re: Username and password from DSN being overwritten (fix |
Previous Message | Mohammad Arif | 2006-10-19 08:10:46 | Db connection problem |