Title: Prefetch block size creates unsafe grid selection! · Issue #1373 · sqlitebrowser/sqlitebrowser · GitHub
Open Graph Title: Prefetch block size creates unsafe grid selection! · Issue #1373 · sqlitebrowser/sqlitebrowser
X Title: Prefetch block size creates unsafe grid selection! · Issue #1373 · sqlitebrowser/sqlitebrowser
Description: Details for the issue "View - Preferences - Database - Prefetch block size" creates unsafe grid selection. And the ? tool does not work within the preferences dialog to describe the ramifications of this setting? At a minimum, the Result...
Open Graph Description: Details for the issue "View - Preferences - Database - Prefetch block size" creates unsafe grid selection. And the ? tool does not work within the preferences dialog to describe the ramifications o...
X Description: Details for the issue "View - Preferences - Database - Prefetch block size" creates unsafe grid selection. And the ? tool does not work within the preferences dialog to describe the ramif...
Opengraph URL: https://github.com/sqlitebrowser/sqlitebrowser/issues/1373
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Prefetch block size creates unsafe grid selection!","articleBody":"### Details for the issue\r\n\"View - Preferences - Database - Prefetch block size\" creates unsafe grid selection.\r\nAnd the ? tool does not work within the preferences dialog to describe the ramifications of this setting?\r\n\r\nAt a minimum, the Results window should state:\r\nXXX rows of YYY available returned in Nms from: select * from myDB;\r\n\r\nBetter is to return all rows when user clicks Select All [Ctrl+A] or clicks the upper left of the grid box.\r\nThis is tricky behavior.\r\nI understand the desire to limit rows for performance, but \"Select All\" must = \"All\". \r\nNot \"Select All loaded rows\".\r\n\r\n### Useful extra information\r\nSet the Prefetch to a smallish number like 500.\r\n\r\nExecute a SQL statement that returns more than 500.\r\nThe Results window tells the user XXX rows returned in Xms from: select * from myDB;\r\n\r\n- Select all resulting rows & cols - Copy to clipboard.\r\nResult = Only the prefetch amount of rows were selected and copied.\r\n\r\nScrolling beyond the prefetch amount appends additional prefetch rows.\r\nBut this is an intensive and unexpected operation to get \"all\" the returned rows.\r\n\r\n#### I'm opening this issue because:\r\n\r\n- [ ] DB4S is crashing\r\n- [x] DB4S has a bug\r\n- [x] DB4S needs a feature\r\n- [ ] DB4S has another problem\r\n\r\n#### I'm using DB4S on:\r\n\r\n- [x] Windows: ( _version:_10 Pro___ )\r\n- [ ] Linux: ( _distro:_ ___ )\r\n- [ ] Mac OS: ( _version:_ ___ )\r\n- [ ] Other: ___\r\n\r\n#### I'm using DB4S version:\r\n\r\n- [x] 3.10.1\r\n- [ ] 3.10.0\r\n- [ ] 3.9.1\r\n- [ ] Other: ___\r\n\r\n#### I have also:\r\n\r\n- [x] Tried out the latest nightly version: https://github.com/sqlitebrowser/sqlitebrowser#nightly-builds\r\n- [x] Searched for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20\r\n","author":{"url":"https://github.com/sky5walk","@type":"Person","name":"sky5walk"},"datePublished":"2018-05-02T17:09:33Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/1373"}
| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322 |
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:6be3d505-eec8-4c5c-7e33-de73d9079b49 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | A34E:126CB9:258205E:3437F90:6AFD4493 |
| html-safe-nonce | 4e9aa022f163db4391df617cd5480c68f49f620c3afa5a4769bc8c3f7a67b13e |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBMzRFOjEyNkNCOToyNTgyMDVFOjM0MzdGOTA6NkFGRDQ0OTMiLCJ2aXNpdG9yX2lkIjoiNzU0ODcxNzI0Mjg2NzU5ODQ4MyIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | b71330943472f1836af2b3bac571cab4a61432707be50230f0d202eaba4ae94f |
| hovercard-subject-tag | issue:319637751 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlitebrowser/sqlitebrowser/1373/issue_layout |
| twitter:image | https://opengraph.githubassets.com/764eefed6b049724e12d3a8a3b4f99e2997e9608f29236bccafdddece9fb1707/sqlitebrowser/sqlitebrowser/issues/1373 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/764eefed6b049724e12d3a8a3b4f99e2997e9608f29236bccafdddece9fb1707/sqlitebrowser/sqlitebrowser/issues/1373 |
| og:image:alt | Details for the issue "View - Preferences - Database - Prefetch block size" creates unsafe grid selection. And the ? tool does not work within the preferences dialog to describe the ramifications o... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | sky5walk |
| hostname | github.com |
| expected-hostname | github.com |
| None | bdbacc25b921224ff0befcb9e629560a1255be51aec9991d6e3f95b5e9151474 |
| turbo-cache-control | no-preview |
| go-import | github.com/sqlitebrowser/sqlitebrowser git https://github.com/sqlitebrowser/sqlitebrowser.git |
| octolytics-dimension-user_id | 7454271 |
| octolytics-dimension-user_login | sqlitebrowser |
| octolytics-dimension-repository_id | 19416551 |
| octolytics-dimension-repository_nwo | sqlitebrowser/sqlitebrowser |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 19416551 |
| octolytics-dimension-repository_network_root_nwo | sqlitebrowser/sqlitebrowser |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 556dd37bb0aceffb25724e151b5d858b3265b40b |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width