Rails Conf 2017: The Secret Life of SQL: How to Optimize Database Performance by Bryana Knight
RailsConf 2017: The Secret Life of SQL: How to Optimize Database Performance by Bryana Knight There are a lot of database index and query best practices that sometimes aren t best practices at all. Need all users created this year No problem Slap an index over createdat What about this year s active OR pending users, sorted by username Are we still covered indexwise Is the query as fast with 20 million users Common rules of thumb for indexing and query crafting arent black and white. We ll discuss
|
|