SEO

#1 (**permalink**) 02-28-2008, 09:43 AM

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, documents I
should read, or terms I can Google.

Thanks in advance.

Daz.

#2 (**permalink**) 02-28-2008, 09:43 AM

Daz schrieb:
> I would like to create a wiki that will allow full-text
> searches.

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

Regards,
Jo

#3 (**permalink**) 02-28-2008, 09:43 AM

Joachim Durchholz wrote:
> Daz schrieb:
>> I would like to create a wiki that will allow full-text
>> searches.
>
> Try a FULLTEXT index.
> I have never used it, but it's supposed to do exactly what you want.
>
> Regards,
> Jo

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 -- hamzee@sbcdeglobalspam.net
To reply to me directly, delete "despam".

#4 (**permalink**) 02-28-2008, 09:44 AM

On May 1, 8:11 pm, lark <ham...@sbcdeglobalspam.net> wrote:
> Joachim Durchholz wrote:
> > Daz schrieb:
> >> I would like to create a wiki that will allow full-text
> >> searches.
>
> > Try a FULLTEXT index.
> > I have never used it, but it's supposed to do exactly what you want.
>
> > Regards,
> > Jo
>
> 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 -- ham...@sbcdeglobalspam.net
> To reply to me directly, delete "despam".

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

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