Dashboard become unresponsive

That's true, if you are still fetching those tens of thousands of records from the database then that is a lot of work.