topic Re: package size in Application Development and Automation Discussions

package size

Former Member — Thu, 12 Mar 2009 07:52:25 GMT

hi experts,

please help in usage of package size in select query with where clouses

without for all enteries

regards

prashant

Re: package size

Former Member — Thu, 12 Mar 2009 07:57:33 GMT

'Package size' addition of SELECT statement will be used to restrict the number of records while fetching the data from the database table.

You can check [this link|;

Edited by: Satya suresh Donepudi on Mar 12, 2009 2:59 AM

Re: package size

Former Member — Thu, 12 Mar 2009 08:01:27 GMT

Hi,

Please check this link

it would helpful

Thanks and regards

Durga.K

Re: package size

Former Member — Thu, 12 Mar 2009 08:05:20 GMT

Hi,

Check this thread

Regards,

Jyothi CH.

Re: package size

Former Member — Thu, 12 Mar 2009 08:31:55 GMT

Hi Prashant,

Package size option in select query is useful in multiple cases:

- When the number of records accessed by the select query for the given where clause are very large and it may slow down the performance of the program. In this case package size option is used such that data is fetched in multiple hits.

- If the program is checking for a particular record from the database table having very large number of records without knowing the actual key. In this case package size can be used such that we can check for the existence of the required record after each fetching and can be exited from loop immediately after finding the record.

Thanks,

Sankar