{"action":"closed","issue":{"url":"https://api.github.com/repos/SpaceGroupUCL/qgisSpaceSyntaxToolkit/issues/4","labels_url":"https://api.github.com/repos/SpaceGroupUCL/qgisSpaceSyntaxToolkit/issues/4/labels{/name}","comments_url":"https://api.github.com/repos/SpaceGroupUCL/qgisSpaceSyntaxToolkit/issues/4/comments","events_url":"https://api.github.com/repos/SpaceGroupUCL/qgisSpaceSyntaxToolkit/issues/4/events","html_url":"https://github.com/SpaceGroupUCL/qgisSpaceSyntaxToolkit/issues/4","id":54796172,"number":4,"title":"Slow loading large tables","user":{"login":"jorgegil","id":1078840,"avatar_url":"https://avatars.githubusercontent.com/u/1078840?v=3","gravatar_id":"","url":"https://api.github.com/users/jorgegil","html_url":"https://github.com/jorgegil","followers_url":"https://api.github.com/users/jorgegil/followers","following_url":"https://api.github.com/users/jorgegil/following{/other_user}","gists_url":"https://api.github.com/users/jorgegil/gists{/gist_id}","starred_url":"https://api.github.com/users/jorgegil/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jorgegil/subscriptions","organizations_url":"https://api.github.com/users/jorgegil/orgs","repos_url":"https://api.github.com/users/jorgegil/repos","events_url":"https://api.github.com/users/jorgegil/events{/privacy}","received_events_url":"https://api.github.com/users/jorgegil/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/SpaceGroupUCL/qgisSpaceSyntaxToolkit/labels/Attribute%20Explorer","name":"Attribute Explorer","color":"d4c5f9"},{"url":"https://api.github.com/repos/SpaceGroupUCL/qgisSpaceSyntaxToolkit/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/SpaceGroupUCL/qgisSpaceSyntaxToolkit/milestones/3","html_url":"https://github.com/SpaceGroupUCL/qgisSpaceSyntaxToolkit/milestones/Release%200.3%20beta","labels_url":"https://api.github.com/repos/SpaceGroupUCL/qgisSpaceSyntaxToolkit/milestones/3/labels","id":1016282,"number":3,"title":"Release 0.3 beta","description":"Enhancements to performance and attribute explorer features","creator":{"login":"jorgegil","id":1078840,"avatar_url":"https://avatars.githubusercontent.com/u/1078840?v=3","gravatar_id":"","url":"https://api.github.com/users/jorgegil","html_url":"https://github.com/jorgegil","followers_url":"https://api.github.com/users/jorgegil/followers","following_url":"https://api.github.com/users/jorgegil/following{/other_user}","gists_url":"https://api.github.com/users/jorgegil/gists{/gist_id}","starred_url":"https://api.github.com/users/jorgegil/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jorgegil/subscriptions","organizations_url":"https://api.github.com/users/jorgegil/orgs","repos_url":"https://api.github.com/users/jorgegil/repos","events_url":"https://api.github.com/users/jorgegil/events{/privacy}","received_events_url":"https://api.github.com/users/jorgegil/received_events","type":"User","site_admin":false},"open_issues":3,"closed_issues":1,"state":"open","created_at":"2015-03-11T12:11:18Z","updated_at":"2015-03-16T18:43:36Z","due_on":"2015-03-16T00:00:00Z","closed_at":null},"comments":0,"created_at":"2015-01-19T18:18:21Z","updated_at":"2015-03-16T18:43:36Z","closed_at":"2015-03-16T18:43:36Z","body":"When a large table (10k + features) is selected in Attributes Explorer, the initial loading and calculation of table attributes can be very slow.\r\nSome repetition has been removed, but specific functions are slow:\r\n* getValidFields (this is a particularly bad bottleneck!)\r\n* getFieldValues\r\n\r\nMaking optimised version for spatialite to deal with large tables will certainly improve performance (see issue #61)"}}