Title: How to increase performance? · Issue #1364 · sqlitebrowser/sqlitebrowser · GitHub
Open Graph Title: How to increase performance? · Issue #1364 · sqlitebrowser/sqlitebrowser
X Title: How to increase performance? · Issue #1364 · sqlitebrowser/sqlitebrowser
Description: Details for the issue I have a DB (basically an Excel sheet that is too big for Excel) consisting of one table with ten columns, all containing simple datatypes such as text, integers and dates. All in all this table has between 3 and 4 ...
Open Graph Description: Details for the issue I have a DB (basically an Excel sheet that is too big for Excel) consisting of one table with ten columns, all containing simple datatypes such as text, integers and dates. Al...
X Description: Details for the issue I have a DB (basically an Excel sheet that is too big for Excel) consisting of one table with ten columns, all containing simple datatypes such as text, integers and dates. Al...
Opengraph URL: https://github.com/sqlitebrowser/sqlitebrowser/issues/1364
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"How to increase performance?","articleBody":"### Details for the issue\r\n\r\n\u003c!--\r\n\r\n\r\n\r\n-->\r\n\r\nI have a DB (basically an Excel sheet that is too big for Excel) consisting of one table with ten columns, all containing simple datatypes such as text, integers and dates. All in all this table has between 3 and 4 millions of rows.\r\n\r\nWorking in the GUI (scrolling, sorting a column, changing tabs and similar operations) with this DB on laptop with an eight core i7 and 16 GB memory is pretty slow. One CPU core is at 100 % but sqlitebrowser does not seem to utilise more than one core. On the other hand, I don't think CPU is the bottleneck here, rather it is memory: sqlitebrowser only uses about 1.5 GB of RAM when working with this database. The actual file is 450 MB. \"Only\" consuming 1.5 GB makes me think sqlitebrowser is not loading the whole dataset into memory.\r\n\r\nIs it possible to change some settings that will make the program faster under these circumstances?\r\n\r\nI think there should be an article about improving performance in the Wiki!\r\n\r\n#### I'm using DB4S on:\r\n\r\n- [ ] Windows: ( _version:_ ___ )\r\n- [ ] Linux: ( _distro:_ ___ )\r\n- [X] Mac OS: ( _version:_ ___ )\r\n- [ ] Other: ___\r\n\r\n#### I'm using DB4S version:\r\n\r\n- [ ] 3.10.1\r\n- [X] 3.10.0\r\n- [ ] 3.9.1\r\n- [ ] Other: ___\r\n\r\n#### I have also:\r\n\r\n- [ ] 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/l-g","@type":"Person","name":"l-g"},"datePublished":"2018-04-12T14:34:36Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/1364"}
| 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:ee5dfd80-fe29-680b-2ab7-4a1386d64626 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | A670:3B68C7:255A5A2:340E095:6AFD431B |
| html-safe-nonce | d91537630999b02ac3c6a34249b2fefaffc2fbb5b45aaf2d1e0536f1fdb6ecb1 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBNjcwOjNCNjhDNzoyNTVBNUEyOjM0MEUwOTU6NkFGRDQzMUIiLCJ2aXNpdG9yX2lkIjoiNjk2NTI1MzkyMDA1MDIwMTM3MSIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | 38a06f2e6f150fb07b940cb7494f32a432a254e2a7308f7883741893daa5cc07 |
| hovercard-subject-tag | issue:313754640 |
| 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/1364/issue_layout |
| twitter:image | https://opengraph.githubassets.com/f431c2698c7b4f158bab1aa656ce8fb8577b80ef3f49cdeea34a601c3a77a8fe/sqlitebrowser/sqlitebrowser/issues/1364 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/f431c2698c7b4f158bab1aa656ce8fb8577b80ef3f49cdeea34a601c3a77a8fe/sqlitebrowser/sqlitebrowser/issues/1364 |
| og:image:alt | Details for the issue I have a DB (basically an Excel sheet that is too big for Excel) consisting of one table with ten columns, all containing simple datatypes such as text, integers and dates. Al... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | l-g |
| 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