search

google / google-visualization-issues

288 stars 35 forks source link

Google Spreadsheet query performance #880

Open orwant opened 9 years ago

orwant commented 9 years ago 
What would you like to see us add to this API?
I'd like to be able to query a Google Spreadsheet of say 5000 lines without waiting
for long seconds for a simple request (select A,B where B='x') that fetches say 10
lines.
Can I set an index? Are indexes automatically created every now and then? No indexes?

What component is this issue related to (PieChart, LineChart, DataTable,
Query, etc)?
Google Spreadsheets API.

*********************************************************
For developers viewing this issue: please click the 'star' icon to be
notified of future changes, and to let us know how many of you are
interested in seeing it resolved.
*********************************************************

Original issue reported on code.google.com by marc.lucchini on 2012-04-19 22:48:07

orwant commented 9 years ago 
Totaly agree with poor performance of query. I will be pleased if I can use query_sorted
witch works faster but only on data sorted by search key.

Original issue reported on code.google.com by zbyloo on 2012-06-12 08:46:07