René's URL Explorer Experiment


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

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@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-profiling0
react-import-mapreact,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-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:ee5dfd80-fe29-680b-2ab7-4a1386d64626
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idA670:3B68C7:255A5A2:340E095:6AFD431B
html-safe-nonced91537630999b02ac3c6a34249b2fefaffc2fbb5b45aaf2d1e0536f1fdb6ecb1
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBNjcwOjNCNjhDNzoyNTVBNUEyOjM0MEUwOTU6NkFGRDQzMUIiLCJ2aXNpdG9yX2lkIjoiNjk2NTI1MzkyMDA1MDIwMTM3MSIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac38a06f2e6f150fb07b940cb7494f32a432a254e2a7308f7883741893daa5cc07
hovercard-subject-tagissue:313754640
github-keyboard-shortcutsrepository,issues,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/issues_fragments/issue_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlitebrowser/sqlitebrowser/1364/issue_layout
twitter:imagehttps://opengraph.githubassets.com/f431c2698c7b4f158bab1aa656ce8fb8577b80ef3f49cdeea34a601c3a77a8fe/sqlitebrowser/sqlitebrowser/issues/1364
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/f431c2698c7b4f158bab1aa656ce8fb8577b80ef3f49cdeea34a601c3a77a8fe/sqlitebrowser/sqlitebrowser/issues/1364
og:image:altDetails 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:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamel-g
hostnamegithub.com
expected-hostnamegithub.com
Nonebdbacc25b921224ff0befcb9e629560a1255be51aec9991d6e3f95b5e9151474
turbo-cache-controlno-preview
go-importgithub.com/sqlitebrowser/sqlitebrowser git https://github.com/sqlitebrowser/sqlitebrowser.git
octolytics-dimension-user_id7454271
octolytics-dimension-user_loginsqlitebrowser
octolytics-dimension-repository_id19416551
octolytics-dimension-repository_nwosqlitebrowser/sqlitebrowser
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id19416551
octolytics-dimension-repository_network_root_nwosqlitebrowser/sqlitebrowser
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release556dd37bb0aceffb25724e151b5d858b3265b40b
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/sqlitebrowser/sqlitebrowser/issues/1364#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F1364
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F1364
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=sqlitebrowser%2Fsqlitebrowser
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1364
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1364
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1364
sqlitebrowserhttps://github.com/sqlitebrowser
sqlitebrowserhttps://github.com/sqlitebrowser/sqlitebrowser
Codehttps://github.com/sqlitebrowser/sqlitebrowser
Issues786 (786)https://github.com/sqlitebrowser/sqlitebrowser/issues
Pull requests30 (30)https://github.com/sqlitebrowser/sqlitebrowser/pulls
Discussionshttps://github.com/sqlitebrowser/sqlitebrowser/discussions
Actionshttps://github.com/sqlitebrowser/sqlitebrowser/actions
Projectshttps://github.com/sqlitebrowser/sqlitebrowser/projects
Wikihttps://github.com/sqlitebrowser/sqlitebrowser/wiki
Security and qualityhttps://github.com/sqlitebrowser/sqlitebrowser/security
Insightshttps://github.com/sqlitebrowser/sqlitebrowser/insights
https://github.com/sqlitebrowser/sqlitebrowser
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1364
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1364
How to increase performance?https://github.com/sqlitebrowser/sqlitebrowser/issues/1364#top
performancehttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22performance%22
https://github.com/l-g
l-ghttps://github.com/l-g
on Apr 12, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1364#issue-313754640
https://github.com/sqlitebrowser/sqlitebrowser#nightly-buildshttps://github.com/sqlitebrowser/sqlitebrowser#nightly-builds
https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20
https://github.com/chrisjlocke
chrisjlockehttps://github.com/chrisjlocke
on Apr 12, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1364#issuecomment-380832238
https://user-images.githubusercontent.com/7872218/38684793-64279832-3e68-11e8-9b93-3a23f7a8ad58.png
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on May 26, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1364#issuecomment-392290465
@l-ghttps://github.com/l-g
#1394https://github.com/sqlitebrowser/sqlitebrowser/pull/1394
https://nightlies.sqlitebrowser.org/osx-onceoffs/DB%20Browser%20for%20SQLite-sqlcipher_issue1394v2.dmghttps://nightlies.sqlitebrowser.org/osx-onceoffs/DB%20Browser%20for%20SQLite-sqlcipher_issue1394v2.dmg
justinclifthttps://github.com/justinclift
response requestedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22response%20requested%22
performancehttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22performance%22
on May 26, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1364#event-1648020319
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Oct 8, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1364#issuecomment-427939453
@l-ghttps://github.com/l-g
nightly buildshttps://nightlies.sqlitebrowser.org/latest/
https://github.com/l-g
l-ghttps://github.com/l-g
on Oct 8, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1364#issuecomment-427954406
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Oct 9, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1364#issuecomment-428026314
@l-ghttps://github.com/l-g
justinclifthttps://github.com/justinclift
completedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Oct 9, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1364#event-1891598727
justinclifthttps://github.com/justinclift
response requestedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22response%20requested%22
on Oct 9, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1364#event-1891598867
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1364
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1364
performancehttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22performance%22
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.