Re: About Website Search Engine

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



note: i never said this was an optimal solution; i just said thats what ive
seen.
obviously i havent worked on any major search engine to date.
in fact i was fishing a bit for some info on how to do it right.

On 7/5/07, Robert Cummings < robert@xxxxxxxxxxxxx> wrote:
If you need to use MySQL use the MATCH
AGAINST syntax since it will index the data and search much faster. I've
heard tell it sucks beyond a certain size, but it's great for quick
solutions and moderate sized data. If you need something more powerful
look into something like Lucene.

thanks Robert,

-nathan


On 7/5/07, Robert Cummings < robert@xxxxxxxxxxxxx> wrote:

On Thu, 2007-07-05 at 22:26 -0400, Nathan Nobbe wrote:
> Kevin,
>
> just like Daniel said,
> > $sql .= "OR product_description *LIKE '%".$terms."%'"*;
>
> most of the *search engines* ive seen revolve around the use of the LIKE

> construct<
http://dev.mysql.com/doc/refman/5.1/en/string-comparison-functions.html#operator_like
>
> which is a simplified regex mechanism for an SQL query [for MySQL at
least,
> probly other RDBMS' as well]

Don't do that. Unless you have a teency weency set of data don't use
LIKE syntax to match data. It's extremely inefficient and requires
scanning the entire table. If you need to use MySQL use the MATCH
AGAINST syntax since it will index the data and search much faster. I've
heard tell it sucks beyond a certain size, but it's great for quick
solutions and moderate sized data. If you need something more powerful
look into something like Lucene.

Cheers,
Rob.
--
.------------------------------------------------------------.
| InterJinn Application Framework - http://www.interjinn.com |
:------------------------------------------------------------:
| An application and templating framework for PHP. Boasting  |
| a powerful, scalable system for accessing system services  |
| such as forms, properties, sessions, and caches. InterJinn |
| also provides an extremely flexible architecture for       |
| creating re-usable components quickly and easily.          |
`------------------------------------------------------------'



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux