Wed, 23/06/2010 - 04:38 — jvanclay
I've a student attempting an analysis of spatial interactions between trees, using a total of 20636 observations. This causes some problems. You can see for yourself by creating a csv file with 20636 random numbers, and attempting to read them into a variable with the table feature. Is there a limit on the size of tables - or a work around this challenge? Simile 5.6 on WinXP.
Thanks
Jerry
Reporter:
jvanclay
Created:
Wed, 23/06/2010 - 04:38
Updated:
Wed, 22/06/2011 - 23:03
Comments
#1
Hi Jerry,
There is a limit to the amount of data that can be stored on a table function but I don't know what it is. I know it is fine for handling smallish lookup tables which I think is what it was designed for.
If you need to handle a large dataset I'd use a file parameter. Actually, I've just checked the help and it does say
If you do not wish or need to store the data in the model, you can use a file parameter to access the data when the model is run. This is significantly quicker; so much so, that for extremely large data sets it is the only feasible approach.
http://www.simulistics.com/help/equations/table.htm
Instead of assigning the variable a table function in the equation dialog select the "Fixed parameter" radio button as the "Data source". You will be asked for the data when you run the model not in the equation dialog. Have a look at Working with external data.
#2