OpenEMM Technical Support Forum

Hi, I have 10,000,000 of recipients and it took forever when you browse the list. The problem is poorly designed sub-query like: SELECT COUNT(*) FROM ( SELECT .... <-- ORIGINAL QUERY ) AGN So what I did is the next: ReceipentDaoImpl.java public PaginatedList getRecipientList( String sqlStatementForC...