title: Symfony: Pagination + Sorting?
body: <p>The pagination in Symfony is pretty straightforward and pretty good. However I'm looking for the best direction to go for adding in Sorting to the table.</p>
  
  <p>My thoughts are that the sorting column, direction and current page number are defined in the uri, like this:</p>
  
  <pre><code>http://www.mysite.com/backend_dev.php/articles/author/asc/3/
  </code></pre>
  
  <p>And then on each page, Symfony uses the uri to determine the current sorting column, direction and page and then manipulates all the pagination links to take those things into account so that when you click on a link to change pages or sort by a different column it takes you to the proper place.</p>
  
  <p>Does anyone have any other directions I could go with this? I know about the simplicity of jQuery's tablesorter plugin but it sucks when there are 1000+ records because you have to load them all at once to make that plugin work.</p>