Hi All,
I have run into an odd situation and I am a bit lost as to where to go next with troubleshooting, any advice would be greatly appreciated!
I created a BAQ that is fairly large with 3 subqueries but in the BAQ Designer, it runs fairly quickly. My issue is when I try to load this BAQ in a dashboard with any values passed through a where clause, it slows down incredibly. I have tried to set up filters in a few different locations in application studio and I haven’t had any luck figuring out why the app studio or the query would be running slower when I narrow down the results than it does without.
In application studio I have the dashboard set up with two grid, a tracker with 3 combo-boxes and two buttons (Search and Reset Search). In my main grid I initially set up the provider model to call the BAQ, turned off Auto Load Grid/Auto Refresh grid On Load and connected my 2 combo-boxes to the associated fields in the BAQ Options Where List. Then set up my search button to call the grid-refresh event to load the data when the user was ready to load data. When I open the dashboard, not enter any values into the combo-boxes and just click search, the BAQ does load noticeably slower but it finishes in a reasonable time (less than a minute typically). The second I add in one value into my tracker the BAQ takes minutes to load.
I have also tried to use kinetic-baq and the BAQ Execute Options Where field to connect my tracker fields instead of the grid-refresh in my search event, but this seems to have not improved the speed.
Has anyone else experienced something like this? Or have any advice to alternative methods of applying filters to a grid?