Reuse of custom queries in workspace

If you reuse one custom query for each table to generate data for all views in a workspace, you can reduce demand on system resources.

You want views to use the same custom query even if, for example, a graph view uses one attribute and a table view uses another attribute. If you create a unique query for each view, you increase:

• The workload of the monitoring agent to collect the data
• The demand on system resources

What works best is to use one query for each table in a workspace shared by all views within that workspace. The custom queries that you create must retrieve all the columns and rows that are required to populate all the views with data in your workspace. If you have many tables and charts that use different queries, the entire set of results for each query is stored on the IBM® Enterprise Portal Server. IBM Enterprise Portal client stores:

• 100 rows (default page size) from each query that is currently being viewed
• Previous page of any view