Maximum amount of data that can be opened as a data table in JMP 11

Question

I have .CSV file that is approximately of 500MB in size and has 8 to 9 million of data. I am unable to open it in JMP 11.

Can anyone inform if there is any limit to amount of data that we can import as a data table in JMP11.

Also, please suggest a work around.

Jeff_Perkinson · Accepted Answer

JMP is limited only by the amount of memory that you have on your machine. Since we hold the whole data table in memory we have to have enough memory to do that.

Tech Support is the best place to go to figure out whether JMP can work with the file in question.

But, if you want to pursue it here, we'll need some more information.

Can you give us some more details about what happens when you try to open this file?

Do you get an error message?

What kind of machine are you using? Windows or Macintosh?

How much memory do you have?

Are you using 32-bit JMP or 64-bit JMP?

Is this data in this file mostly numeric or mostly character?

These are the same kinds of questions Tech Support will have, so if you contact them, be sure to include these details.

-Jeff

Jeff_Perkinson · Accepted Answer

I agree here.

I think you're running out of memory. I wish JMP wasn't crashing for you in this case.

As PMroz points out, the amount of memory that the 32-bit version can access is limited.

The 64-bit version of JMP can access all the memory available on your machine.

-Jeff