Data base view

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.