I have klips running from SQL data and wondered what is faster/best practice :
a) to have the query/datasource filter the data by using user input fields to reduce the data that is queried
b) Have the klip filter all of the data while it is being used
To give an example, I have data for different client sites and have a user input to select the client group and/or site group. Is it better to filter the data to only query the client or site details; or to bring in all the data and let the klip table/chart filter to the correct result.
I'm using option a) as it felt the logical thing to do; however I'm after any suggestions on how to make SQL queries faster and more efficient.