I have a sheetnode with 8 columns of lookups filled down about 500 rows.
Needless to say, the calc times for the page is pretty darn slow.
Is there a way to speed up calc by executing/calculating only the row changed (i.e get the coords of the cell changed and only calc that row)? Or perhaps there is a way to set it up such that calcs are only run manually (or on save)?
I've modified my lookups with a preceding IF (=IF(A4="","0",VLOOKUP(A4,"view_rta/all"!$A$1:$S$10000,9,FALSE))), however this has only saved me a littled bit of calc time.
I also noticed this in socialcalc-3.js, is there a way to bypass any politeness the calc routine may have?
if (((new Date()) - starttime) >= sci.maxtimeslice) { // if taking too long, give up CPU for a while
sci.timerobj = window.setTimeout(function() { SocialCalc.SheetCommandsTimerRoutine(sci); }, sci.timerdelay);
return;
}
}
Comments
Comment #0.0
ydahitypo
Comment #1
infojunkieCan you share your spreadsheet with me? That would allow me to make experiments on enhancing the performance.
You can always modify the value of
SocialCalc.SheetCommandInfo.maxtimesliceand see how that works out, but expect a degradation in the responsiveness of the UI. Please let me know what you find there.Comment #2
ydahiLarge spreadsheet attached. Columns C, D, K:Q have VLOOKUP formulas (eg: =VLOOKUP(A4,"ssview/all"!$A$1:$R$10000,9,FALSE))
The lookups aren't included in the export - I can give you access to the dev environment if you'd like.
Thanks for your time.
Comment #3
infojunkieThanks, but the spreadsheet you sent only has few rows of data. I'm not sure how I should replace the #N/A cells.
If you prefer, you can contact me privately to give me access to the dev environment.
Comment #4
ydahimessage sent - i've set you up with ssh access to the dev environment. thanks for your help infojunkie.
Comment #4.0
ydahiammendment