3 answers
I have used 'Visualforce Remote Object' concept in that example page. Retrieve method in Visualforce remote object will support only 100 records in a single request, if you want to fetch more rows, submit additional requests by using the OFFSET query parameter.Note that the maximum offset allowed is 2,000. Check this link for using offset in visualforce remote object http://peterknolle.com/infinite-scroll-with-visualforce-remote-objects/ You can also use Javascript remoting concept to retrieve the record from controller class and get the result in javascript. https://developer.salesforce.com/docs/atlas.en-us.pages.meta/pages/pages_js_remoting_example.htm
