Title: Slow running Recursive CTE · Issue #409 · sqlitebrowser/sqlitebrowser · GitHub
Open Graph Title: Slow running Recursive CTE · Issue #409 · sqlitebrowser/sqlitebrowser
X Title: Slow running Recursive CTE · Issue #409 · sqlitebrowser/sqlitebrowser
Description: Sqlitebrowser performs very slow when running Recursive CTE. I have a table with >500K rows and it takes Sqlitebrowser about 6 minutes to finish the query. Other sqlite browsers/managers such as sqlitespy, database.net, etc take around 1...
Open Graph Description: Sqlitebrowser performs very slow when running Recursive CTE. I have a table with >500K rows and it takes Sqlitebrowser about 6 minutes to finish the query. Other sqlite browsers/managers such as sq...
X Description: Sqlitebrowser performs very slow when running Recursive CTE. I have a table with >500K rows and it takes Sqlitebrowser about 6 minutes to finish the query. Other sqlite browsers/managers such as...
Mail addresses
justin@postgresql.org
Opengraph URL: https://github.com/sqlitebrowser/sqlitebrowser/issues/409
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Slow running Recursive CTE","articleBody":"Sqlitebrowser performs very slow when running Recursive CTE. I have a table with >500K rows and it takes Sqlitebrowser about 6 minutes to finish the query. Other sqlite browsers/managers such as sqlitespy, database.net, etc take around 1 min and 45 sec to complete. The fastest is sqlitespeed. It takes only about 1 min and 15 sec to complete the query. Can somebody take a look at this?\n\nThanks\n","author":{"url":"https://github.com/sprintel","@type":"Person","name":"sprintel"},"datePublished":"2015-08-28T16:21:17Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/409"}
| 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:49ff6ed7-ab91-d884-68bb-c4f8ade0294e |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | 94A0:255AF6:18C8E:2231B:6AFD391E |
| html-safe-nonce | 3ad2681f2ae9a6ce0fab45dd04a2a704ebab7998ada05bae0d739c632301bbe7 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI5NEEwOjI1NUFGNjoxOEM4RToyMjMxQjo2QUZEMzkxRSIsInZpc2l0b3JfaWQiOiIxMDIwMzQ5NTk2OTg0NzUyNDE0IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0= |
| visitor-hmac | 90b0ebae958acad74c92de6078466b5a880bff0b2c38f12864333414da46f699 |
| hovercard-subject-tag | issue:103750127 |
| 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/409/issue_layout |
| twitter:image | https://opengraph.githubassets.com/6fdb8a5bf60d4804720ead425a2b4adf3e10d7822c9c4b4a841c9f63a5d6eb05/sqlitebrowser/sqlitebrowser/issues/409 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/6fdb8a5bf60d4804720ead425a2b4adf3e10d7822c9c4b4a841c9f63a5d6eb05/sqlitebrowser/sqlitebrowser/issues/409 |
| og:image:alt | Sqlitebrowser performs very slow when running Recursive CTE. I have a table with >500K rows and it takes Sqlitebrowser about 6 minutes to finish the query. Other sqlite browsers/managers such as sq... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | sprintel |
| 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