I guess I'll have to wait until you've had a chance to mull the whole note
over ;-)

I really don't know what you're saying. I can't think of anything I said
that would have discouraged you from creating the association table.
Certainly the number of columns in the table shouldn't discourage you since
there are typically only two columns and they are usually both short codes.

The number of rows *may* be a concern though; if you have a lot of job
titles and a keep track of every job every member has had, you could end up
with a lot of rows. Maybe that's your concern.

In any case, I hope you can explain what you are going to do instead of the
association table if you have definitely abandoned it. Maybe we can critique
that design for you and help you improve it or at least avoid the most
common pitfalls.

Rhino




----- Original Message ----- 
From: "Stuart Felenstein" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; "Stuart Felenstein" <[EMAIL PROTECTED]>
Sent: Friday, August 27, 2004 4:47 PM
Subject: Re: Many to Many: Does this make sense ?


> Let me answer the first part now and then continue
> reading.
>
> You absolutely gave me some great ideas / examples.
> I understand it very well now.  I'm abandoning it
> solely because creating that association list -1) may
> take forever and still come up way short 2)I see how
> others have implemented the same type of application
> and have not provided specific job title allocation.
>
> I hope that gets you settled back again!
> Stuart
> --- Rhino <[EMAIL PROTECTED]> wrote:
>
> > My replies are interspersed below.
> >
> > Rhino
> >
> > ----- Original Message ----- 
> > From: "Stuart Felenstein" <[EMAIL PROTECTED]>
> > To: "Rhino" <[EMAIL PROTECTED]>;
> > <[EMAIL PROTECTED]>
> > Cc: <[EMAIL PROTECTED]>; "Stuart Felenstein"
> > <[EMAIL PROTECTED]>
> > Sent: Friday, August 27, 2004 3:05 PM
> > Subject: Re: Many to Many: Does this make sense ?
> >
> >
> > > Now I am totally clear on it! Took a few
> > reiterations
> > > but I'm there.  Even more I'm going to abandon the
> > > idea of titles.
> >
> > I was breathing a sigh of relief that we'd finally
> > articulated the idea
> > clearly enough. But now I'm not so sure....
> >
> > What do you mean you are going to "abandon the idea
> > of titles"?
> >
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to