RDBMS use and speed tweaking notes: Revision history

4 November 2023

• curprev 13:0113:01, 4 November 2023‎ Helpful talk contribs‎ m 74,532 bytes +6‎ →‎random offset
• curprev 12:0412:04, 4 November 2023‎ Helpful talk contribs‎ m 74,526 bytes +15‎ →‎random offset

10 December 2022

• curprev 00:2700:27, 10 December 2022‎ Helpful talk contribs‎ m 74,511 bytes +79‎ →‎Upsert

16 September 2022

• curprev 15:4215:42, 16 September 2022‎ Helpful talk contribs‎ m 74,432 bytes +65‎ →‎Upsert
• curprev 15:4015:40, 16 September 2022‎ Helpful talk contribs‎ m 74,367 bytes +61‎ →‎Upsert
• curprev 15:3715:37, 16 September 2022‎ Helpful talk contribs‎ m 74,306 bytes +4‎ →‎Upsert

9 August 2022

• curprev 11:3711:37, 9 August 2022‎ Helpful talk contribs‎ m 74,302 bytes +2‎ →‎Upsert

25 June 2022

• curprev 20:0920:09, 25 June 2022‎ Helpful talk contribs‎ m 74,300 bytes +19‎ →‎Memory
• curprev 20:0820:08, 25 June 2022‎ Helpful talk contribs‎ m 74,281 bytes +154‎ →‎Memory

20 June 2022

• curprev 13:3813:38, 20 June 2022‎ Helpful talk contribs‎ m 74,127 bytes +4‎ →‎The value of caches
• curprev 13:3713:37, 20 June 2022‎ Helpful talk contribs‎ m 74,123 bytes −76‎ →‎The value of SSDs
• curprev 13:3513:35, 20 June 2022‎ Helpful talk contribs‎ m 74,199 bytes −32‎ →‎Databases: IO bound
• curprev 13:2413:24, 20 June 2022‎ Helpful talk contribs‎ m 74,231 bytes +141‎ →‎Disk and other hardware
• curprev 13:2113:21, 20 June 2022‎ Helpful talk contribs‎ m 74,090 bytes −366‎ →‎Memory
• curprev 13:1613:16, 20 June 2022‎ Helpful talk contribs‎ m 74,456 bytes −75‎ →‎TABLESAMPLE

19 June 2022

• curprev 22:5922:59, 19 June 2022‎ Helpful talk contribs‎ m 74,531 bytes +49‎ →‎TABLESAMPLE

8 June 2022

• curprev 19:2619:26, 8 June 2022‎ Helpful talk contribs‎ m 74,482 bytes +204‎ No edit summary

19 May 2022

• curprev 21:4621:46, 19 May 2022‎ Helpful talk contribs‎ m 74,278 bytes +35‎ →‎Correlated subquery
• curprev 21:4521:45, 19 May 2022‎ Helpful talk contribs‎ m 74,243 bytes −24‎ →‎OUTER JOINs: LEFT JOIN, RIGHT JOIN, and FULL JOIN
• curprev 21:4521:45, 19 May 2022‎ Helpful talk contribs‎ m 74,267 bytes +20‎ →‎OUTER JOINs: LEFT JOIN, RIGHT JOIN, and FULL JOIN

18 May 2022

• curprev 00:2800:28, 18 May 2022‎ Helpful talk contribs‎ m 74,247 bytes +792‎ →‎Fetching random items and samples

9 May 2022

• curprev 00:0400:04, 9 May 2022‎ Helpful talk contribs‎ m 73,455 bytes +653‎ →‎select next ID

8 May 2022

• curprev 23:4523:45, 8 May 2022‎ Helpful talk contribs‎ m 72,802 bytes +135‎ →‎random offset
• curprev 17:3717:37, 8 May 2022‎ Helpful talk contribs‎ m 72,667 bytes +7‎ →‎random offset
• curprev 17:3717:37, 8 May 2022‎ Helpful talk contribs‎ m 72,660 bytes +1‎ →‎order by random
• curprev 14:1514:15, 8 May 2022‎ Helpful talk contribs‎ m 72,659 bytes +38‎ →‎fragmentation
• curprev 14:1514:15, 8 May 2022‎ Helpful talk contribs‎ m 72,621 bytes +67‎ →‎On foreign keys
• curprev 13:4813:48, 8 May 2022‎ Helpful talk contribs‎ m 72,554 bytes +77‎ →‎Indexing
• curprev 13:4713:47, 8 May 2022‎ Helpful talk contribs‎ m 72,477 bytes +223‎ →‎Disk and other hardware
• curprev 13:4013:40, 8 May 2022‎ Helpful talk contribs‎ m 72,254 bytes +50‎ →‎Memory
• curprev 13:3513:35, 8 May 2022‎ Helpful talk contribs‎ m 72,204 bytes 0‎ Helpful moved page General RDBMS use and speed tweaking notes to RDBMS use and speed tweaking notes

25 April 2022

• curprev 22:0922:09, 25 April 2022‎ Helpful talk contribs‎ m 72,204 bytes +1,846‎ →‎Multiple cursors

21 April 2022

• curprev 12:5212:52, 21 April 2022‎ Helpful talk contribs‎ m 70,358 bytes +59‎ →‎The value of caches
• curprev 12:5112:51, 21 April 2022‎ Helpful talk contribs‎ m 70,299 bytes +1‎ →‎The value of caches
• curprev 12:5112:51, 21 April 2022‎ Helpful talk contribs‎ m 70,298 bytes +1,864‎ →‎The value of caches
• curprev 12:1312:13, 21 April 2022‎ Helpful talk contribs‎ m 68,434 bytes +37‎ →‎The value of caches

19 April 2022

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

13 April 2022

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

11 April 2022

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

10 April 2022

• curprev 15:2915:29, 10 April 2022‎ Helpful talk contribs‎ m 68,302 bytes −35‎ →‎Memory
• curprev 11:4911:49, 10 April 2022‎ Helpful talk contribs‎ m 68,337 bytes +310‎ →‎Indexing

22 January 2022

• curprev 14:2014:20, 22 January 2022‎ Helpful talk contribs‎ m 68,027 bytes −1‎ →‎The value of SSDs
• curprev 14:1914:19, 22 January 2022‎ Helpful talk contribs‎ m 68,028 bytes −110‎ →‎Databases: IO bound
• curprev 14:1714:17, 22 January 2022‎ Helpful talk contribs‎ m 68,138 bytes −32‎ →‎Memory
• curprev 14:1214:12, 22 January 2022‎ Helpful talk contribs‎ m 68,170 bytes −8‎ →‎Correlated subquery
• curprev 14:0514:05, 22 January 2022‎ Helpful talk contribs‎ m 68,178 bytes −52‎ →‎Correlated subquery
• curprev 14:0314:03, 22 January 2022‎ Helpful talk contribs‎ m 68,230 bytes +1‎ →‎Correlated subquery
• curprev 14:0314:03, 22 January 2022‎ Helpful talk contribs‎ m 68,229 bytes +38‎ →‎Correlated subquery

9 January 2022

• curprev 15:0015:00, 9 January 2022‎ Helpful talk contribs‎ m 68,191 bytes +7‎ →‎Upsert
• curprev 13:2313: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..."