{"action":"created","issue":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/409","repository_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser","labels_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/409/labels{/name}","comments_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/409/comments","events_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/409/events","html_url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/409","id":103750127,"node_id":"MDU6SXNzdWUxMDM3NTAxMjc=","number":409,"title":"Slow running Recursive CTE","user":{"login":"sprintel","id":14018760,"node_id":"MDQ6VXNlcjE0MDE4NzYw","avatar_url":"https://avatars0.githubusercontent.com/u/14018760?v=4","gravatar_id":"","url":"https://api.github.com/users/sprintel","html_url":"https://github.com/sprintel","followers_url":"https://api.github.com/users/sprintel/followers","following_url":"https://api.github.com/users/sprintel/following{/other_user}","gists_url":"https://api.github.com/users/sprintel/gists{/gist_id}","starred_url":"https://api.github.com/users/sprintel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sprintel/subscriptions","organizations_url":"https://api.github.com/users/sprintel/orgs","repos_url":"https://api.github.com/users/sprintel/repos","events_url":"https://api.github.com/users/sprintel/events{/privacy}","received_events_url":"https://api.github.com/users/sprintel/received_events","type":"User","site_admin":false},"labels":[{"id":416338050,"node_id":"MDU6TGFiZWw0MTYzMzgwNTA=","url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/labels/performance","name":"performance","color":"bfd4f2","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":10,"created_at":"2015-08-28T16:21:17Z","updated_at":"2018-10-18T10:58:46Z","closed_at":null,"author_association":"NONE","body":"Sqlitebrowser performs very slow when running Recursive CTE. I have a table with >500K rows and it takes Sqlitebrowser about 6 minutes to finish the query. Other sqlite browsers/managers such as sqlitespy, database.net, etc take around 1 min and 45 sec to complete. The fastest is sqlitespeed. It takes only about 1 min and 15 sec to complete the query. Can somebody take a look at this?\n\nThanks\n"},"comment":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/comments/430965993","html_url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/409#issuecomment-430965993","issue_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/409","id":430965993,"node_id":"MDEyOklzc3VlQ29tbWVudDQzMDk2NTk5Mw==","user":{"login":"MKleusberg","id":3153504,"node_id":"MDQ6VXNlcjMxNTM1MDQ=","avatar_url":"https://avatars3.githubusercontent.com/u/3153504?v=4","gravatar_id":"","url":"https://api.github.com/users/MKleusberg","html_url":"https://github.com/MKleusberg","followers_url":"https://api.github.com/users/MKleusberg/followers","following_url":"https://api.github.com/users/MKleusberg/following{/other_user}","gists_url":"https://api.github.com/users/MKleusberg/gists{/gist_id}","starred_url":"https://api.github.com/users/MKleusberg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MKleusberg/subscriptions","organizations_url":"https://api.github.com/users/MKleusberg/orgs","repos_url":"https://api.github.com/users/MKleusberg/repos","events_url":"https://api.github.com/users/MKleusberg/events{/privacy}","received_events_url":"https://api.github.com/users/MKleusberg/received_events","type":"User","site_admin":false},"created_at":"2018-10-18T10:58:46Z","updated_at":"2018-10-18T10:58:46Z","author_association":"MEMBER","body":"@sprintel Are you still interested in this issue? I'm asking because we are currently preparing some changes which might improve this. I'm still not sure how to further improve the performance in any noticeable way, but I think the version we have prepared is 1) again a bit faster and 2) has a cancel button. Do you want to give it a try? You can find the Windows and OSX build here:\r\n\r\n* https://nightlies.sqlitebrowser.org/win32-onceoffs/DB%20Browser%20for%20SQLite-sqlcipher-issue1575v2-win32.msi\r\n* https://nightlies.sqlitebrowser.org/win64-onceoffs/DB%20Browser%20for%20SQLite-sqlcipher-issue1575v2-win64.msi\r\n* https://nightlies.sqlitebrowser.org/osx-onceoffs/DB%20Browser%20for%20SQLite_issue-1575v1.dmg\r\n* https://nightlies.sqlitebrowser.org/osx-onceoffs/DB%20Browser%20for%20SQLite-sqlcipher_issue-1575v1.dmg"}}
{"actor":{"display_login":"MKleusberg"}}