Re: Good size for multiple row fetch

[Alan Campin <alan0307d@xxxxxxxxx>]

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.