Faster queries from Google spreadsheet

I have a Google spreadsheet with 7000 rows and 12 columns. I want to get data using a basic AJAX request.

url = "https://spreadsheets.google.com/feeds/cells/"+key+"/od6/public/basic?alt=json-in-script&callback=?";
$.getJSON(url, function(resp) {  
    console.log(resp)
});

      

The problem is that this request is taking over 8 seconds. However, if I load the data into Google Fusion Sheets, I get the data within a second with the appropriate AJAX request.

enter image description here

The request size from Google Spreadsheet is causing me problems. 19MB? Is there a reasonably efficient way to get data from a large table?

+3


source to share


1 answer


Not really. As far as I can tell, you are doing it right.



0


source







All Articles