Re: Search Engine

From: stu <smcgouga_at_nospam.co.uk>
Date: Wed, 6 Nov 2002 09:50:22 -0000
Message-ID: <aqaom4$dmu$1$8300dec7@news.demon.co.uk>

Reffering to http://www.databaseanswers.com/data_models/search_engine.htm

Why duplicate the keyword field on the url_keyword table? I thought you should have an ID (counter) field on keywords table as a primary key. This keyword_id would then be used in url_keywords primary key.

I can see advantages in this design over mine: If you key URL_Keywords by keyword then Url_ID searching would be faster because we do not need to join Key_words table. But then whats the point in having the key_words table?

Cheers
Stu Received on Wed Nov 06 2002 - 03:50:22 CST