By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,007 Members | 1,237 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,007 IT Pros & Developers. It's quick & easy.

retrieving clobs over wan

P: n/a


Hello,
Recently I had to connect my application (Delphi, dbexpress) to
remote db2 server connected via WAN. (3Mb/s).
If I'm not working with clobs - everything works just great - I have
an average network transfer of 280 Kb/s. The problem is that when I'm
trying to retrieve clobs as well - everything gets slower for ten times
or even worser. (Network transfer of an averege 20-30 Kb/s).

Any advices?

Kacper.

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You might be flooding the WAN with packets causing congestion at an
intermediate node. Standard IP resolution for congestion is to drop
packets until the congestion is relieved. TCP protocols recognize the
lost packets and request retransmission.

It'll take some sophisticated monitoring to determine what is happening.
Try getting a good set of non-clob data transfer sizes and clob sizes,
information about the WAN architecture, and look at asking this on a
TCP/IP forum.

Phil Sherman
kacper wrote:


Hello,
Recently I had to connect my application (Delphi, dbexpress) to
remote db2 server connected via WAN. (3Mb/s).
If I'm not working with clobs - everything works just great - I have
an average network transfer of 280 Kb/s. The problem is that when I'm
trying to retrieve clobs as well - everything gets slower for ten times
or even worser. (Network transfer of an averege 20-30 Kb/s).

Any advices?

Kacper.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.