title: Spring MongoRepository pagination performance
body: <p>I am using spring boot base application ,its has get all record method with pagination</p>
  
  <pre><code>public interface AssignmentRepository extends MongoRepository&lt;Assignment, String&gt; {
  
  Page&lt;Assignment&gt; findBySectionIdAndDelete(String sectionId, Boolean delete, Pageable pageable); }
  </code></pre>
  
  <p>since this method execution  i notice some performance  degradation ,
  and i added some debug log and print mongo query </p>
  
  <pre><code>2016-02-08 17:40:08 DEBUG MongoTemplate:1635 - find using query: { "sectionId" : "55b1c4e3e4b0d89510c6aa27" , "delete" : false} fields: null for class: class com.era.core.domain.Assignment in collection: assignment
  </code></pre>
  
  <p>Assignment collection  indexes </p>
  
  <blockquote>
    <p>sectionId,delete</p>
  </blockquote>
  
  <p>My Questions is,
  Is this pagination happening on database or Application (Mongo Repository) level?  </p>