Re: Stupid Database Tricks
From: Laconic2 <laconic2_at_comcast.net>
Date: Sat, 19 Jun 2004 09:19:34 -0400
Message-ID: <3eWdnVWUzoqXoEndRVn-hg_at_comcast.com>
Date: Sat, 19 Jun 2004 09:19:34 -0400
Message-ID: <3eWdnVWUzoqXoEndRVn-hg_at_comcast.com>
- All of the tables are exactly 80 bytes wide. It's for historical reasons...
- For efficiency, all of the sets we work with are maintained by doubly linked lists. See those two columns called NEXT_ID and PRIOR_ID? That's what they do. The old CODASYL DBMS did that for us automatically, but when we moved to relational we found we had to do it ourselves!