Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in database-performance

Oracle preferred columns lengths

Why did changing from utf8 to utf8mb4 slow down my database?

No index on !=?

When to use horizontal partitioning and when to use database sharding?

surrogate vs natural key: hard numbers on performance differences?

Comparison Group by VS Over Partition By

SELECT DISTINCT is slower than expected on my table in PostgreSQL

Doctrine2: Limiting with Left Joins / Pagination - Best Practice

how can I test performance in Sql Server Mgmt Studio without outputting data?

Is SQL Server smart enough not to UPDATE if values are the same?

Android SQLite alternatives [closed]

Is it faster to read from fixed-width columns in SQLite?

What's the difference between these T-SQL queries using OR?

Query takes extremely long in client app but is fast in SQL Server Management Studio

How to get MS SQL Server to transparently use a CHECKSUM/hash index?

MySQL query by date with big inverval

Postgresql performance comparison between arrays and joins

MySQL CPU increase when I have Sleeping connection that stay open

How can I improve query performance for 200+ million records