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