Without having more of a context on what you are doing it is hard to say but you can surely hold thousands of items in an array. You can even sort it if you need to using ADO. You may also want to look at the Dictionary object. If you can provide more real world examples of the data I may be able to give you more contexts. If you were using SQL you can use the GetRows method of the RecordSet object to quickly populate a 2-dim'd array with all of the data. It is very very fast.
-----Original Message----- From: David Helkenn [mailto:[email protected]] Sent: Tuesday, February 28, 2012 10:22 AM To: [email protected] Subject: RE: Very Large Array Storage Hello, Thanks for your reply. I'm not actually polling anything. I refered to the collection (not a technical term, just a set) of arrays to hold integers in an organized manner. They are more like mapping arrays and ordered integers. An anology would be an static array of of dynamic arrays like a list of variable length strings. Thanks... Dave At 07:56 AM 2/28/2012, you wrote: >What kind of database are you pulling from? Will you be using SQL to >perform the retrieval? > >-----Original Message----- >From: David Helkenn [mailto:[email protected]] >Sent: Tuesday, February 28, 2012 8:55 AM >To: [email protected] >Cc: [email protected] >Subject: Very Large Array Storage > >Hello, >I want to write an app that will require a fairly large database >organized in arrays. There are around 8500 integer elements to be >stored in some 35 arrays. I thought I could have a static array of the >35 dynamic arrays containing the integers. However, I do not know how >to get all that data initialized prior to the invokation of the rest of >the app. How do I get that data known to the app? > >The behavior from a very high view, is the user presses the activation >hotkey, the controls are displayed in the dialog and the database is >available for use. I do not know how long it will take to create the >database, but it is subject to an easily implemented algorithm. > >I am hoping to have this app as global. Will I need to use a file? If >so, where is the documentation related to the file system? I find only >a file/dir related document but there is no FSO in the GW toolkit. Help >please. > >Using Windows7pro64 and WE 7.5.3. > >Thanks... > >Dave
