RDBMS use and speed tweaking notes: Revision history

25 March 2024

• curprev 15:3115:31, 25 March 2024‎ Helpful talk contribs‎ m 75,394 bytes +552‎ →‎counting is slow
• curprev 13:3213:32, 25 March 2024‎ Helpful talk contribs‎ m 74,842 bytes +13‎ →‎counting is slow
• curprev 13:3213:32, 25 March 2024‎ Helpful talk contribs‎ m 74,829 bytes +80‎ →‎counting is slow
• curprev 13:3113:31, 25 March 2024‎ Helpful talk contribs‎ m 74,749 bytes 0‎ →‎counting is slow
• curprev 13:3113:31, 25 March 2024‎ Helpful talk contribs‎ m 74,749 bytes +92‎ →‎counting is slow

19 March 2024

• curprev 01:0101:01, 19 March 2024‎ Helpful talk contribs‎ m 74,657 bytes +4‎ →‎notes
• curprev 01:0001:00, 19 March 2024‎ Helpful talk contribs‎ m 74,653 bytes −2‎ →‎TABLESAMPLE

3 March 2024

• curprev 16:4916:49, 3 March 2024‎ Helpful talk contribs‎ m 74,655 bytes +8‎ →‎Memory
• curprev 14:3814:38, 3 March 2024‎ Helpful talk contribs‎ m 74,647 bytes −34‎ →‎Databases: IO bound
• curprev 14:3714:37, 3 March 2024‎ Helpful talk contribs‎ m 74,681 bytes +12‎ →‎Databases: IO bound
• curprev 14:3714:37, 3 March 2024‎ Helpful talk contribs‎ m 74,669 bytes +67‎ →‎Databases: IO bound
• curprev 14:3214:32, 3 March 2024‎ Helpful talk contribs‎ m 74,602 bytes +8‎ →‎order by random
• curprev 14:3114:31, 3 March 2024‎ Helpful talk contribs‎ m 74,594 bytes +4‎ →‎order by random
• curprev 14:2914:29, 3 March 2024‎ Helpful talk contribs‎ m 74,590 bytes 0‎ →‎Fetching random items and samples
• curprev 14:2914:29, 3 March 2024‎ Helpful talk contribs‎ m 74,590 bytes +48‎ →‎Fetching random items and samples

22 January 2024

• curprev 17:3017:30, 22 January 2024‎ Helpful talk contribs‎ m 74,542 bytes +10‎ →‎Upsert

4 November 2023

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

10 December 2022

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

16 September 2022

• curprev 16:4216:42, 16 September 2022‎ Helpful talk contribs‎ m 74,432 bytes +65‎ →‎Upsert
• curprev 16:4016:40, 16 September 2022‎ Helpful talk contribs‎ m 74,367 bytes +61‎ →‎Upsert
• curprev 16:3716:37, 16 September 2022‎ Helpful talk contribs‎ m 74,306 bytes +4‎ →‎Upsert

9 August 2022

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

25 June 2022

• curprev 21:0921:09, 25 June 2022‎ Helpful talk contribs‎ m 74,300 bytes +19‎ →‎Memory
• curprev 21:0821:08, 25 June 2022‎ Helpful talk contribs‎ m 74,281 bytes +154‎ →‎Memory

20 June 2022

• curprev 14:3814:38, 20 June 2022‎ Helpful talk contribs‎ m 74,127 bytes +4‎ →‎The value of caches
• curprev 14:3714:37, 20 June 2022‎ Helpful talk contribs‎ m 74,123 bytes −76‎ →‎The value of SSDs
• curprev 14:3514:35, 20 June 2022‎ Helpful talk contribs‎ m 74,199 bytes −32‎ →‎Databases: IO bound
• curprev 14:2414:24, 20 June 2022‎ Helpful talk contribs‎ m 74,231 bytes +141‎ →‎Disk and other hardware
• curprev 14:2114:21, 20 June 2022‎ Helpful talk contribs‎ m 74,090 bytes −366‎ →‎Memory
• curprev 14:1614:16, 20 June 2022‎ Helpful talk contribs‎ m 74,456 bytes −75‎ →‎TABLESAMPLE

19 June 2022

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

8 June 2022

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

19 May 2022

• curprev 22:4622:46, 19 May 2022‎ Helpful talk contribs‎ m 74,278 bytes +35‎ →‎Correlated subquery
• curprev 22:4522:45, 19 May 2022‎ Helpful talk contribs‎ m 74,243 bytes −24‎ →‎OUTER JOINs: LEFT JOIN, RIGHT JOIN, and FULL JOIN
• curprev 22:4522: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 01:2801:28, 18 May 2022‎ Helpful talk contribs‎ m 74,247 bytes +792‎ →‎Fetching random items and samples

9 May 2022

• curprev 01:0401:04, 9 May 2022‎ Helpful talk contribs‎ m 73,455 bytes +653‎ →‎select next ID
• curprev 00:4500:45, 9 May 2022‎ Helpful talk contribs‎ m 72,802 bytes +135‎ →‎random offset

8 May 2022

• curprev 18:3718:37, 8 May 2022‎ Helpful talk contribs‎ m 72,667 bytes +7‎ →‎random offset
• curprev 18:3718:37, 8 May 2022‎ Helpful talk contribs‎ m 72,660 bytes +1‎ →‎order by random
• curprev 15:1515:15, 8 May 2022‎ Helpful talk contribs‎ m 72,659 bytes +38‎ →‎fragmentation
• curprev 15:1515:15, 8 May 2022‎ Helpful talk contribs‎ m 72,621 bytes +67‎ →‎On foreign keys
• curprev 14:4814:48, 8 May 2022‎ Helpful talk contribs‎ m 72,554 bytes +77‎ →‎Indexing
• curprev 14:4714:47, 8 May 2022‎ Helpful talk contribs‎ m 72,477 bytes +223‎ →‎Disk and other hardware
• curprev 14:4014:40, 8 May 2022‎ Helpful talk contribs‎ m 72,254 bytes +50‎ →‎Memory
• curprev 14:3514: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 23:0923:09, 25 April 2022‎ Helpful talk contribs‎ m 72,204 bytes +1,846‎ →‎Multiple cursors

21 April 2022

• curprev 13:5213:52, 21 April 2022‎ Helpful talk contribs‎ m 70,358 bytes +59‎ →‎The value of caches
• curprev 13:5113:51, 21 April 2022‎ Helpful talk contribs‎ m 70,299 bytes +1‎ →‎The value of caches