title: order by field with more than 10000 ids
body: <p>I need to do specific ordering with use of order by field. </p>
  
  <pre><code>select * from table order by field(id,3,4,1,2.......upto 10000 ids)
  </code></pre>
  
  <p>As the ordering required is not gettable from SQL then how much it affect as per performance and is it feasible to do?</p>
  
  <p>Updates from the comments:</p>
  
  <ul>
  <li>Ordering depends on user and category IDs and can be anything the user wants.</li>
  <li>The ordering specification changes (about) daily.</li>
  </ul>
  
  <p>So, we need a custom ordering that depends on the user and category and this ordering needs to change daily.</p>