Search found 1 match

by sparkiss
Wed Feb 22, 2012 8:23 pm
Forum: Suggestions
Topic: Slow Page Loading
Replies: 3
Views: 7669

Slow Page Loading

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...