How to limit the record in database view

[Community Alums]

Hi all,

We created one database view with 5 tables the databaseview containing more than 90,00000 records so we are not able to create report using that database view is there any way to load the report faster.

Thanks

[Ankur Bawiskar]

@Community Alums 

after applying database view how much is the count?

[Community Alums]

Hi @Ankur Bawiskar 

Thanks for the reply after applying database view  around 30 lakhs record.

Thanks,

[Ankur Bawiskar]

@Community Alums 

did you try to use table level READ ACL?

but based on what condition/logic you want to restrict the records?