Ned Batchelder said: > That's not "good database design", it's relational dogma.
You are correct, it is indeed relational dogma. My appologies, it's merely a knee-jerk response from having to support a legacy database that's not going away for many years that was designed by relational heretics. They found ways to break pretty much every rule that Codd proposed. Unfortunately they did not have the justification of appropriateness to the application. I'm inclined to agree that in this case, if you treat the point collection as an opaque object, a blob will be just fine. I've unfortunately had a lot of opaque data inflicted on me that I actually need to query the parsed form of, and that biases me. Clay -- Lazarus Notes from Lazarus Internet Development http://www.lazarusid.com/notes/ Articles, Reviews and Commentary on web development