Implement limit and lazy loading mechanism for displaying result

[destan]

Paging for lazy loading
SELECT full_path FROM fs_index WHERE file_name MATCH 'html' order by full_path limit 0, 1000;