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
Domain: github.com
{"@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-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:cb7c6309-bf99-1713-02a1-a5101ef77d12 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | A170:21DDE1:12CDE6:19612F:6AFD40FA |
| html-safe-nonce | 770875e9a7a933af8b6e31a84d2f4c9942b4c29c0e4f611136578f950ce26664 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBMTcwOjIxRERFMToxMkNERTY6MTk2MTJGOjZBRkQ0MEZBIiwidmlzaXRvcl9pZCI6IjY5MTAyODk1OTE0NzU3MTYzNDYiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | 8d0a26eaaf54569224aee11e9f28af8212651f4a9feed58ab3202267833b5cb5 |
| hovercard-subject-tag | issue:128119647 |
| 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/503/issue_layout |
| twitter:image | https://opengraph.githubassets.com/49db79504de8234ade64f0a73f658d8d40bfcad64d08ef9b377ffa5e85870575/sqlitebrowser/sqlitebrowser/issues/503 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/49db79504de8234ade64f0a73f658d8d40bfcad64d08ef9b377ffa5e85870575/sqlitebrowser/sqlitebrowser/issues/503 |
| og:image:alt | 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 ... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | zwrmueller |
| 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