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

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

Post by Daz » Thu, 03 May 2007 03:06:02


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.
 
 
 

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

Post by Joachim Du » Thu, 03 May 2007 03:58:47

Daz schrieb:

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

Regards,
Jo

 
 
 

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

Post by Daz » Fri, 04 May 2007 22:14:30


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.