none
How to use large amount of data? RRS feed

  • Question

  • I have a dataset of 500,000 rows. When I use javascript it hangs. How can I quickly store the data and retrieve?

    function getValue(strA, strB){
    
    	if (strA == "aa" && strB == "bb") {return 82;}
    	if (strA == "bb" && strB == "aa") {return 82;}
    
    	if (strA == "cc" && strB == "dd") {return 83;}
    	if (strA == "dd" && strB == "cc") {return 83;}
    
    	if (strA == "ee" && strB == "dd") {return 85;}
    	if (strA == "dd" && strB == "ee") {return 85;}
    
    	if (strA == "ff" && strB == "bb") { return 90; }
    	if (strA == "bb" && strB == "ff") { return 90; }
    
    }

    • Edited by Pacecal Friday, August 12, 2016 1:47 PM
    Friday, August 12, 2016 1:43 PM

Answers

  • Hi Pacecal,

    Do you use large amount data in Office Add-ins? If so, you could try apply paging when reading the data or web workers. For more information, you could refer the link below.

    # Resource limits and performance optimization for Office Add-ins

    http://dev.office.com/docs/add-ins/develop/resource-limits-and-performance-optimization

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    • Marked as answer by Pacecal Saturday, August 13, 2016 12:10 PM
    Saturday, August 13, 2016 7:42 AM