I’m having major performance issues (model freezes, long calc time, lots of lost session and etc.) The problem seems to be from the external object, we saw that after we remove this object the model runs very good no lost session and etc. Also tried to move the object to another sheet/ tab in order to improve the performance but still as long as the external object is in the model we experience bad performance even through its not used and no calculations should be done.
Could it be that the external object keeps on running throughout the whole time the model is up? And it eats up all the resources? How could I check this? How can I see the calc time for the external object?
if you mean an extension object, than it gets its data every time the page is refreshed/redrawn.
Think of your extension object like a straight table. All the data within is transferred every time.
As far as i know you can't measure the performance like on standard objects.
But you could use Firebug on Firefox or the built in development tools in IE/Chrome to show things like loading time for the page etc. to hunt the problem down.
