On Wed, May 22, 2002 at 07:17:12PM -0500, Lee Daniel Crocker wrote:
To test my assumption of encapsulation I did in fact replace the
namespace fields in both the "cur" and "old" tables with integers.
This should keep the database smaller and speed it up.
For indexed fields this speed-up will be negligible.
I'm also not thrilled with the linked/unliked
tables. I'm thinking
of replacing them with a single "X links to Y" table using integer
indexes.
I considered that when designing them but also here indices are defined so
the speed-up will be very small and having the full title there helps to
avoid certain joins which are not negligible.
I'm also open to suggestions about how to change
cur_ind_title.
What is wrong with it?
-- Jan Hidders