I'm looking for some guidance and suggestions on best practices for custom data retrieval sets in landing pages.
I have a fairly computation intensive View (GESAVW) that I've created that I want to layer into a landing page widget. The context of the query is not really relevant to the discussion but here is a redacted screen shot of it for demonstration purposes. This query will return results in SSMS in less than 3 seconds.
My first implementation of this was to implement the view in X3 then create a query based on that view in GESALH. Then create a menu item of link type 'query' and add it to a landing page. This works and retrieves the results very fast, but the grid isn't sortable or filterable, and i can't seem to find anyway in this implementation model to enable such features.
My next implementation was to create a Class (GESACLA) model based on this View, then create a Representation (GESASW) of said class with the Filter P and Query facets enabled on each resultant field. Then create a menu item of link type 'Representation' and embed it into a landing page.
This "works" sort of. The data is return with sorting and filtering enabled on the grid.
The issue is that same data set that runs in under 3 seconds directly on the DB takes upwards of 30 seconds to return in the Representation. Additionally each attempt to sort and / or filter seems, on face at least, to require a return trip to the db to pull the results again. Because of the lag its very easy to queue up several commands that cause the page to eventually lock and crash the session. This is just with one user calling a single widget on one page so obviously this isn't workable as it is in a live deployment scenario.
I guess my question is:
- Is there a more efficient methodology in the Class / Representation model, setup and config-wise, to retrieve a view-based data set for sorting and filtering?
or
- Is there a way to ad sorting / filtering to a query-based object of that view?
or
- Is there an entirely different approach to the end result im not thinking of that would be a much better way of achieving the goal at hand?
Thank you,
Ben Turner
