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

[#1]

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.

[#2 · Accepted solution]

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

[#3]

Thanks Jeff Perkinson.

As requested, please find the details below,

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

-------> The JMP processes the data table and then crashes without performing any operation

Do you get an error message?

--------> No error message was displayed

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

--------> Windows 7 and JMP 11

How much memory do you have?

--------> RAM is 4 GB and 2.91 GB of usable memory

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

------->  32-bit

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

-------> The data has both numeric and character values but mostly they are numeric

[#4]

I would use:

Windows 7 64-bit

JMP 11 64-bit

More RAM.  32-bit apps can't address more than 2GB of ram.  If you are using Win7 64-bit Professional the max amount of RAM is 192GB.

Jeff what is the configuration of John Sall's PC that he uses to open up those huge datasets?

[#5 · Accepted solution]

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