topic Re: Memory Issues after joining tables in Discussions

Memory Issues after joining tables

AdditiveRange10 — Wed, 18 Dec 2024 18:59:01 GMT

Hello All,

Very frustrating issue here. I perform a join of two tables. Both tables are small, about 9-10 rows and 40 columns. The join completes successfully with this code.

dt_join = dt1 << (With(dt2), Merge Same Name Columns, By Matching Columns(:col1 = :col1, :col2=:col2), Include Nonmatches(1,1), Preserve main table order(1));

If I run any code after that there are no issues. My total memory with just Chrome and File explorer and JMP is about 10%. However, if I try to do anything with the newly joined table the whole JMP app becomes unresponsive and has to be force closed.
Additionally, I had also tried (my ultimate goal) to join the joined table with one more table to yield a final joined table of 3 tables and when I attempt that I also get an unresponsive app and my memory usage goes to 99% and after some time I get a "unable to allocate memory message".
Here is my memory makeup under normal usage with JMP on but no actions taken on the joined table

Any thoughts or possible solutions. This is incredible frustrating.

Re: Memory Issues after joining tables

jthi — Wed, 18 Dec 2024 19:10:30 GMT

Have you contacted JMP Support?

Re: Memory Issues after joining tables

AdditiveRange10 — Wed, 18 Dec 2024 19:15:26 GMT

I think I see what the issue is. Each of the tables has 9-10 rows of images (from saving a table with graphs option). Working with each individual table by itself is quite alright but when joining them and now there is ~20 images I guess causes some memory issue. I removed the images and was able to do the three way join.

Either way, that seems like an action that should not completely hamstring a computer's memory especially with 64Gb RAM.
I might still contact support