optimized the partner list fetch query and added cache support