Hi Team,
In my application i am using one expression rule that fetches the data from database view,and that database view fetch the data from 4 tables and each table have different number of records(646183,2185098 ,159583,166000) , however when i go to database and open the view it's working fine but when comes to expression rule it's not working
Note: Previously we didn't face any issue as we didn't had much records and it was working well for load testing we inserting lakh's of records now it's not working.
Could you please suggest me a solution.
Thanks & Regards,
Prasad.
Discussion posts and replies are publicly visible
Database views are well known for becoming a performance problem with growing dataset sizes. I expect it to run into a timeout issue. The only way to solve this, is to speed up the view.
Another option is to use synced records on the base tables. But it very much depends on your actual use case.