I am trying to hold more than 64K of data. Using one array

I can hold up to 64K. Declaring a fixed set of array allows

for more storage but it is fixed. Is there any way of dynamically

creating new arrays so that more than 64K of data can be held?

Alas, we we all like to see the 64K barrier broken. Maybe in JRev…

For now, unfortunatelly there is no way of doing it. There are workarounds though:

1. What you just mentioned:

   Make a matrix of size n so that will give you a maximum of n * 64K of storage space - and it would be pretty easy and fast to access

2. A slower but more flexible choice (you won't have a limit of n anymore)

 Instead of defining a matrix, create a new table. Store your data in 64K chuncks in the rows of the table. Make the keys of the rows 1, 2, 3, etc. That should give you a way of accesing the first, second, ... nth chunck of 64k       data and obviously there is no limit as to how many rows you can store in the table. 

If you need to do inserts in the 64K chunks then I suggest that you use something like 100, 200, 300 for the keys of the original rows. If then, by inserting in row 100 you end up needing over 64K of data, instead of changing row 200, you can just create a new row with key=101 or 150 or something similar that's less then the next key in numerical order. This new record will contain the overflow from row 100.

It's a slower and more painful method than storing stuff in memory, but it's the only way I can think about in which you have a unlimited amount of storage space for data.

For now 64K is the max for a record no matter how you look at it and I don't think it's going to change in the near future.

Hope this helps, and that I am not far off the mark

Dave

Thanks Dave. Igenious!

Jacob,

Here is an implementation of ]64k lists of data. We used to use it to publish the many thousands of HTML files that went onto the Works CDs. The two attachments to this message go into SYSPROCS/BIGLIST and SYSPROCS/BIGLIST_EQUATES.

Cameron.

Great example

dsig

David Tod Sigafoos ~ SigSolutions

dsig@teleport.com voice: 503-630-8080 cis:70302,77

NOTICE FOR RTI FORUMS: Although care was taken to not hurt anyones feelings or impugn

the quality of any product, support or idea IF there is an exception taken please note in detail the offending portion of

** the note and email me. I will take all notes under advisement.

View this thread on the forum...