{"action":"created","issue":{"url":"https://api.github.com/repos/manahl/arctic/issues/69","labels_url":"https://api.github.com/repos/manahl/arctic/issues/69/labels{/name}","comments_url":"https://api.github.com/repos/manahl/arctic/issues/69/comments","events_url":"https://api.github.com/repos/manahl/arctic/issues/69/events","html_url":"https://github.com/manahl/arctic/issues/69","id":123745335,"number":69,"title":"tickstore query slowly","user":{"login":"zoe0316","id":3760090,"avatar_url":"https://avatars.githubusercontent.com/u/3760090?v=3","gravatar_id":"","url":"https://api.github.com/users/zoe0316","html_url":"https://github.com/zoe0316","followers_url":"https://api.github.com/users/zoe0316/followers","following_url":"https://api.github.com/users/zoe0316/following{/other_user}","gists_url":"https://api.github.com/users/zoe0316/gists{/gist_id}","starred_url":"https://api.github.com/users/zoe0316/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zoe0316/subscriptions","organizations_url":"https://api.github.com/users/zoe0316/orgs","repos_url":"https://api.github.com/users/zoe0316/repos","events_url":"https://api.github.com/users/zoe0316/events{/privacy}","received_events_url":"https://api.github.com/users/zoe0316/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-12-24T01:47:22Z","updated_at":"2015-12-25T10:06:24Z","closed_at":null,"body":"Arctic said that can query millions of rows per second per client, but when I try to use it in our team, and found that it only thousand of rows per second, Here the code, Does anyone got the same problem or  I use it with wrong way.\r\n\r\n```shell\r\n    @property\r\n    def arctic(self):\r\n        if not self._arctic:\r\n            log.info(\"init arctic\")\r\n            mongo_conn = MongoDB()\r\n            self._arctic = Arctic(mongo_host=mongo_conn.client)\r\n            library = self._arctic.list_libraries()\r\n            if self.tick_db not in library:\r\n                self._arctic.initialize_library(self.tick_db, lib_type=arctic.TICK_STORE)\r\n            if self.bar_db not in library:\r\n                self._arctic.initialize_library(self.bar_db, lib_type=arctic.TICK_STORE)\r\n        return self._arctic\r\n    \r\n...\r\n# res is a dict of tick data\r\nindex = self.int_to_date(tick_time)\r\ndata = pd.DataFrame(res, [index])\r\nself.arctic[self.tick_db].write(symbol, data)\r\n\r\n...\r\n\r\n>>> now = time.time(); ac['tick'].read('IF1601', date_range=dr); print(time.time() - now)\r\nOutput：\r\n[4021 rows x 26 columns]\r\n3.56284999847\r\n```\r\n\r\nthanks.\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/manahl/arctic/issues/comments/167218389","html_url":"https://github.com/manahl/arctic/issues/69#issuecomment-167218389","issue_url":"https://api.github.com/repos/manahl/arctic/issues/69","id":167218389,"user":{"login":"femtotrader","id":5049737,"avatar_url":"https://avatars.githubusercontent.com/u/5049737?v=3","gravatar_id":"","url":"https://api.github.com/users/femtotrader","html_url":"https://github.com/femtotrader","followers_url":"https://api.github.com/users/femtotrader/followers","following_url":"https://api.github.com/users/femtotrader/following{/other_user}","gists_url":"https://api.github.com/users/femtotrader/gists{/gist_id}","starred_url":"https://api.github.com/users/femtotrader/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/femtotrader/subscriptions","organizations_url":"https://api.github.com/users/femtotrader/orgs","repos_url":"https://api.github.com/users/femtotrader/repos","events_url":"https://api.github.com/users/femtotrader/events{/privacy}","received_events_url":"https://api.github.com/users/femtotrader/received_events","type":"User","site_admin":false},"created_at":"2015-12-25T10:06:24Z","updated_at":"2015-12-25T10:06:24Z","body":"Let's use same file for benchmarking https://drive.google.com/file/d/0B8iUtWjZOTqla3ZZTC1FS0pkZXc/view?usp=sharing\r\n\r\nsee also https://github.com/pydata/pandas-datareader/issues/153"}}