Maximum Size of RecArrays, Lists and Assocs

Francisco_Alcala-Soler_(iaea_001user3_-_(deleted))

Hi,What's the maximum number of items I could store in List, Assoc or RecArray data types? And the max size the hold?I am trying to read a large text file and parse/sort its lines, but I suppose the sheer size is what makes my Builder crash, since a subset of the file works just fine. I have looked around in the documentation, but I haven't found anything regarding the limits. Any information you can provide will be much appreciated.Regards, Curro

Find more posts tagged with

Comments

Kevin_Ward

Message from Kevin Ward <<A HREF="mailto:kward@opentext.com">kward@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

I haven't run across any List or Assoc limits before but I believe RecArray's can only have up to 32K rows. Anymore and Builder will most likely crash.

Kevin

-----Original Message-----
From: eLink Discussion: Development Discussion [mailto:development@elinkkc.opentext.com]
Sent: May 23, 2003 9:02 AM
To: eLink Recipient
Subject: Maximum Size of RecArrays, Lists and Assocs

Maximum Size of RecArrays, Lists and Assocs Posted by IAEA_001User3 (Alcala-Soler, Francisco J) on 05/23/2003 03:29 AM

Hi,

What's the maximum number of items I could store in List, Assoc or RecArray data types? And the max size the hold?

I am trying to read a large text file and parse/sort its lines, but I suppose the sheer size is what makes my Builder crash, since a subset of the file works just fine.

I have looked around in the documentation, but I haven't found anything regarding the limits. Any information you can provide will be much appreciated.

Regards,

Curro

Francisco_Alcala-Soler_(iaea_001user3_-_(deleted))

It's actually RecArrays that I wanted to use, since I needed to load some 90K rows and sort them.Am I bound to creating some temp tables in the DB schema or do I have any other options?Thanks, Curro

Kevin_Ward

Message from Kevin Ward <<A HREF="mailto:kward@opentext.com">kward@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Can you get around the issue by splitting your data into multiple RecArrays? Have a List containing multiple RecArrays each with a subset of your data. If your data has a unique key, try making a giant assoc. assoc.1 = record1, assoc.2 = record2, etc.

Kevin

-----Original Message-----
From: eLink Discussion: Development Discussion [mailto:development@elinkkc.opentext.com]
Sent: May 23, 2003 12:41 PM
To: eLink Recipient
Subject: RE Maximum Size of RecArrays, Lists and Assocs

RE Maximum Size of RecArrays, Lists and Assocs Posted by IAEA_001User3 (Alcala-Soler, Francisco J) on 05/23/2003 12:24 PM
In reply to: RE Maximum Size of RecArrays, Lists and Assocs Posted by kward (Ward, Kevin) on 05/23/2003 10:48 AM

It's actually RecArrays that I wanted to use, since I needed to load some 90K rows and sort them.

Am I bound to creating some temp tables in the DB schema or do I have any other options?

Thanks,

Curro

Hans_Stoop_(hstoop_(Delete)_1579932)

Message from Hans Stoop <<A HREF="mailto:hstoop@opentext.com">hstoop@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

if the data is alreasy in the database you can do the sorting in the database and use a cursor in OScript to go through the data.

Hans

--------
Livelink Appearance: the easiest way to skin Livelink.
Contact hstoop@opentext.com for more information.

-----Original Message-----
From: eLink Discussion: Development Discussion [mailto:development@elinkkc.opentext.com]
Sent: vrijdag 23 mei 2003 18:41
To: eLink Recipient
Subject: RE Maximum Size of RecArrays, Lists and Assocs

RE Maximum Size of RecArrays, Lists and Assocs Posted by IAEA_001User3 (Alcala-Soler, Francisco J) on 05/23/2003 12:24 PM
In reply to: RE Maximum Size of RecArrays, Lists and Assocs Posted by kward (Ward, Kevin) on 05/23/2003 10:48 AM

It's actually RecArrays that I wanted to use, since I needed to load some 90K rows and sort them.

Am I bound to creating some temp tables in the DB schema or do I have any other options?

Thanks,

Curro