{"action":"opened","issue":{"url":"https://api.github.com/repos/mapbox/node-sqlite3/issues/980","repository_url":"https://api.github.com/repos/mapbox/node-sqlite3","labels_url":"https://api.github.com/repos/mapbox/node-sqlite3/issues/980/labels{/name}","comments_url":"https://api.github.com/repos/mapbox/node-sqlite3/issues/980/comments","events_url":"https://api.github.com/repos/mapbox/node-sqlite3/issues/980/events","html_url":"https://github.com/mapbox/node-sqlite3/issues/980","id":320452234,"number":980,"title":"Feature Request - Expose an option to set SQLITE_FCNTL_CHUNK_SIZE","user":{"login":"trevershick","id":509549,"avatar_url":"https://avatars0.githubusercontent.com/u/509549?v=4","gravatar_id":"","url":"https://api.github.com/users/trevershick","html_url":"https://github.com/trevershick","followers_url":"https://api.github.com/users/trevershick/followers","following_url":"https://api.github.com/users/trevershick/following{/other_user}","gists_url":"https://api.github.com/users/trevershick/gists{/gist_id}","starred_url":"https://api.github.com/users/trevershick/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/trevershick/subscriptions","organizations_url":"https://api.github.com/users/trevershick/orgs","repos_url":"https://api.github.com/users/trevershick/repos","events_url":"https://api.github.com/users/trevershick/events{/privacy}","received_events_url":"https://api.github.com/users/trevershick/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-05-04T22:52:11Z","updated_at":"2018-05-04T22:52:11Z","closed_at":null,"author_association":"NONE","body":"Our C code uses this option to set a 'larger than default' chunk size to help with fragmentation.  However, our Node code is unable to take advantage of this feature.\r\n\r\nThere is already a `db.configure('busyTimeout', 1000)` feature it would be great if we could `db.configure('chunkSize', 1024*1024)`.\r\n\r\nsee https://sqlite.org/c3ref/c_fcntl_chunk_size.html\r\nref (about fragmentation https://stackoverflow.com/questions/13393866/sqlite-wal-performance-improvement)"}}
{"actor":{"display_login":"trevershick"}}