SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    SitePoint Enthusiast jtucholski's Avatar
    Join Date
    Nov 2005
    Posts
    27
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Search Functionality

    When a website adds search functionality, more so than bulletin boards, but take the Facebook for example (not as complex as what they do but a good example, and the only i can think of at the moment). You can do a basic search for 'John' and the results returned will contain people named John, it will contain people who date a John, anyone who remotely has 'John' show up in any field in their profile.

    Is the query for this simply a matter of a large amount of OR statements is there something else to it?


    Thanks, happy holidays.
    --
    Regards
    Josh

  2. #2
    An average geek earl-grey's Avatar
    Join Date
    Mar 2005
    Location
    Ukraine
    Posts
    1,403
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Can be that, but also can be fulltext search.

  3. #3
    SitePoint Enthusiast jtucholski's Avatar
    Join Date
    Nov 2005
    Posts
    27
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Does the fulltext search just work on individual fields, or does it work across a database? I've never used it before. I'll google it real quick but any short pieces of advice are always welcome. Thanks.
    --
    Regards
    Josh

  4. #4
    SitePoint Enthusiast jtucholski's Avatar
    Join Date
    Nov 2005
    Posts
    27
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    From the short time i spent looking at it, it says that 5.0 full text indexing is supported with MyISAM tables only. Does that mean we need to support our own referential integrity then?
    --
    Regards
    Josh

  5. #5
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    yes

  6. #6
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,247
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    tough call, isn't it? do you feel the need to squeeze every last picosecond of performance and penny out of your possibly limited webhosting resources, or would you prefer to have accurate data?

    i kill myself sometimes

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  7. #7
    SitePoint Enthusiast jtucholski's Avatar
    Join Date
    Nov 2005
    Posts
    27
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'll take accurate data over it anytime.... I've seen some info regarding plugins to add fulltext search functionality.... i'll look into those.
    --
    Regards
    Josh


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
  •