[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
ex)
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!
http://auctions.yahoo.com
More information about the thelist
mailing list