Re: XMLSERVICE with .Net

From: "Dean, Robert"
An apples-to-apples comparison would be, for example, a Java program that uses
an HTTP client to consume the CGI program results and JDBC to consume an SQL
result set.

That would be a good test. One difference I see between a CGI interface and a ODBC/JDBC/QZDASOINIT interface is that the CGI interface returns the entire result set to the client all at once, while the ODBC/QZDASOINIT interfaces I've been testing with return a small subset of the query results, then waits for the client to request more. QZDASOINIT behaves more like a tunnel. The complete SQL result set remains cached in the QZDASOINIT job until the client requests it. In the case of IBM i Navigator and Visual Foxpro clients, it may take a minute or more to retrieve the entire result set for "display" on the client. But that appears to be controlled by the client.

-Nathan.