RDBMS use and speed tweaking notes: Revision history

21 April 2022

• curprev 13:5113:51, 21 April 2022‎ Helpful talk contribs‎ m 70,298 bytes +1,864‎ →‎The value of caches
• curprev 13:1313:13, 21 April 2022‎ Helpful talk contribs‎ m 68,434 bytes +37‎ →‎The value of caches

19 April 2022

• curprev 20:2420:24, 19 April 2022‎ Helpful talk contribs‎ m 68,397 bytes +85‎ →‎Versions

13 April 2022

• curprev 21:3221:32, 13 April 2022‎ Helpful talk contribs‎ m 68,312 bytes +12‎ →‎Upsert

11 April 2022

• curprev 20:2020:20, 11 April 2022‎ Helpful talk contribs‎ m 68,300 bytes −2‎ →‎INNER join

10 April 2022

• curprev 16:2916:29, 10 April 2022‎ Helpful talk contribs‎ m 68,302 bytes −35‎ →‎Memory
• curprev 12:4912:49, 10 April 2022‎ Helpful talk contribs‎ m 68,337 bytes +310‎ →‎Indexing

22 January 2022

• curprev 15:2015:20, 22 January 2022‎ Helpful talk contribs‎ m 68,027 bytes −1‎ →‎The value of SSDs
• curprev 15:1915:19, 22 January 2022‎ Helpful talk contribs‎ m 68,028 bytes −110‎ →‎Databases: IO bound
• curprev 15:1715:17, 22 January 2022‎ Helpful talk contribs‎ m 68,138 bytes −32‎ →‎Memory
• curprev 15:1215:12, 22 January 2022‎ Helpful talk contribs‎ m 68,170 bytes −8‎ →‎Correlated subquery
• curprev 15:0515:05, 22 January 2022‎ Helpful talk contribs‎ m 68,178 bytes −52‎ →‎Correlated subquery
• curprev 15:0315:03, 22 January 2022‎ Helpful talk contribs‎ m 68,230 bytes +1‎ →‎Correlated subquery
• curprev 15:0315:03, 22 January 2022‎ Helpful talk contribs‎ m 68,229 bytes +38‎ →‎Correlated subquery

9 January 2022

• curprev 16:0016:00, 9 January 2022‎ Helpful talk contribs‎ m 68,191 bytes +7‎ →‎Upsert
• curprev 14:2314:23, 9 January 2022‎ Helpful talk contribs‎ 68,184 bytes +68,184‎ Created page with "{{Database related}} ...which in practice ''often'' means "database modeled to be queried easily with SQL", but not only. ==Speed and tweaking== Much of this is RDBMS-gener..."