{"action":"created","issue":{"url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/659","repository_url":"https://api.github.com/repos/NLPchina/elasticsearch-sql","labels_url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/659/labels{/name}","comments_url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/659/comments","events_url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/659/events","html_url":"https://github.com/NLPchina/elasticsearch-sql/issues/659","id":321115139,"number":659,"title":"elasticsearch-sql 如何处理深分页问题， 本身支持吗？","user":{"login":"8plat","id":8413679,"avatar_url":"https://avatars3.githubusercontent.com/u/8413679?v=4","gravatar_id":"","url":"https://api.github.com/users/8plat","html_url":"https://github.com/8plat","followers_url":"https://api.github.com/users/8plat/followers","following_url":"https://api.github.com/users/8plat/following{/other_user}","gists_url":"https://api.github.com/users/8plat/gists{/gist_id}","starred_url":"https://api.github.com/users/8plat/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/8plat/subscriptions","organizations_url":"https://api.github.com/users/8plat/orgs","repos_url":"https://api.github.com/users/8plat/repos","events_url":"https://api.github.com/users/8plat/events{/privacy}","received_events_url":"https://api.github.com/users/8plat/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-05-08T09:44:13Z","updated_at":"2018-05-08T14:51:29Z","closed_at":null,"author_association":"NONE","body":"根据条件筛选完毕后 有 40万数据，我需要分页取出，因为存在深分页的问题后面的查询越来越慢。最后一页基本查询不出来。\r\nSELECT * FROM member_info  where  IS_PASS_MESS_VERT = '1'  AND APPLY_TYPE ='10' \r\nLIMIT 399990,400000\r\n\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/comments/387429599","html_url":"https://github.com/NLPchina/elasticsearch-sql/issues/659#issuecomment-387429599","issue_url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/659","id":387429599,"user":{"login":"leonlu001","id":7520087,"avatar_url":"https://avatars3.githubusercontent.com/u/7520087?v=4","gravatar_id":"","url":"https://api.github.com/users/leonlu001","html_url":"https://github.com/leonlu001","followers_url":"https://api.github.com/users/leonlu001/followers","following_url":"https://api.github.com/users/leonlu001/following{/other_user}","gists_url":"https://api.github.com/users/leonlu001/gists{/gist_id}","starred_url":"https://api.github.com/users/leonlu001/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/leonlu001/subscriptions","organizations_url":"https://api.github.com/users/leonlu001/orgs","repos_url":"https://api.github.com/users/leonlu001/repos","events_url":"https://api.github.com/users/leonlu001/events{/privacy}","received_events_url":"https://api.github.com/users/leonlu001/received_events","type":"User","site_admin":false},"created_at":"2018-05-08T14:51:29Z","updated_at":"2018-05-08T14:51:29Z","author_association":"NONE","body":"Es有限制，只给前10万条数据，你可以增加查询条件，或者时间切片查询。发自我的华为手机-------- 原始邮件 --------主题：[NLPchina/elasticsearch-sql] elasticsearch-sql 如何处理深分页问题， 本身支持吗？ (#659)发件人：8plat 收件人：NLPchina/elasticsearch-sql 抄送：Subscribed 根据条件筛选完毕后 有 40万数据，我需要分页取出，因为存在深分页的问题后面的查询越来越慢。最后一页基本查询不出来。\r\nSELECT * FROM member_info  where  IS_PASS_MESS_VERT = '1'  AND APPLY_TYPE ='10'\r\nLIMIT 399990,400000\r\n\r\n—You are receiving this because you are subscribed to this thread.Reply to this email directly, view it on GitHub, or mute the thread.\r\n\r\n\r\n  \r\n  \r\n\r\n\r\n\r\n\r\n{\"api_version\":\"1.0\",\"publisher\":{\"api_key\":\"05dde50f1d1a384dd78767c55493e4bb\",\"name\":\"GitHub\"},\"entity\":{\"external_key\":\"github/NLPchina/elasticsearch-sql\",\"title\":\"NLPchina/elasticsearch-sql\",\"subtitle\":\"GitHub repository\",\"main_image_url\":\"https://cloud.githubusercontent.com/assets/143418/17495839/a5054eac-5d88-11e6-95fc-7290892c7bb5.png\",\"avatar_image_url\":\"https://cloud.githubusercontent.com/assets/143418/15842166/7c72db34-2c0b-11e6-9aed-b52498112777.png\",\"action\":{\"name\":\"Open in GitHub\",\"url\":\"https://github.com/NLPchina/elasticsearch-sql\"}},\"updates\":{\"snippets\":[{\"icon\":\"DESCRIPTION\",\"message\":\"elasticsearch-sql 如何处理深分页问题， 本身支持吗？ (#659)\"}],\"action\":{\"name\":\"View Issue\",\"url\":\"https://github.com/NLPchina/elasticsearch-sql/issues/659\"}}}"}}
{"actor":{"display_login":"leonlu001"}}