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;
         }
      }
CommentFileSizeAuthor
#2 large-sheetnode.xls51.5 KBydahi

Comments

ydahi’s picture

Issue summary: View changes

typo

infojunkie’s picture

Can 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.maxtimeslice and see how that works out, but expect a degradation in the responsiveness of the UI. Please let me know what you find there.

ydahi’s picture

StatusFileSize
new51.5 KB

Large 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.

infojunkie’s picture

Thanks, 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.

ydahi’s picture

message sent - i've set you up with ssh access to the dev environment. thanks for your help infojunkie.

ydahi’s picture

Issue summary: View changes

ammendment