RE: User Space or Data Queue or PF or IFS

["John Brandt Sr." <pgmr@xxxxxxxxxxxxxxx>]

Yes... The difference is a minimum of 4 records per second (121 maximum with
a short record and all numeric) vs. 13 seconds per record depending on the
SQL server and network traffic.
John

-----Original Message-----
From: jt [mailto:jt@xxxxxx]
Sent: Monday, November 03, 2003 2:22 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: User Space or Data Queue or PF or IFS


Uhhh...  Good questions.  Easiest way sure /would/ be 1 at a time.  Is
performance an issue, and is it actually that much of a difference?

| -----Original Message-----
| [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Hans Boldt

| What is
| the purpose to these machinations? That is, why not just retrieve
| one record at a time from the SQL server instead of a big bunch of
| records?



_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.532 / Virus Database: 326 - Release Date: 10/27/03
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.535 / Virus Database: 330 - Release Date: 11/1/03