Net.Data 400 times slower

[Vern Hamberg <hambergv@xxxxxxxxxxxxxx>]

I really need you help!

I've run into what I think is a showstopper as far as Net.Data is
concerned. It's performance is _so_ bad that it has become unusable for us.

I have a PMR in with IBM (30286,379 for those who can look it up, please!).
I'm getting no good response, IMO. In fact, I think I'm getting the
runaround. The last thing I was told is, they'll tell me how to submit a
design change request.

Here are some lowlights:

1. I am using the WWW server on a 510 running v4r1, otherwise running as
our development box.

2. I am trying to retrieve data from an F80 running v3r2.

3. The data file (I'm accessing it arrival sequence) has 40+k records of
length 477, but I am retrieving a single 10-character field in the SQL
select statement.

4. As you may know, DRDA is used to connect and retrieve the data.

5. I am using Netscape Communicator v4.03 or so.

6. When I request the page from the server, it takes about 5 minutes of
hourglass, and then I get a Netscape message window with 'Your document has
no data.'

7. The v3r2 machine's DRDA server job shows that it is retrieving data in 8
record blocks--yes, that's 80-character blocks!!!! Eventually the HTTP
server job on the v4r1 machine cancels the conversation. This usually
happens when the DRDA server has reached 20-25k records.

8. In contrast, when run with STRQMQRY, the DRDA server job shows blocking
of c. 3200 records (32k blocks), which is what it should be doing, right?

We're talking 400 times slower with Net.Data, supposedly using the same
mechanism!


My plea:

I have a number of logs, etc., showing details of what I've described
above. I also have the printout of the call history with Support Line. If
anyone can look at these, please contact me privately. I want to use this
product to Internet-enable some of our applications, but in it's present
state, it is completely unusable. The present implementation is crap, as
far as I'm concerned. I'm hopping mad!!!

I'm sending this blind copy to a number of you, as well.

Any and all help is hugely appreciated!

Vernon Hamberg
Systems Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN 55401
(612) 371-1111 x480


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---