SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Addict itsource's Avatar
    Join Date
    Jun 2001
    Location
    Thailand
    Posts
    369
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Search articles in database

    I create table to keep articles in database has following field

    id
    catagory
    name_article
    detail_article
    writer
    date

    if I want user to search article in database.

    Should I add 1 field that writer to type all keyworld about this article and search this field

    or

    search keyword that user enter in detail_article field?
    Is second method take more time?
    I live in Thailand. My English grammar not well.

  2. #2
    This is all Mumbo Jumbo Amit's Avatar
    Join Date
    Oct 2001
    Location
    New Delhi, India
    Posts
    277
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well it all depends on whether you articles are going to be large or small. If ther are going to be small you can search directly detail_article field, but if your articles are going to be large and there are gonna be many articles a keyword field would definately give you performance boost.

    Also try to index on keywords field.

    Whatever you choose personally I would recommend you to use the keywords fields for another reason, and that is you can include this keywords field in the meta tags for search engine spider ...

    Hope this help ...


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •