{"action":"created","issue":{"url":"https://api.github.com/repos/sergeyksv/tingodb/issues/54","labels_url":"https://api.github.com/repos/sergeyksv/tingodb/issues/54/labels{/name}","comments_url":"https://api.github.com/repos/sergeyksv/tingodb/issues/54/comments","events_url":"https://api.github.com/repos/sergeyksv/tingodb/issues/54/events","html_url":"https://github.com/sergeyksv/tingodb/issues/54","id":45698467,"number":54,"title":"How to do fast queries on big databases ?","user":{"login":"hems","id":27327,"avatar_url":"https://avatars.githubusercontent.com/u/27327?v=3","gravatar_id":"","url":"https://api.github.com/users/hems","html_url":"https://github.com/hems","followers_url":"https://api.github.com/users/hems/followers","following_url":"https://api.github.com/users/hems/following{/other_user}","gists_url":"https://api.github.com/users/hems/gists{/gist_id}","starred_url":"https://api.github.com/users/hems/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hems/subscriptions","organizations_url":"https://api.github.com/users/hems/orgs","repos_url":"https://api.github.com/users/hems/repos","events_url":"https://api.github.com/users/hems/events{/privacy}","received_events_url":"https://api.github.com/users/hems/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2014-10-13T23:55:38Z","updated_at":"2015-03-01T02:22:32Z","closed_at":"2014-10-14T07:18:37Z","body":"I have a huge database, with 200k+ entries, and would like to know if there is a fast way of querying it?\r\n\r\nI will be mainly doing \"search\" functions on it, like \"filtering\" by values in a given column that matches a regular expression.\r\n\r\nIs there a recommended way of dealing with such big db ?"},"comment":{"url":"https://api.github.com/repos/sergeyksv/tingodb/issues/comments/76564187","html_url":"https://github.com/sergeyksv/tingodb/issues/54#issuecomment-76564187","issue_url":"https://api.github.com/repos/sergeyksv/tingodb/issues/54","id":76564187,"user":{"login":"hems","id":27327,"avatar_url":"https://avatars.githubusercontent.com/u/27327?v=3","gravatar_id":"","url":"https://api.github.com/users/hems","html_url":"https://github.com/hems","followers_url":"https://api.github.com/users/hems/followers","following_url":"https://api.github.com/users/hems/following{/other_user}","gists_url":"https://api.github.com/users/hems/gists{/gist_id}","starred_url":"https://api.github.com/users/hems/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hems/subscriptions","organizations_url":"https://api.github.com/users/hems/orgs","repos_url":"https://api.github.com/users/hems/repos","events_url":"https://api.github.com/users/hems/events{/privacy}","received_events_url":"https://api.github.com/users/hems/received_events","type":"User","site_admin":false},"created_at":"2015-03-01T02:22:32Z","updated_at":"2015-03-01T02:22:32Z","body":"I'm trying to find out a way of getting fast first results, but it's not being so easy.\r\n\r\nA good start would be to be able to read then by \"_id\" without doing a full scan?\r\n\r\nOr do a find by \"_id\" and have thingodb reading just that part of the text file?\r\n\r\nany ideas?"}}