Website search feature - Spider or Database

Not for 'how-to' coding questions but PHP theory instead, this forum is here for those of us who wish to learn about design aspects of programming with PHP.

Moderator: General Moderators

Post Reply
timclaason
Forum Commoner
Posts: 77
Joined: Tue Dec 16, 2003 9:06 am
Location: WI

Website search feature - Spider or Database

Post by timclaason »

Is it best to design a site so that all page content is in a database, and you do the search with a SQL query, or is it better to have content in pages, and have some spidering that a search feature can use?

It seems to me that it's better to keep page content in a database, if possible, but I'm not sure if there's a consensus or not.
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post by John Cartwright »

In terms of searchability, I would defiantly choose a database. Google around for fulltext, and you'll quickly see why :wink:
Post Reply