Yeah, if I had been the one to design this database, it would have primary and foreign keys and it wouldn't be the mess it is now. That's one of the first things I do when I design a db. Figure out what the unique key is going be and how the tables are related to each other. I usually do add additional indexes as well, but didn't think to check if this field was indexed, which was a rookie mistake. Oh well. Live and learn.
The data I'm working with is a colossal mess. I've been freaking out over the condition of it since I started working here. Legacy code (and data) is such a joy to work with. :-/
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
timeasmymeasure
no subject
Date: 2009-07-22 02:39 pm (UTC)The data I'm working with is a colossal mess. I've been freaking out over the condition of it since I started working here. Legacy code (and data) is such a joy to work with. :-/