Hello,

> Thank you! this wont slow updates or inserts?

Not the updates.  The update query will use the index to lookup find the
table line that it will update.  Then, since you will not change any of the
indexed columns the index does not need to be updated too.

Manuel Lemos


> 
> ----- Original Message -----
> From: "Manuel Lemos" <[EMAIL PROTECTED]>
> To: "Noah Spitzer-Williams" <[EMAIL PROTECTED]>
> Sent: Saturday, June 23, 2001 1:54 PM
> Subject: Re: [PHP-DB] advantages/disads of primary keys and indices?
> 
> 
> > Hello Noah,
> >
> > On 23-Jun-01 14:29:58, you wrote:
> >
> > >Yeah the keys would be part of the first condition of the where clause...
> >
> > >this table is like this:
> > >username | siteid | bannerid | clicks | someotherstat
> >
> >
> > >an update would be like: update tbl set clicks=clicks+1 where
> > >username='something' and siteid='something' and bannerid='something'
> >
> > >a select would be: select clicks from tbl where username='something' and
> > >siteid='something' and bannerid='something'
> >
> >
> > >so knowing this, does it make sense to make primary keys out of
> > >username,siteid,bannerid?
> >
> > Yes, you should make a single primary key with all the three fields:
> > username, siteid and bannerid.
> >
> >
> > Regards,
> > Manuel Lemos
> >
> > Web Programming Components using PHP Classes.
> > Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED]
> > --
> > E-mail: [EMAIL PROTECTED]
> > URL: http://www.mlemos.e-na.net/
> > PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
> > --
> >
> >


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to