From: | Antoine <melser(dot)anton(at)gmail(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: network saturation |
Date: | 2006-01-27 09:20:37 |
Message-ID: | 92d3a4950601270120j7c2b2765x@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
On 27/01/06, Antoine <melser(dot)anton(at)gmail(dot)com> wrote:
>
> Hi,
> We have a fully switched 100mbps network, and communication between
> clients running vb6 apps via odbc (08.01.02, i.e., the latest stable) are
> taking up from 20 to 40% of the bandwidth - per APP!. The server is 8.1.1running on mandrake
> 10.1.
> The offending apps are not coded well but this is just enormous. Even
> worse, the apps do an OCR which takes about 5 seconds (during which no db
> access takes place) and for some reason it seems there is still a lot of
> traffic (we have HP switches and port usage NEVER falls below 15%).
> Can anyone shed some light on this? When 4+ apps start hitting the db
> performance starts to degrade quite considerably.
For info, these apps have a transaction open pretty much constantly (none of
the other apps have this, and don't seem to use much bandwidth). Originally,
they were open for 1.5hrs and now opened and closed every two minutes (as
soon is one is closed another is opened)
Chrs
--
This is where I should put some witty comment.
From | Date | Subject | |
---|---|---|---|
Next Message | Ludek Finstrle | 2006-01-27 09:21:59 | Re: PsqlODBC slow on UNION queries |
Previous Message | Antoine | 2006-01-27 09:14:57 | network saturation |