[thelist] MySQL database optimis(z)ation

Kristy Frey kristenannfrey at yahoo.com
Mon Feb 4 11:31:01 CST 2002

3. something else entirely...

Possibly change the one table you have to include a story type field.

Then the table fields would be:
title, body, image, external link, internal link, author, id, story type

then create an index that includes the new field (i.e.  story type,id)

then for referencing purposes create a new table of story types that is made up of 2 fields:
story type, type description
story type    type description
NWS           News
EVT           Events
REV           Reviews

Then just pull from the first table by story type

Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!

More information about the thelist mailing list