Re:How a SQL database works
by zaptheimpaler on Thursday December 19, 2019 @03:59PM
(#21839219)
Is a btree with a million nodes really going to be any easier to understand? Like I understand some times its better to have more realistic data (e.g for presenting results related to benchmarking performance), but for a post explaining the data structures behind a database it wouldn't help at all.
[ Parent
| on HN ]
Re:How a SQL database works
by metalliqaz on Thursday December 19, 2019 @04:06PM
(#21839297)
yeah, I think it would ultimately give the reader better understanding of how a real SQL system works. The idea, after all, is to give the reader an understanding that they can use to go on and create performant applications, right? If you create an application while thinking of the database as a 2d table with single digit dimensions, you may make some pretty big design missteps when it scales to hold real data.