RE: Good size for multiple row fetch

Why 32766? Why not a multiple of the record length?

User_space_size / record_length = number_of_records rounded down


If you only fetch 32,766 rows why are you concerned about fetching more? SQL will only fetch what you tell it to and if you have more records just do another fetch.

Rick


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Campin
Sent: Thursday, August 20, 2009 9:23 AM
To: RPG programming on the IBM i / System i
Subject: 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.


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.