{"action":"created","issue":{"url":"https://api.github.com/repos/baasbox/baasbox/issues/914","labels_url":"https://api.github.com/repos/baasbox/baasbox/issues/914/labels{/name}","comments_url":"https://api.github.com/repos/baasbox/baasbox/issues/914/comments","events_url":"https://api.github.com/repos/baasbox/baasbox/issues/914/events","html_url":"https://github.com/baasbox/baasbox/issues/914","id":122832658,"number":914,"title":"Enormous default.pcl file size","user":{"login":"Sprechen","id":10724424,"avatar_url":"https://avatars.githubusercontent.com/u/10724424?v=3","gravatar_id":"","url":"https://api.github.com/users/Sprechen","html_url":"https://github.com/Sprechen","followers_url":"https://api.github.com/users/Sprechen/followers","following_url":"https://api.github.com/users/Sprechen/following{/other_user}","gists_url":"https://api.github.com/users/Sprechen/gists{/gist_id}","starred_url":"https://api.github.com/users/Sprechen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Sprechen/subscriptions","organizations_url":"https://api.github.com/users/Sprechen/orgs","repos_url":"https://api.github.com/users/Sprechen/repos","events_url":"https://api.github.com/users/Sprechen/events{/privacy}","received_events_url":"https://api.github.com/users/Sprechen/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-12-17T22:05:22Z","updated_at":"2015-12-17T22:33:59Z","closed_at":null,"body":"We are using the Baasbox version 0.9.4 in a production environment and we have noticed something strange.\r\nWe have found that the default.pcl database file is 6,7 Gb and it is growing very fast.\r\nThe database contains 16768 records, with a total amount of less then 10Mb (calculated using the documents \"table\" in the dashboard of the console page).\r\nWe also use the files storage to save photos uploaded by users. Now, we have 658 photos. Assuming a maximum size of 1MB for each photo (it is limited by our client), photos are stored (theoretically) in less then 1Gb.\r\n\r\nWhy the default.pcl is so big? What is stored inside it?\r\nIs Baasbox saving some other data that cause the default.pcl size?"},"comment":{"url":"https://api.github.com/repos/baasbox/baasbox/issues/comments/165603729","html_url":"https://github.com/baasbox/baasbox/issues/914#issuecomment-165603729","issue_url":"https://api.github.com/repos/baasbox/baasbox/issues/914","id":165603729,"user":{"login":"Sprechen","id":10724424,"avatar_url":"https://avatars.githubusercontent.com/u/10724424?v=3","gravatar_id":"","url":"https://api.github.com/users/Sprechen","html_url":"https://github.com/Sprechen","followers_url":"https://api.github.com/users/Sprechen/followers","following_url":"https://api.github.com/users/Sprechen/following{/other_user}","gists_url":"https://api.github.com/users/Sprechen/gists{/gist_id}","starred_url":"https://api.github.com/users/Sprechen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Sprechen/subscriptions","organizations_url":"https://api.github.com/users/Sprechen/orgs","repos_url":"https://api.github.com/users/Sprechen/repos","events_url":"https://api.github.com/users/Sprechen/events{/privacy}","received_events_url":"https://api.github.com/users/Sprechen/received_events","type":"User","site_admin":false},"created_at":"2015-12-17T22:33:59Z","updated_at":"2015-12-17T22:33:59Z","body":"Thank you very much for your answer.\r\n\r\nThus, every uploaded photo goes in the default.pcl file. Is this correct?\r\nBut which type of audit records does Baasbox save? Can they be limited in some way? \r\nDoes Baasbox log every query to this collection? \r\n"}}