Link Details

Link 1056701 thumbnail
User 1059807 avatar

By acoin
via java.dzone.com
Published: Oct 28 2013 / 13:12

In order to understand the Seek Method, let’s first understand what problem it solves: SQL OFFSET clausesare slow. They’re slow for a simple reason. In order to reach a high offset from a result set, all previous records have to be skipped and counted.
  • 8
  • 0
  • 535
  • 891

Add your comment


Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.

Voters For This Link (8)



Voters Against This Link (0)



    Node.js
    Written by: Bert Belder
    Featured Refcardz: Top Refcardz:
    1. Design Patterns
    2. OO JS
    3. Cont. Delivery
    4. Java EE7
    5. HTML5 Mobile
    1. Debugging JavaScript
    2. OO JS
    3. JSON
    4. Ajax
    5. REST