{"action":"created","issue":{"url":"https://api.github.com/repos/echothrust/echofish/issues/29","labels_url":"https://api.github.com/repos/echothrust/echofish/issues/29/labels{/name}","comments_url":"https://api.github.com/repos/echothrust/echofish/issues/29/comments","events_url":"https://api.github.com/repos/echothrust/echofish/issues/29/events","html_url":"https://github.com/echothrust/echofish/issues/29","id":120114287,"number":29,"title":"Open Archive is long","user":{"login":"geckeon","id":10884587,"avatar_url":"https://avatars.githubusercontent.com/u/10884587?v=3","gravatar_id":"","url":"https://api.github.com/users/geckeon","html_url":"https://github.com/geckeon","followers_url":"https://api.github.com/users/geckeon/followers","following_url":"https://api.github.com/users/geckeon/following{/other_user}","gists_url":"https://api.github.com/users/geckeon/gists{/gist_id}","starred_url":"https://api.github.com/users/geckeon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/geckeon/subscriptions","organizations_url":"https://api.github.com/users/geckeon/orgs","repos_url":"https://api.github.com/users/geckeon/repos","events_url":"https://api.github.com/users/geckeon/events{/privacy}","received_events_url":"https://api.github.com/users/geckeon/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/echothrust/echofish/labels/enhancement","name":"enhancement","color":"84b6eb"},{"url":"https://api.github.com/repos/echothrust/echofish/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":11,"created_at":"2015-12-03T08:03:30Z","updated_at":"2015-12-11T10:48:24Z","closed_at":null,"body":"Hello,\r\nThere could be made faster to open Archive ?\r\nBecause I have several millions of lines and it makes time.\r\nIt's possible to improve this or maybe create a task to delete log upper than 7 days, because truncate is steep.\r\nThere could be made possible to choose by default the numbers of online display in Syslog or Archive perhaps by using users setting. And in this setting i don't understand what is \"Salt\".\r\nThx for help.\r\nGeckeon."},"comment":{"url":"https://api.github.com/repos/echothrust/echofish/issues/comments/163907115","html_url":"https://github.com/echothrust/echofish/issues/29#issuecomment-163907115","issue_url":"https://api.github.com/repos/echothrust/echofish/issues/29","id":163907115,"user":{"login":"gadamo","id":5476464,"avatar_url":"https://avatars.githubusercontent.com/u/5476464?v=3","gravatar_id":"","url":"https://api.github.com/users/gadamo","html_url":"https://github.com/gadamo","followers_url":"https://api.github.com/users/gadamo/followers","following_url":"https://api.github.com/users/gadamo/following{/other_user}","gists_url":"https://api.github.com/users/gadamo/gists{/gist_id}","starred_url":"https://api.github.com/users/gadamo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gadamo/subscriptions","organizations_url":"https://api.github.com/users/gadamo/orgs","repos_url":"https://api.github.com/users/gadamo/repos","events_url":"https://api.github.com/users/gadamo/events{/privacy}","received_events_url":"https://api.github.com/users/gadamo/received_events","type":"User","site_admin":false},"created_at":"2015-12-11T10:48:24Z","updated_at":"2015-12-11T10:48:24Z","body":"@geckeon Please pull the latest changes from the master branch. The latest changes from @proditis, merged on #31, fix the issue.\r\n\r\nAfter pulling the latest changes, import the affected files:\r\n\r\n```\r\nmysql -u root ETS_echofish <  schema/echofish-procedures.sql\r\nmysql -u root ETS_echofish <  schema/echofish-events.sql\r\n```\r\n\r\nWith those in place, you can manually test the procedure any time:\r\n\r\n```\r\nCALL eproc_rotate_archive();\r\nSHOW WARNINGS;\r\n```\r\n\r\nNote: Those entries that have not yet been acknowledged (thus deleted from syslog table), will not be deleted from archive table either. Same applies for entries that are in-use for abuser evidence (in case you use this)."}}