Re: max size of array
- From: "John Spencer" <spencer@xxxxxxxxx>
- Date: Tue, 31 Jan 2006 08:40:40 -0500
I would suspect that it has to do with the amount of ram you have and how
large the elements of the array are.
Not counting the overhead involved with the setting up and maintaining the
array (Don't ask me, I don't know how much), you have 2,000,000 * 2 *
average field size bytes of space being used for this array.
Megabyte = 1 million bytes so very, very roughly
4 * average field size = number of megabytes needed to build the array. 40
character field can be 80 bytes (depending on character set)
4*80 = 320 megabytes of memory (plus overhead)
All of the above calculation being done early in the morning so now
guarantees that I didn't screw something up.
"Jesper F" <askfortheemail@xxxxxxx> wrote in message
news:uIIkNxjJGHA.3224@xxxxxxxxxxxxxxxxxxxxxxx
> I'm trying to fill a 2-dimensional array with ca. 2.000.000 records and
> I'm getting a 'out of memory' error. Is that due to limitations on my
> machine or in VBA or something else?
>
> Jesper
>
.
- References:
- max size of array
- From: Jesper F
- max size of array
- Prev by Date: Re: Formating Listview
- Next by Date: Re: GoTo Specific Record
- Previous by thread: Re: max size of array
- Next by thread: fees
- Index(es):
Relevant Pages
|
