[bbDev] Suggestions for search

[Matt Mullenweg]

fernando wrote:
> Notice that the 'topics' table maintains a 'last post ID'. Why? You can 
> determine the "last post" via the post_time. Posts should maintain 
> topic_id, not the other way around. Then the topic table will not have 
> to be updated every time someone posts a followup.

This is a redundancy for the sake of optimization, it makes things much 
faster.

> B) You're only searching the topic title. Not the message body.

The search page does 3 types of searches: topic title, post content, and 
post content relevancy.

-- 
Matt Mullenweg
http://photomatt.net  | http://wordpress.org
http://pingomatic.com | http://cnet.com