SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    SitePoint Addict
    Join Date
    Jan 2007
    Posts
    323
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Getting around MySQL minimum word length with PHP

    Is there anyway to build your own fulltext search without using mysql's built in fulltext search? The reason is to get around the minimum word length setting if on a shared host where this setting can not be changed.

    I see vB and phpBB use word lists. Is there an example somewhere of how this is done or how to implement it?

  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)
    Check out Zend_Search_Lucene

    And, think twice, if you really want to index the short words.

  3. #3
    Theoretical Physics Student bronze trophy Jake Arkinstall's Avatar
    Join Date
    May 2006
    Location
    Lancaster University, UK
    Posts
    7,062
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    @atdev, lol - have you ever used vB's search?

    It'd be quicker to walk to australia (from the UK) and ask the sitepoint team themselves than do a search.
    Jake Arkinstall
    "Sometimes you don't need to reinvent the wheel;
    Sometimes its enough to make that wheel more rounded"-Molona

  4. #4
    An average geek earl-grey's Avatar
    Join Date
    Mar 2005
    Location
    Ukraine
    Posts
    1,403
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    MySQL's built-in fulltext isn't very fast on very large data sets either, although it should do better than wordlist table-based search.

  5. #5
    SitePoint Addict
    Join Date
    Jan 2007
    Posts
    323
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    @atdev, lol - have you ever used vB's search?

    It'd be quicker to walk to australia (from the UK) and ask the sitepoint team themselves than do a search.
    This was the least constructive response I have ever seen. If you do not suggest doing word tables then why are all scripts I have seen use them? Not to mention sitepoint is using vB which uses these.

    If you still do not suggest doing them, then is there a work around for it?

    What type of searching do you suggest if not fulltext?

  6. #6
    SitePoint Zealot
    Join Date
    Oct 2006
    Location
    Syracuse, NY
    Posts
    118
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well whatever Sitepoint uses for search should be banned, it's terribly slow for the most part.

  7. #7
    An average geek earl-grey's Avatar
    Join Date
    Mar 2005
    Location
    Ukraine
    Posts
    1,403
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by atDev View Post
    This was the least constructive response I have ever seen. If you do not suggest doing word tables then why are all scripts I have seen use them? Not to mention sitepoint is using vB which uses these.

    If you still do not suggest doing them, then is there a work around for it?

    What type of searching do you suggest if not fulltext?
    Something being widely used doesn't mean it also being decent.

    Fulltext searching is incompatible among database systems, so applications which aim at abstraction from database system and its version can't make use of fulltext searches. Unless they will write code for each system separately, of course.


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
  •