I have a very long dropdown - nearly 400 items. Yes not a nice design but unfort

joel over 12 years ago

I have a very long dropdown - nearly 400 items. Yes not a nice design but unfortunately I am tied to this constraint and cannot change it. At the moment I have a nested rule which is deciding which constant to look up out of possible 18. I have transferred the data to a database and then changed the rule to call a query rule based on variable. However the performance is noticeable different the same rule is taking 3-4 seconds to return the result for the largest dataset. I have also tried to do the same based on a integer but the performance is the same. Is there anything anyone can recommend to get this working pulling from the db rather than constants quicker? I want it in the DB so it can be regularly updated and is scalable where the current every time we want to add a new ‘type’ we need to add a new set of constants....

Discussion posts and replies are publicly visible

0 shelzle over 12 years ago

Are you able to load the data in parallel to the process itself?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 joel over 12 years ago

I have thought about that but I don't really want the data in process to keep it as light as possible. Plus they will need to be updated regularly as required.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jorgea272 over 12 years ago

What about having a separate process that updates constants on a scheduled basis?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 joel over 12 years ago

Yeah, I think I might have to go with a pro, but I was really hoping to get rid of these constants for db values.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Christine
Appian Employee
over 12 years ago

Are you querying a single entity (table) or a view? What type of filters do you allow for the query rule and are there indexes on those columns where possible?
Have you also tried using the Query RDBMS node and seen if performance is different?
I would also take a look at the DB perf logs to see what in the query execution is taking the longest.
Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 joel over 12 years ago

Thanks Christine, I added a Index over the column and that seemed to dramatically improve performance of the dropdown.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel