Re: Out of memory message

["Lynds,Rick" <rlynds@MWD.DST.CA.US>]

Hi Anne-Marie,

While the number of elements for an array are allocated during compile-time,
the actual memory is allocated as needed (while you are filling the array).
I suspect that with 225000 records, you are truly filling up your available
memory.  I tried a couple of tests with an single array of 200,000 entries
with a couple of text strings and it chewed up 50meg of ram in a hurry.

I suspect that you may be stuck with reducing the number of records in your
arrays.

HTH

Rick Lynds

-----Original Message-----
From: AM Matula [mailto:amatula@OIT.UMASS.EDU]
Sent: Wednesday, February 07, 2001 5:59 AM
To: SQR-USERS@list.iex.net
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.