Speed Up Table Filters
We have 3 models, 2 are aggregate for use with Charting and the third is a basic chart for pulling specific report related data. We have a Tab Set and use the Picklist function. The two charts draw pretty much immediately, but the table takes about 30 seconds to display. It is obviously using a selection criteria that returns 66 records from a thousand or so. The we have a filter that allows the user to filter by Category. If you change the filter is takes a minimum of 50-60 seconds to re-display the information. I know that using the aggregate model will allow SF to do the processing and basic brings the record set down to the end user, but this is quite un-usable. Can you have an aggregate model and still bring fields into the table that are not defined as aggregations?