{"action":"opened","issue":{"url":"https://api.github.com/repos/SoftInstigate/restheart/issues/51","labels_url":"https://api.github.com/repos/SoftInstigate/restheart/issues/51/labels{/name}","comments_url":"https://api.github.com/repos/SoftInstigate/restheart/issues/51/comments","events_url":"https://api.github.com/repos/SoftInstigate/restheart/issues/51/events","html_url":"https://github.com/SoftInstigate/restheart/issues/51","id":109793482,"number":51,"title":"Improving performance querying a larger set of documents.","user":{"login":"Happy-Ferret","id":1962554,"avatar_url":"https://avatars.githubusercontent.com/u/1962554?v=3","gravatar_id":"","url":"https://api.github.com/users/Happy-Ferret","html_url":"https://github.com/Happy-Ferret","followers_url":"https://api.github.com/users/Happy-Ferret/followers","following_url":"https://api.github.com/users/Happy-Ferret/following{/other_user}","gists_url":"https://api.github.com/users/Happy-Ferret/gists{/gist_id}","starred_url":"https://api.github.com/users/Happy-Ferret/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Happy-Ferret/subscriptions","organizations_url":"https://api.github.com/users/Happy-Ferret/orgs","repos_url":"https://api.github.com/users/Happy-Ferret/repos","events_url":"https://api.github.com/users/Happy-Ferret/events{/privacy}","received_events_url":"https://api.github.com/users/Happy-Ferret/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-10-05T13:14:30Z","updated_at":"2015-10-05T13:14:30Z","closed_at":null,"body":"Using RESTHeart as API server for a custom Windows 8.1 product search app, I ran into the following issue:\r\n\r\nThe landing page of the app is supposed to show all products at once, represented by gridview items (until the user either filters for more refined results or uses the searchbar). \r\n\r\nThis works rather well with a small dataset of 100 documents. However, the full product catalog is currently at 873 documents. \r\n\r\nLoading the full catalog using the following query, it takes 8.1 seconds to load the landing page.\r\n\r\n```/DB/COLL?filter={\"name\":{$regex:\"\" , $ne:null}}&keys={\"name\":1,\"ID\":1}&pagesize=1000```\r\n\r\nIs there any way to speed this up? Any configuration switch I might want to try (I'm using the default yaml that shipped with v0.10.4) ? I'm hoping for 3 seconds, at the most. "}}