{"action":"created","issue":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/433","labels_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/433/labels{/name}","comments_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/433/comments","events_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/433/events","html_url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/433","id":112396303,"number":433,"title":"Question","user":{"login":"ChristophNiehoff","id":10673021,"avatar_url":"https://avatars.githubusercontent.com/u/10673021?v=3","gravatar_id":"","url":"https://api.github.com/users/ChristophNiehoff","html_url":"https://github.com/ChristophNiehoff","followers_url":"https://api.github.com/users/ChristophNiehoff/followers","following_url":"https://api.github.com/users/ChristophNiehoff/following{/other_user}","gists_url":"https://api.github.com/users/ChristophNiehoff/gists{/gist_id}","starred_url":"https://api.github.com/users/ChristophNiehoff/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ChristophNiehoff/subscriptions","organizations_url":"https://api.github.com/users/ChristophNiehoff/orgs","repos_url":"https://api.github.com/users/ChristophNiehoff/repos","events_url":"https://api.github.com/users/ChristophNiehoff/events{/privacy}","received_events_url":"https://api.github.com/users/ChristophNiehoff/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-10-20T15:35:42Z","updated_at":"2015-10-21T08:28:37Z","closed_at":null,"body":"I have a question regarding the built-in plotting function. I observed that for larger databases (~ 2M entries) the plots look quite different compared to plots made with e.g. python. I also observed that the plots very much depend on the ordering of the entries in the database. \r\nSince the plots are extremely fast, I assume that you perform some kind of \"thinning\" before doing the plot? I am right about this? Could you elaborate about the details of how the plots are done?\r\n\r\nThanks,\r\nChristoph Niehoff"},"comment":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/comments/149815995","html_url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/433#issuecomment-149815995","issue_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/433","id":149815995,"user":{"login":"ChristophNiehoff","id":10673021,"avatar_url":"https://avatars.githubusercontent.com/u/10673021?v=3","gravatar_id":"","url":"https://api.github.com/users/ChristophNiehoff","html_url":"https://github.com/ChristophNiehoff","followers_url":"https://api.github.com/users/ChristophNiehoff/followers","following_url":"https://api.github.com/users/ChristophNiehoff/following{/other_user}","gists_url":"https://api.github.com/users/ChristophNiehoff/gists{/gist_id}","starred_url":"https://api.github.com/users/ChristophNiehoff/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ChristophNiehoff/subscriptions","organizations_url":"https://api.github.com/users/ChristophNiehoff/orgs","repos_url":"https://api.github.com/users/ChristophNiehoff/repos","events_url":"https://api.github.com/users/ChristophNiehoff/events{/privacy}","received_events_url":"https://api.github.com/users/ChristophNiehoff/received_events","type":"User","site_admin":false},"created_at":"2015-10-21T08:28:37Z","updated_at":"2015-10-21T08:28:37Z","body":"Dear Rene,\r\n\r\nthank you for you reply!\r\n\r\nLet me give you an example.\r\nWhen I perform the two following select's:\r\n1) select dataA, dataB from DataBase order by dataA\r\n2) select dataA, dataB from DataBase order by dataB\r\nI assume that in both cases I have the same datapoints (or am I wrong here? I am quite new to SQL... ).\r\nBut when I make plots with dataA on the x-axis and dataB on the y-axis, I get totally different outcomes  for both cases (different distributions of datapoints and different plot ranges).\r\n\r\nAlso, I can make a plot with all points. Then I can perform a select that only returns entries, which are in a region, where the plot with all points didn't have any points. This select then shows that there are entries in the database, that the plot did not show...\r\n\r\nI assume that this very much depends on the structure of my data. My database contains ~2M entries generated by ~500 different Markov Chains, so the data is pretty much \"clustered\"...\r\n\r\nThanks very much,\r\nChristoph"}}