Professional Web Applications Themes

Carrying out a full-text search, but without the full-text search... - MySQL

Hi everyone. I have a fairly simple question, but the answer is likely to be very complex. I would like to create a wiki that will allow full-text searches. However, as you know, full-text searches in a large database is very CPU intensive. I need to look into what options are available in the way of breaking everything down into keywords, and how I'd do it efficiently. I know that there is no definitive answer to my query, but I have no idea where to start looking. I would like to make my wiki very much like a small-scale search ...

  1. #1

    Default Carrying out a full-text search, but without the full-text search...

    Hi everyone.

    I have a fairly simple question, but the answer is likely to be very
    complex. I would like to create a wiki that will allow full-text
    searches. However, as you know, full-text searches in a large database
    is very CPU intensive. I need to look into what options are available
    in the way of breaking everything down into keywords, and how I'd do
    it efficiently. I know that there is no definitive answer to my query,
    but I have no idea where to start looking. I would like to make my
    wiki very much like a small-scale search engine. Much like Google, but
    far, far smaller by comparison.

    Google doesn't just do a full-text search on the several billion pages
    it has stored every time you make a query. They evidently have some
    algorithm running behind it all which breaks everything down very
    efficiently indeed.

    I would very much appreciate it if anyone could point me in the right
    direction, with any suggestions, whether thy be logic, doents I
    should read, or terms I can Google.

    Thanks in advance.

    Daz.

    Daz Guest

  2. #2

    Default Re: Carrying out a full-text search, but without the full-text search...

    Daz schrieb: 

    Try a FULLTEXT index.
    I have never used it, but it's supposed to do exactly what you want.

    Regards,
    Jo
    Joachim Guest

  3. #3

    Default Re: Carrying out a full-text search, but without the full-text search...

    Joachim Durchholz wrote: 
    >
    > Try a FULLTEXT index.
    > I have never used it, but it's supposed to do exactly what you want.
    >
    > Regards,
    > Jo[/ref]

    that's right. with a fulltext index you can do wonders however consider
    the limiations:
    1-works only in myisam tables
    2-collation dependent
    3-no column prefixes apply (obviously)

    --
    lark -- net
    To reply to me directly, delete "despam".
    lark Guest

  4. #4

    Default Re: Carrying out a full-text search, but without the full-text search...

    On May 1, 8:11 pm, lark <net> wrote: [/ref]


    >
    > that's right. with a fulltext index you can do wonders however consider
    > the limiations:
    > 1-works only in myisam tables
    > 2-collation dependent
    > 3-no column prefixes apply (obviously)
    >
    > --
    > lark -- net
    > To reply to me directly, delete "despam".[/ref]

    That's excellent. Thanks guys.

    I didn't realise you could use a full text index. I assumed that
    searching fulltext would be very heavy on resources.

    Thanks again.

    Daz Guest

Similar Threads

  1. sql server full-text search
    By fillae in forum Coldfusion - Advanced Techniques
    Replies: 6
    Last Post: May 12th, 01:27 PM
  2. Full text Boolean search
    By David in forum AIX
    Replies: 2
    Last Post: October 29th, 04:16 PM
  3. Full Text Search: How useful is it?
    By Tom in forum Microsoft SQL / MS SQL Server
    Replies: 5
    Last Post: August 8th, 06:16 AM
  4. full text search
    By Tommy in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: July 9th, 01:36 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139