title: select RID takes forever in Orientdb
body: <p>I am new to Orientdb, and just downloaded the latest Mac OS version, created a new databases, and created a new class named Person, which contains a first name and a last name.</p>
  
  <p>Then I created 1,000,000 fake users to test the speed. However, when I run the query</p>
  
  <blockquote>
    <p>select RID from Person offset 999999</p>
  </blockquote>
  
  <p>The process rans 67.569 seconds!</p>
  
  <p>Following is the screen shot:
  <img src="https://i.stack.imgur.com/gQjAV.png" alt="enter image description here"></p>
  
  <p>I have 2 questions:</p>
  
  <p>1) Why does it take sooooo long..</p>
  
  <p>2) Why is the result "#-2:1" rather than "#11:1000000"? (11 is the index of my Person class)</p>
  
  <hr>
  
  <p>Updated</p>
  
  <p>Now I noticed I should query for pagination like</p>
  
  <pre><code>SELECT FROM Person WHERE @rid &gt; #11:999998 LIMIT 2
  </code></pre>
  
  <p>But it still takes 8.224s on my Macbook Air. Is it normal?</p>