jdoran Posted July 2, 2014 Posted July 2, 2014 Has anyone else experienced significant performance hits when dealing with large tables in their models? One of my tables has a bit over 230k rows. Since adding the table the model can take up to 30seconds to save (on a SSD), and since closing the model, it no longer seems to load. I can see that tables are added directly into the model xml data which does not seem to make much sense.
jdoran Posted July 2, 2014 Author Posted July 2, 2014 Nice pick-up. I had completely forgotten about that. Let's see if that works.
jdoran Posted July 2, 2014 Author Posted July 2, 2014 Nope, the 64bit version still will not open the model with a massive data table (at least not within the 5mins I was willing to wait for it). I left the model opening over night (via the 32bit client), and came in this morning to it opened. I have removed the datatable, and will have to explore using a database, etc.
Recommended Posts