Re: performance issue..

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Mahesh

A couple things-

1. Although 550 is not a lot of records, IMO, you're better off loading a 
page at a time with SFLSIZ = SFLPAG + 1. Look at the Application Display 
Programming manual for everything you need to learn about this technique, 
called something like subfile size greater than subfile page.

In this technique, fewer records are downloaded, therefore it'll take less 
time to see the app the first time. Each page down will take a little 
longer, but that's probably better than what you have now.

2. I suspect the network connection, although 15 minutes seems inordinate. 
What is the Internet connection - modem? Then it'll be pretty bad. I 
suspect you don't have cable or DSL connections in India, do you? I'm 
ignorant here. Or are they on high-speed T1 or better connections? What is 
the US connection? In other words, what is different? What are the Ethernet 
speeds at the various sites? 10, 100, 1000? What about computer speeds - 
memory & CPU?

3. What is the access means to the data? ODBC? Then you have a number of 
optimization possibilities. If JDBC, that often is based on ODBC, so the 
same thing there. The latest version of the driver has more things you can 
do. Check the iSeries Access site at www.iseries.ibm.com/access, take the 
Library link on the left, and look for _Client Access for Windows 95/NT 
ODBC User Guide_, which has excellent performance information.

HTH

Vern

At 03:19 PM 10/21/2003 +0530, you wrote:
> Hello all,
> I am facing small problem. In my project. Please help me ..
> I have application developed using VARPG The application server is in USA. 
> and my indian customer & USA customers are operating this application. 
> When US people are  using this application while loading data in subfile 
> there is no problem. but when Indian users are accessing same application 
> via internet to load 550 records in a subfile from the database file it 
> takes around 15 minutes. Can anybody suggest me the better way / solution 
> for this problem.
> (Note : The subfile is loaded record by record without using embedded sql.)
>
> Thanks in advance.
>
> Thanks & Regards
> Mahesh Pawar
> Project Manager