Re: Good size for multiple row fetch

If I am doing multiple row fetches I always map the array or data structure
into a user space and declare 32766 as the size and fetch 32766 rows. The
more you read in in a single fetch, the better the performance is going to
be. The only thing you have to protect against is a query returning more
than 32766 rows which is very rare.

On Thu, Aug 20, 2009 at 7:31 AM, <Rick.Chevalier@xxxxxxxxxxxxxxx> wrote:

Mihael,

I have always used 128k when doing SQL multi row fetching. This number was
given to me by Dan Crukshank (sp?) of IBM a few years ago. If you check the
archives I know you will find at least one discussion of this topic.

Rick

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Schmidt, Mihael
Sent: Thursday, August 20, 2009 1:37 AM
To: RPG programming on the IBM i / System i
Subject: Good size for multiple row fetch

Hi,

I'm using the multiple row fetch feature in my sql rpg program and am
wondering what a good size for the returning data would be (how big should
the array of my host data structure be)? Anybody a good formula?

Thanx in advance.

Mihael Schmidt
Anwendungsentwicklung

Dirk Rossmann GmbH
Iserhägener Str.16
30938 Burgwedel
* +49 (05139) 898 - 4353

Handelsregister-Nr. HRB 120546, Amtsgericht Hannover Ust-Id-Nr. DE
115055186 St.-Nr. 16 / 205 / 65401
Geschäftsführer: Dirk Roßmann, Alice Schardt-Roßmann, Roland Frobel, Klaus
Praus

Privileged and Confidential. This e-mail, and any attachments there to, is
intended only for use by the addressee(s) named herein and may contain
privileged or confidential information. If you have received this e-mail in
error, please notify me immediately by a return e-mail and delete this
e-mail. You are hereby notified that any dissemination, distribution or
copying of this e-mail and/or any attachments thereto, is strictly
prohibited.
--
This is the RPG programming on the IBM i / System i (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.