Out of memory message

[Ethan Kayes <ebkayes@HEWITT.COM>]

Anne-Marie

Why don't you send a copy of the program to the user group as a file attachment.

Most of the memory constraints in SQR are server related. ie how much memory
does the server physically have and how it is partitioned.

Is there any particular reason why you are loading all data into an array?

Ethan
---------------------- Forwarded by Ethan Kayes/National/Hewitt Associates on
02/07/2001 08:55 AM ---------------------------

From: AM Matula <amatula@OIT.UMASS.EDU> on 02/07/2001 07:58 AM

Please respond to sqr-users@list.iex.net

To:   SQR-USERS@list.iex.net
cc:
Client:
Subject:  Out of memory message



-- - -- - -- - -- - -- - -- - -- - -- - -- - -- - --
Anne-Marie Matula
Student Information System Project
Office of Information Technologies
University of Massachusetts
740 N. Pleasant St
OIT-LGRC A247
Amherst, MA  01003-9306
Phone: 413/577-0685
Fax: 413/545-2150

Hi all

I have a SQR that is aborting with the out of memory error.  What's
distressing
is it aborts during execution of the first procedure!

The first procedure simply:
1 extracts all records from a table
2 formats name (closed procedure calls)
3 stores data from the table in an array (initialized at a size of 250,000

This SQR ran fine when 4,000 records were extracted.  Now 225,000 records
are
being extracted.  I use about 6 arrays all with initial sizes between 100-
250K.  They were even larger before the "out of memory" message; I thought
perhaps decreasing the size might resolve this but it didn't.

Any suggestions for resolving?  I know I could decrease the # of records
processed at one time but I would rather not pursue that unless it is
absolutely necessary.

Thank you in advance!!
Anne-Marie

PS Please respond to me (cc line) at amatula@oit.umass.edu as I get this in
digest format.