Why do we have to transpose a 2-d array to index it more efficiently?

[dt1804]

I have a 2d string array that is 8 columns wide and 100k rows. In order to index it, I have to transpose it. Why?

[GregFreeman]

It depends on what method of indexing you want to use to access your data. Are you using autoindexing for loops? If so, those will index rows and if you want column data that is the reason for the transpose being needed. If you want to just use index array you can explicitly state which column you want.

[dt1804]

Why would one way (non-transposing) make me run out of memory, while the other would not?  Basically all I wanted to do was chop off the top 23 rows of the array.

[Cory_K]

---

@dt1804 wrote:

Why would one way (non-transposing) make me run out of memory, while the other would not?  Basically all I wanted to do was chop off the top 23 rows of the array.

---

You can remove the top 23 rows without indexing the array.

It sounds to me like somewhere along the way you are making extra copies of the array,

which would explain why you are running out of memory.

You should just use the "array subset" function with the offset for rows wired to 22.

[GregFreeman]

---

@dt1804 wrote:

Why would one way (non-transposing) make me run out of memory, while the other would not?  Basically all I wanted to do was chop off the top 23 rows of the array.

---

You left that fairly substantial and important bit of information out of your post . Cory's solution is your best bet for this type of operation. Although, I'm surprised your code is causing memory issues with an array that size, even if you are using the inefficient delete from array within a loop. If you post your code some more suggestions can be offered.

[dt1804]

I am sorry, that's is exactly what I have tried, but if I don't transpose the array first I get the "not enough memory" error.

[Cory_K]

---

@dt1804 wrote:

I am sorry, that's is exactly what I have tried, but if I don't transpose the array first I get the "not enough memory" error.

---

If it wouldn't be a problem for you, would you mind posting your code so we can see  exactly what you are trying?

[GregFreeman]

Again, please post the code.

[dt1804]

Here is the code.   The files it asks for can be any long rowed files.

thanks

[GregFreeman]

Blah, I don't have 2010 installed yet. 3 Options, 

1. post a screenshot

2. wait for someone to come along with 2010 (which will be pretty soon I'm sure), or

3. save it back to 2009 and I'll take a look at it.