Re: XMLSERVICE with .Net

From: Vernon Hamberg
HR - no one has presented any benchmarks - some downloaded code and
say  things like "it looks like" - that is no test! That is speculation in the
english language.

Hello, Vern. I gather that you finally read my CGI vs. QZDASOINIT benchmark comparison. For others who may be quasi-reading my messages I'll repost the link to the CGI program that I was testing with:

http://www.radile.com/rdweb/ptl/ptl100/launch.shtml?app=xcsx100


The radio button that downloads the MDEF150P table in CSV format consumes 88 milliseconds on my IBM i server. For comparison purposes I used Visual Foxpro to download the MDEF150P table, where the corresponding QZDASOINIT job consumes 116 milliseconds. The CGI interface evidently has slightly less overhead.

We've been getting vague references to CGI performance "warnings" pertaining to XMLCGI, from Alan and Brian. But no benchmark data. That concerns me. Maybe Tony “Ranger” Cairns of IBM will join the discussion and clear matters up.


Regarding my alleged "speculation" about XMLCGI using an SQL CLI interface to call the stored procedures, I see the RPG code for the SQL CLI interface. But the part that confuses me is the CL build scripts for XMLCGI.PGM and XMLSERVICE.PGM, which binds all the procedures into both programs. If all the same procedures are already bound "by copy" into XMLCGI.PGM, then why does it use an SQL CLI interface to call them? Using SQL CLI within XMLCGI doesn't concern me, but if they want to do that, then why also bind by copy, which adds significant BULK to XMLCGI?

CRTPGM PGM(XMLSERVICE/XMLSERVICE) +
  MODULE(XMLSERVICE/XMLSERVICE XMLSERVICE/PLUGBUG +
         XMLSERVICE/PLUGIPC XMLSERVICE/PLUGRUN +
         XMLSERVICE/PLUGPERF XMLSERVICE/PLUGCACH +
         XMLSERVICE/PLUGERR +
         XMLSERVICE/PLUGSQL XMLSERVICE/PLUGDB2 +
         XMLSERVICE/PLUGCONF3 +
         XMLSERVICE/PLUGPASE XMLSERVICE/PLUGLIC +
         XMLSERVICE/PLUGSIG XMLSERVICE/PLUGCONV +
         XMLSERVICE/PLUGXML XMLSERVICE/PLUGILE)
CRTPGM PGM(XMLSERVICE/XMLCGI) +
  MODULE(XMLSERVICE/XMLCGI XMLSERVICE/PLUGBUG +
         XMLSERVICE/PLUGIPC XMLSERVICE/PLUGRUN +
         XMLSERVICE/PLUGPERF XMLSERVICE/PLUGCACH +
         XMLSERVICE/PLUGERR +
         XMLSERVICE/PLUGSQL XMLSERVICE/PLUGDB2 +
         XMLSERVICE/PLUGCONF3 +
         XMLSERVICE/PLUGPASE XMLSERVICE/PLUGLIC +
         XMLSERVICE/PLUGSIG XMLSERVICE/PLUGCONV +
         XMLSERVICE/PLUGXML XMLSERVICE/PLUGILE) +
         BNDSRVPGM(QHTTPSVR/QZSRCORE)

-Nathan