🙂 this is a dynamic query. Data is not big returning 10-20 rows and total data in tables should not be more than 1000 rows,

As I mentioned this is nothing...

Because that is not required, I know that the problem is in where statemenet, we are using too many optional parameters and they are causing problem. We have fixed it...