August 26, 2017
How to handle large data size?
When creating a new data provider, it may return below error, if your query returns too many rows of record.
You can either:
1. Limit the number of returning records by, e.g. SELECT * FROM sales order by creation_date desc limit 10000
=> You may use this way, if your query just need to show the latest data, e.g. the last 7 days data.
2. Or, you can add required filtering clause(s) into your query, like:
SELECT * FROM sales
WHERE {sql_condition, required, country, country}
AND {sql_condition, required, source, source}
=> This query will return data, after user has provided filtering values. So, in this case, the returning data size will be smaller.