improved performance of subscription report