How to Introduce Composite Primary Keys in Rails - Shopify
How to Introduce Composite Primary Keys in RailsOne line of code can 5x your Rails application performance. What if you could make a small change to your database design that would unlock massively more efficient data access? At Shopify, we dusted off some old database principles and did exactly that with the primary Rails application. Databases are a key scalability bottleneck for many web applic
Faster pagination in HEY
Recently we focused on improving the performance of HEY. Fixing slow database queries for some of the HEY pages was a challenge, so I thought it would be worth writing up a technique we used. Background HEY currently runs on Amazon Aurora with MySQL 5.7 compatibility. It uses the InnoDB storage engine. In InnoDB, table and indexes are stored in a variation of a B+ tree data structure. The tree is
How PlanetScale Boost serves your SQL queries instantly — PlanetScale
And yes, I know what you’re thinking. “This query is bananas, man. I would never run this in production!”. I know! I agree. The query is not particularly hard to understand, but if you try running it in a standard relational database, you’ll see that as soon as you have a few thousand star rows, the execution time of the query balloons out of control. Although this query uses the relational model
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
https://mobile.twitter.com/stats_feed/status/1600712751550431232
Vitess | Why write a new planner
PlanetScale Boost: Up to 1,000× faster queries in just a few clicks