1. 14 May, 2013 1 commit
  2. 08 May, 2013 2 commits
  3. 05 May, 2013 4 commits
  4. 28 Apr, 2013 2 commits
  5. 27 Apr, 2013 2 commits
  6. 24 Apr, 2013 1 commit
  7. 23 Apr, 2013 2 commits
  8. 17 Apr, 2013 2 commits
  9. 16 Apr, 2013 3 commits
  10. 08 Apr, 2013 1 commit
  11. 07 Apr, 2013 1 commit
  12. 04 Apr, 2013 2 commits
  13. 03 Apr, 2013 3 commits
  14. 01 Apr, 2013 2 commits
  15. 28 Mar, 2013 3 commits
  16. 27 Mar, 2013 5 commits
  17. 26 Mar, 2013 3 commits
    • Serge S. Koval's avatar
      Merge pull request #198 from brAzzi64/row_count_performance · d0f63e8e
      Serge S. Koval authored
      Fix for performance issue when calculating total row count for paging
      d0f63e8e
    • Bruno Azzinnari's avatar
      Fix for a performance issue when getting the total row count when implementing... · 45a27235
      Bruno Azzinnari authored
      Fix for a performance issue when getting the total row count when implementing paging. When dealing with about 250.000 rows, it was taking about 30 secs to show one page on the first load. With this modifications it executes almost instantly.
      
      The problem was that the query applying .count() to the current query generated the SQL:
      
      SELECT count(*) AS count_1
      FROM ( SELECT ModelView-columns FROM ModelView-table WHERE conditions ) as anon_1;
      
      which made it actually get all the data in the inner query for then counting the rows and returning the amount. With this modification, the generated query is:
      
      SELECT count(*) AS count_1
      FROM ModelView-table
      WHERE conditions;
      
      that executes instantly.
      45a27235
    • Serge S. Koval's avatar
      Don't use fixed navbar · 2fd4880a
      Serge S. Koval authored
      2fd4880a
  18. 25 Mar, 2013 1 commit