12-20-2016 11:44 AM
HI ALL!
I have a very big variables table with much IF to drive
a lot of numbers, and every time i make a variation on a line
it takes a lot of time to re evaluate every thing,
do some one knows if and how can i
speed all this??
thank y so much
12-20-2016 12:04 PM
Try turning off automatic update on the tools tab.
12-20-2016 02:21 PM
Get a faster computer.
12-21-2016 02:50 AM
I don't know if really this is the problem..
i have an i7-6700 cpu 3.40GHz with 32 GB of RAM
and a a GEFORCE GTX 750 ti WITH 2GB of memory.
my SE file is only 3,2 MB, but has something like 200 variables
and every time ai change a line
or a simple cell or add a new one
it takes 20-25 sec for refreshing every thing.
I would like to know if there is some settings where
to decide if and when let SE do the refreshing
thank you again
12-22-2016 09:12 AM
So the Automatic Update setting seems to help when working with Excel files linked to the variable table.
It also helps when editing dimensions directly.
It does not help when working in the Variable Table itself.
Maybe you should call that in to your reseller to file an IR so we can make the software better.
12-22-2016 10:18 AM
In general, I only have the variable open when they need to be edited. Having the variable tabel open at all really slows things down. Close the variable window and updates are much faster.
12-23-2016 05:58 PM
Thank you for your responses!
I found that if opened through an assembly
my 200 user variables are much faster to edit.
I could write all the rules (trigonometrics and IF statements) of my sheet file
In an excel, but i pointed to give the main part of intelligence to
SE (and also because really it's much simple)
I worked calculating all necessary in user variables part
and finally giving the elaboration to quotes and suppressions.
Im now trying to transfer a part of this work to a .bas file with VB.
Will let you know
Thanks again