🦞🌯 Lobster Roll

Thread

How I slashed a SQL query runtime from 380 hours to 12 with two Unix commands (spinellis.gr)
L 26 pts 5 comments by calvin Aug 5, 2018 databasesunix thread

Stories related to "How I slashed a SQL query runtime from 380 hours to 12 with two Unix commands" across the full archive.

How I slashed a SQL query runtime from 380 hours to 12 with two Unix commands (spinellis.gr)
L 26 pts 5 comments by calvin Aug 5, 2018 databasesunix Systems / Low-Level / OSData / Databases / Infrastructure thread
Querying PostgreSQL datatypes in ActiveRecord with postgres_ext (reefpoints.dockyard.com)
L 5 pts 3 comments by craigkerstiens Sep 21, 2012 databasesruby Programming (General)Data / Databases / Infrastructure thread
Tree structure query with PostgreSQL (2014) (truongtx.me)
L 4 pts 0 comments by jasper Feb 26, 2015 databases Data / Databases / Infrastructure thread
Case-insensitive querying and Full Text Search on PostgreSQL, MySQL, and SQLite (github.com)
L 1 pts 0 comments by glebm Apr 27, 2016 databasesruby Programming (General)Data / Databases / Infrastructure thread
Faceted Search in the Single PostgreSQL Query - Alexander Korotkov's blog (akorotkov.github.io)
L 9 pts 1 comments by ngrilly Jun 18, 2016 databases Data / Databases / InfrastructureInternet / Digital Culture thread
Using EXPLAIN ANALYZE to debug a slow SQL query (product.reverb.com)
L 7 pts 0 comments by BenoitTigeot Jan 29, 2017 databases Programming (General)Data / Databases / Infrastructure thread
SQL injection in an UPDATE query - a bug bounty story! (zombiehelp54.blogspot.com)
L 3 pts 0 comments by calvin Feb 20, 2017 databasessecurity Data / Databases / InfrastructureSecurity / Privacy thread
SQL - Synchronized Query Language (blog.suligap.net)
L 1 pts 2 comments by suligap Mar 21, 2017 databasesprogramming Programming (General)Data / Databases / Infrastructure thread
Benchmarking Complex Query Performance in CrateDB and PostgreSQL (crate.io)
L 3 pts 1 comments by nalentados May 5, 2017 databases Data / Databases / Infrastructure thread
Querying the Ethereum Blockchain with SQL on Presto (github.com)
L 3 pts 0 comments by herval Jul 25, 2017 databasesmerkle-trees Data / Databases / InfrastructureCrypto / Blockchain thread
MySQL 8.0: Retiring Support for the Query Cache (mysqlserverteam.com)
L 3 pts 0 comments by pgl Aug 18, 2017 databases Data / Databases / Infrastructure thread
It's also being [deprecated in MySQL 5.7.20](https://dev.mysql.com/doc/refman/5.7/en/query-cache.html).
SQL subquery performance was 260x faster than a left join (crate.io)
L 12 pts 12 comments by nalentados Aug 18, 2017 databases Data / Databases / Infrastructure thread
HoTTSQL: Proving query rewrites with univalent SQL semantics (blog.acolyer.org)
L 5 pts 1 comments by sanxiyn Oct 5, 2017 databasesformalmethods Programming Languages / CS TheoryData / Databases / Infrastructure thread
How a single PostgreSQL config change improved slow query performance by 50x (amplitude.engineering)
L 46 pts 11 comments by mulander Nov 27, 2017 databases Data / Databases / Infrastructure thread
Queryparser, an Open Source Tool for Parsing and Analyzing SQL (eng.uber.com)
L 6 pts 0 comments by sanxiyn Mar 2, 2018 databaseshaskell Programming (General)Programming Languages / CS TheoryData / Databases / Infrastructure thread
Using SQL to query Kafka, MongoDB, MySQL, PostgreSQL and Redis with Presto (tech.marksblogg.com)
L 1 pts 0 comments by marklit Apr 26, 2018 databases Data / Databases / Infrastructure thread
Life of a SQL query (numeracy.co)
L 8 pts 0 comments by calvin Feb 2, 2019 databasesprogramming Programming (General)Data / Databases / Infrastructure thread
MySQL/MariaDB Query for Counting API Requests per Day (calendarific.com)
L 1 pts 0 comments by dotcom Apr 20, 2019 apidatabasesdevops Programming (General)Data / Databases / Infrastructure thread
PostgreSQL extension for creating elastic clusters with parallel query processing (swarm64.com)
L 6 pts 0 comments by andye Jul 22, 2019 databases Data / Databases / Infrastructure thread
Announcing PartiQL: an SQL-compatible, open source query language intended to work with many different types of data stores (aws.amazon.com)
~ 5 pts 2 comments by unknown Aug 1, 2019 ~comp Programming (General)Data / Databases / Infrastructure thread
How to monitor MySQL / MariaDB query progress (spinellis.gr)
L 10 pts 0 comments by calvin Nov 4, 2019 databases Data / Databases / Infrastructure thread
Client-Side SQL Query Parsing with ANTLR (rockset.com)
L 2 pts 0 comments by mooreds Nov 6, 2019 databasesjavascript Web DevelopmentProgramming Languages / CS TheoryData / Databases / Infrastructure thread
avoid OR for better PostgreSQL query performance (cybertec-postgresql.com)
L 25 pts 1 comments by pauloxnet Nov 11, 2019 databasesperformance Data / Databases / Infrastructure thread
The Perils of Querying SQL Server Replicas Under Load (tarynpivots.com)
L 1 pts 0 comments by mooreds Jan 20, 2020 databases Data / Databases / Infrastructure thread
PostgreSQL, Oracle ... graph query language standards adoption begins (linkedin.com)
L 4 pts 0 comments by jjdh May 1, 2020 databases Data / Databases / Infrastructure thread
PostgreSQL query parallelism can be like a box of chocolates (swarm64.com)
L 5 pts 0 comments by andye Jun 8, 2020 databases Data / Databases / Infrastructure thread
PostgreSQL query JIT (solovyov.net)
L 42 pts 28 comments by piranha Jun 23, 2020 databases Data / Databases / Infrastructure thread
The surprising impact of medium-size texts on PostgreSQL query performance (hakibenita.com)
~ 5 pts 0 comments by unknown Oct 20, 2020 ~comp Programming (General)Data / Databases / Infrastructure thread
cloudquery transforms your cloud infrastructure into SQL or Graph database (github.com)
L 3 pts 0 comments by yonkeltron Feb 28, 2021 databasesdevops Data / Databases / Infrastructure thread
Increase performance via Range Fields in Django Querysets on PostgreSQL (nezhar.com)
L 4 pts 0 comments by nezhar May 24, 2021 databasesperformancepython Programming (General)Data / Databases / Infrastructure thread