[thelist] MySQL database optimis(z)ation

[Kristy Frey]

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