René's URL Explorer Experiment


Title: Useless time consuming internal SQL-commands at start-up and at browsing data?? · Issue #503 · sqlitebrowser/sqlitebrowser · GitHub

Open Graph Title: Useless time consuming internal SQL-commands at start-up and at browsing data?? · Issue #503 · sqlitebrowser/sqlitebrowser

X Title: Useless time consuming internal SQL-commands at start-up and at browsing data?? · Issue #503 · sqlitebrowser/sqlitebrowser

Description: Hello, I observed, that just opening a big sqlite-file tooks lots of time. At the SQL_Log panel I could see that SQLitebrowser first queries the sql_temp_master table, which is ok for me, but then also automatically queries the first tab...

Open Graph Description: Hello, I observed, that just opening a big sqlite-file tooks lots of time. At the SQL_Log panel I could see that SQLitebrowser first queries the sql_temp_master table, which is ok for me, but then ...

X Description: Hello, I observed, that just opening a big sqlite-file tooks lots of time. At the SQL_Log panel I could see that SQLitebrowser first queries the sql_temp_master table, which is ok for me, but then ...

Opengraph URL: https://github.com/sqlitebrowser/sqlitebrowser/issues/503

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Useless time consuming internal SQL-commands at start-up and at browsing data??","articleBody":"Hello,\n\nI observed, that just _opening_ a big sqlite-file tooks lots of time. At the SQL_Log panel I could see that SQLitebrowser first  queries the sql_temp_master table, which is ok for me, but then also automatically queries the first table inside the db file. Just to show me nothing else more than the entry panel with the file structure. I think the last query is pretty useless, cause switching to data panel issues the query for the first table _again_!\n\nSecond:\nIf then I will have a look at the data and right-click on the table of choice and clicking _Browse Table_ then SQLitebrowser issues **2** queries: 1st) for the last table (looked at or automatically queried by program start) and 2nd) for the actual table I want to look at. Again I think the first query is pretty useless!?\n\nOr do I miss a point?\n\nRegards\n  Ralf\n","author":{"url":"https://github.com/zwrmueller","@type":"Person","name":"zwrmueller"},"datePublished":"2016-01-22T09:46:44Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/503"}

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:cb7c6309-bf99-1713-02a1-a5101ef77d12
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idA170:21DDE1:12CDE6:19612F:6AFD40FA
html-safe-nonce770875e9a7a933af8b6e31a84d2f4c9942b4c29c0e4f611136578f950ce26664
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBMTcwOjIxRERFMToxMkNERTY6MTk2MTJGOjZBRkQ0MEZBIiwidmlzaXRvcl9pZCI6IjY5MTAyODk1OTE0NzU3MTYzNDYiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmac8d0a26eaaf54569224aee11e9f28af8212651f4a9feed58ab3202267833b5cb5
hovercard-subject-tagissue:128119647
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/503/issue_layout
twitter:imagehttps://opengraph.githubassets.com/49db79504de8234ade64f0a73f658d8d40bfcad64d08ef9b377ffa5e85870575/sqlitebrowser/sqlitebrowser/issues/503
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/49db79504de8234ade64f0a73f658d8d40bfcad64d08ef9b377ffa5e85870575/sqlitebrowser/sqlitebrowser/issues/503
og:image:altHello, I observed, that just opening a big sqlite-file tooks lots of time. At the SQL_Log panel I could see that SQLitebrowser first queries the sql_temp_master table, which is ok for me, but then ...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamezwrmueller
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/503#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F503
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%2F503
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/503
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/503
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/503
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/503
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/503
Useless time consuming internal SQL-commands at start-up and at browsing data??https://github.com/sqlitebrowser/sqlitebrowser/issues/503#top
enhancementFeature requests.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22enhancement%22
help wantedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22help%20wanted%22
performancehttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22performance%22
response requestedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22response%20requested%22
https://github.com/zwrmueller
zwrmuellerhttps://github.com/zwrmueller
on Jan 22, 2016https://github.com/sqlitebrowser/sqlitebrowser/issues/503#issue-128119647
zwrmuellerhttps://github.com/zwrmueller
on Jan 22, 2016https://github.com/sqlitebrowser/sqlitebrowser/issues/503#event-522739839
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Jan 22, 2016https://github.com/sqlitebrowser/sqlitebrowser/issues/503#issuecomment-173950418
justinclifthttps://github.com/justinclift
enhancementFeature requests.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22enhancement%22
help wantedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22help%20wanted%22
on Jan 22, 2016https://github.com/sqlitebrowser/sqlitebrowser/issues/503#event-523052558
https://github.com/zwrmueller
zwrmuellerhttps://github.com/zwrmueller
on Jan 22, 2016https://github.com/sqlitebrowser/sqlitebrowser/issues/503#issuecomment-173955548
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Jan 22, 2016https://github.com/sqlitebrowser/sqlitebrowser/issues/503#issuecomment-173977571
MKleusberghttps://github.com/MKleusberg
on Jan 27, 2016https://github.com/sqlitebrowser/sqlitebrowser/issues/503#event-528621947
Reduce number of unneededly executed SQL commandshttps://github.com/sqlitebrowser/sqlitebrowser/commit/6f17c3d1ea64f51aff437fbbd087334acfaf3c46
6f17c3dhttps://github.com/sqlitebrowser/sqlitebrowser/commit/6f17c3d1ea64f51aff437fbbd087334acfaf3c46
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on Jan 27, 2016https://github.com/sqlitebrowser/sqlitebrowser/issues/503#issuecomment-175814403
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Jan 28, 2016https://github.com/sqlitebrowser/sqlitebrowser/issues/503#issuecomment-176134847
@zwrmuellerhttps://github.com/zwrmueller
https://github.com/zwrmueller
zwrmuellerhttps://github.com/zwrmueller
on Jan 28, 2016https://github.com/sqlitebrowser/sqlitebrowser/issues/503#issuecomment-176137787
https://github.com/zwrmueller
zwrmuellerhttps://github.com/zwrmueller
on Jan 29, 2016https://github.com/sqlitebrowser/sqlitebrowser/issues/503#issuecomment-176682251
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Jan 30, 2016https://github.com/sqlitebrowser/sqlitebrowser/issues/503#issuecomment-177051580
https://github.com/zwrmueller
zwrmuellerhttps://github.com/zwrmueller
on Jan 30, 2016https://github.com/sqlitebrowser/sqlitebrowser/issues/503#issuecomment-177129578
https://cloud.githubusercontent.com/assets/14907888/12694899/06ca9fea-c73c-11e5-9e23-4b057e631a7e.jpg
https://cloud.githubusercontent.com/assets/14907888/12694898/06c9757a-c73c-11e5-886f-e6de932fbdb2.jpg
https://cloud.githubusercontent.com/assets/14907888/12694897/06c4b6ca-c73c-11e5-99cd-4073f55fa4f8.jpg
https://cloud.githubusercontent.com/assets/14907888/12694896/06c2669a-c73c-11e5-97cb-ca2a59fd631d.jpg
https://cloud.githubusercontent.com/assets/14907888/12694895/06c0218c-c73c-11e5-91ad-a40775fafe40.jpg
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Jan 31, 2016https://github.com/sqlitebrowser/sqlitebrowser/issues/503#issuecomment-177473118
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on May 26, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/503#issuecomment-392291354
@zwrmuellerhttps://github.com/zwrmueller
https://nightlies.sqlitebrowser.org/win32-onceoffs/DB%20Browser%20for%20SQLite-sqlcipher-issue1394v2-win32.exehttps://nightlies.sqlitebrowser.org/win32-onceoffs/DB%20Browser%20for%20SQLite-sqlcipher-issue1394v2-win32.exe
https://nightlies.sqlitebrowser.org/win64-onceoffs/DB%20Browser%20for%20SQLite-sqlcipher-issue1394v2-win64.exehttps://nightlies.sqlitebrowser.org/win64-onceoffs/DB%20Browser%20for%20SQLite-sqlcipher-issue1394v2-win64.exe
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/503#event-1648024818
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Oct 5, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/503#issuecomment-427446046
@zwrmuellerhttps://github.com/zwrmueller
nightly buildshttps://nightlies.sqlitebrowser.org/latest/
https://github.com/chrisjlocke
chrisjlockehttps://github.com/chrisjlocke
on Jan 8, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/503#issuecomment-452237266
@zwrmuellerhttps://github.com/zwrmueller
https://github.com/wmertens
wmertenshttps://github.com/wmertens
on Jan 15, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/503#issuecomment-454413506
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/503
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/503
enhancementFeature requests.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22enhancement%22
help wantedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22help%20wanted%22
performancehttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22performance%22
response requestedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22response%20requested%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.