IWETHEY v. 0.3.0 | TODO
1,095 registered users | 1 active user | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / That's how I've already set it up
Post #100,740
by drewk
Picture of drewk
5/7/03 12:35:35 PM
Reply
New That's how I've already set it up
Dropping the state field entirely was just a possibility. I can't remember if it was MySQL or Postgres, but one of them allows you to define an index on a portion of a string. Then joins against that same portion -- ie: LEFT( countycode, 2 ) -- would be as fast as against a separate field.
===

Implicitly condoning stupidity since 2001.
Post #100,742
by admin
Picture of admin
5/7/03 12:41:23 PM
Reply
New It's not a matter of speed.
Embedded data is a bad idea.
Regards,

-scott anderson

"Welcome to Rivendell, Mr. Anderson..."
Post #100,744
by drewk
Picture of drewk
5/7/03 12:43:59 PM
Reply
New Generally I agree
But in this case we're going to start using the oficial county codes from the USPS, and the data is already there. I wouldn't advocate creating it that way, but since we're going to be getting the data that way it seems reasonable.
===

Implicitly condoning stupidity since 2001.
Post #100,757
by admin
Picture of admin
5/7/03 2:35:22 PM
Reply
New Even so.
You put the official county code in one column, and extract the state for the other column.
Regards,

-scott anderson

"Welcome to Rivendell, Mr. Anderson..."
Post #103,049
by tablizer
5/22/03 2:00:35 AM
Reply
New I agree with Malraux on this one
The county code could change in the future and no longer have state embedded in it. Best to keep an explicit State column around rather than parse the county ID to get State. "Smart ID's" are dangerous things.
________________
oop.ismad.com
     Is this schema screwed up, or is it just me? - (drewk) - (16) - May 7, 2003, 09:50:41 AM EDT
         Your new schema looks good. - (jbrabeck) - (2) - May 7, 2003, 10:31:20 AM EDT
             I guess what I'm looking for is ... - (drewk) - (1) - May 7, 2003, 10:46:26 AM EDT
                 Guessing - (jbrabeck) - May 7, 2003, 10:57:34 AM EDT
         Dependent Foreign Keys - (ChrisR) - (10) - May 7, 2003, 10:58:46 AM EDT
             Can't happen, each county is unique - (drewk) - (9) - May 7, 2003, 11:05:16 AM EDT
                 Still a function of integrity - (ChrisR) - (8) - May 7, 2003, 11:15:42 AM EDT
                     Don't even need a lookup table - (drewk) - (7) - May 7, 2003, 11:18:53 AM EDT
                         Maybe it's just me - (tseliot) - (6) - May 7, 2003, 11:46:48 AM EDT
                             Agreed. - (admin) - (5) - May 7, 2003, 11:51:52 AM EDT
                                 That's how I've already set it up - (drewk) - (4) - May 7, 2003, 12:35:35 PM EDT
                                     It's not a matter of speed. - (admin) - (3) - May 7, 2003, 12:41:23 PM EDT
                                         Generally I agree - (drewk) - (2) - May 7, 2003, 12:43:59 PM EDT
                                             Even so. - (admin) - May 7, 2003, 02:35:22 PM EDT
                                             I agree with Malraux on this one - (tablizer) - May 22, 2003, 02:00:35 AM EDT
         Thoughts... - (Simon_Jester) - (1) - May 10, 2003, 11:56:00 AM EDT
             You've about got it - (drewk) - May 12, 2003, 07:35:55 AM EDT

Gleefully participating in the heat death of the Universe!
90 ms