I haven't tried creating a performance recording. There are no calculations, this dataset just contains a row entry for restaurant health inspections.
The columns are pretty standard stuff,
Odd, definitely try the perf rec
And can you send a screen shot of your pill arrangement?
After running some perfmon logging, I found that application was actually running out of ram. I was very surprised to see 30MB of data was turning in to 3GB+ in RAM. Even after I corrected the issue, I'm still seeing it go up to 2GB+. I have 64GB of ram, 64bit support would be a big help here.
I did some troubleshooting and figured out that some duplicate entrees were causing issues with joining. Every cell it joined in one column was being multiplying by another column, instead of adding the sum. For example instead of getting 15 + 15 = 30 cells, I was getting 15 x 15 = 225 cells.
Thank you for recommending the Performance Recording, it was a big help. =)