I've observed a performance issue while utilizing the database notification feature. When dealing with a substantial number of notifications, approximately 1,000, the application tends to slow down and become unresponsive.
is there any way to handle it by adding pagination or any other approach