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.

Please rate this