Keywords solution
From: Leeper <Leeper_at_poczta.fm>
Date: Mon, 23 Jul 2001 16:48:16 -0400
Message-ID: <20010723.164816.1173951187.3830_at_leeper.localdomain>
Date: Mon, 23 Jul 2001 16:48:16 -0400
Message-ID: <20010723.164816.1173951187.3830_at_leeper.localdomain>
Hi,
I'm now designing a portal for press articles, which is to handle about
10000 of them (for now, will be more in future) within about 50
categories. Articles are to be searched by keywords (several for an
article). There are two main approaches:
- create a field within the article table, handling the keywords. When searching, select the articles that have the given keyword. 2)create two tables - one with id and keyword, and another with id of keyword and id of article that refers to the keyword. Which approach is faster in searching? Leeper
PS.
The application is to be written in PHP with MySQL.
Received on Mon Jul 23 2001 - 22:48:16 CEST