Search code examples
Measure the time it takes to execute a PostgreSQL query...


postgresqlloopsquery-optimizationtiming

Read More
Query with aggregate functions is very slow...


sqlsql-serverquery-optimization

Read More
Mysql performance issues...


mysqlquery-optimization

Read More
Requesting an example where query with BRIN index runs much faster than with BTREE...


postgresqlquery-optimizationb-tree-index

Read More
MongoDB not using compound index on '_id'...


mongodbquery-optimizationpymongo

Read More
Insert value into mysql if this value isn't the latest value...


mysqlquery-optimization

Read More
Why does my query get slower and not faster when I constrain the data set?...


sqlpostgresqlquery-optimizationtimescaledb

Read More
Postgresql compare 2 querys for optimization...


postgresqlquery-optimizationsql-execution-plan

Read More
Can I order by id rather than creation time?...


mysqlsqldatabasequery-optimization

Read More
When ordering by date desc, "Using temporary" slows down query...


mysqlindexingquery-optimization

Read More
MariaDB left join ignores index key - slow performance with large joined table...


joinmariadbquery-optimizationdatabase-indexes

Read More
Using T-SQL EXCEPT with DELETE / Optimizing a query...


sqlsql-server-2008t-sqlquery-optimization

Read More
Why is the order page on my WooCommerce store so slow?...


wordpresswoocommercequery-optimizationkey-value-storehighperformance

Read More
Querying Many-to-Many relations in Prisma...


sqlmany-to-manyquery-optimizationprisma

Read More
SQL Server select query where clause...


sqlsql-servert-sqlquery-optimization

Read More
MySQL 8: very slow INSERT…SELECT within the same server for huge partitioned table...


mysqlquery-optimizationpartitioninginsert-select

Read More
Improving performance of Postgres jsonb queries combined with relational queries...


postgresqlquery-optimizationjsonbpostgresql-12

Read More
Performance issues with recursive stored procedure for hierarchical data...


sql-serverperformancequery-optimizationdatabase-performance

Read More
How to find out what is locking my tables?...


sqlsql-serversql-server-2008-r2lockingquery-optimization

Read More
How to parse a mysql slow query log into something useful?...


mysqlquery-optimization

Read More
How to do the Recursive SELECT query in MySQL?...


mysqlsqlquery-optimizationrecursive-query

Read More
Get n grouped categories and sum others into one...


sqlpostgresqlquery-optimizationaggregatesql-limit

Read More
Postgresql delay in queries using wildcard '%searchTerm%' in large set database...


sqlpostgresqlquery-optimizationfull-text-searchwildcard

Read More
How to use index to search if trim is used in search value...


postgresqlindexingquery-optimization

Read More
10.4.32-MariaDB mysql conditional join horrible performance...


left-joinquery-optimizationcasemariadb-10.4

Read More
SQL Server does not short circuit static query...


sqlsql-serverquery-optimization

Read More
T-SQL query very slow when using index on Date column...


sql-serverindexingquery-optimizationsql-execution-plan

Read More
Index is not used when querying JSON array...


postgresqlindexingquery-optimizationpostgresql-performance

Read More
Making iterated trips to the database is significantly increasing execution time...


phpmysqlcodeigniterquery-optimization

Read More
How should I paginate a SQL query where the rows have no natural ordering?...


database-designpaginationmariadbquery-optimization

Read More
BackNext