Allow in Memory Parameter Filtering
If you check the Allow In Memory Parameter Filtering box, it is no longer necessary to manually add the parameter to the SQL query as shown below.
Instead the full query will be executed, and then filtered by Panopticon Designer (Desktop) to match the defined parameters.
This In Memory parameter filtering is more processor intensive and is designed for situations where the retrieved data sets are small but fast changing (typically less than 1000 rows).
For example, where there is a set of transactions that is to update every five seconds, and each transaction is associated with one of the 500 sales people:
Using the standard approach of filtering with the SQL WHERE clause causes 100 individual SQL queries to be performed every second.
Using the In Memory approach causes a single SQL query to be performed every five seconds.