Performance of what? ;)
To talk about increasing (or decreasing) performance we should have
things to compare.
Relational database doesn't give full-text search capabilities.
Using LIKE SQL clause can't give some features (like sorting result set
by relevance) and needs full data scan (so Zend_Search_Lucene is much
more faster, except some trivial cases).
Some RDBMS offer full-text search extensions or you can use any special
product for full-text searching.
But we should compare concrete products. (We don't have any comparisons
with other products now, only some comparisons with Java Lucene)
It's clear they have all chances to be faster, but you have to choose
system according to simplicity of system installation and configuration,
performance, supported features (including supported query language) and
so on.
I can say that Zend_Search_Lucene is a good choice.
With best regards,
Alexander Veremyev.
José de Menezes Soares Neto wrote:
Nice! And it increases the performance??
----- Original Message -----
*From:* Alexander Veremyev <mailto:[EMAIL PROTECTED]>
*To:* José de Menezes Soares Neto <mailto:[EMAIL PROTECTED]>
*Cc:* [email protected] <mailto:[email protected]>
*Sent:* Tuesday, April 03, 2007 9:47 AM
*Subject:* Re: [fw-general] search engine
Hi José,
There are two possibilities:
1) As it already was mentioned by Joshua, it's possible to use your
database capabilities for full-text searching or use any other tool.
2) Use Zend_Search_Lucene as full-text index in addition to you
relational database.
It's not data duplication. You can store only index information without
storing field values.
Data from your relational database can be indexed absolutely the same
way you can index filesystem data.
Just use 'SELECT * ...' instead of fread() :)
With best regards,
Alexander Veremyev.
José de Menezes Soares Neto wrote:
> I am trying to explain what I want in a simple way...
>
> I want to create a search engine not for files, but for a
database with
> products. They produtcs will be sorted by date or price.
>
> I want to create a form input for it, but with Zend_Search its
possible?
> Cause I only found Zend_Search examples for files, not for
databases...
>
> Other question:
>
> What is the best way to build an search engine service (like
google or
> open directory project) using Zend Framework? I would like to
storage
> 100.000.000 records in the database...
>
> Thanks!
>
>
>
> ----- Original Message -----
> *From:* José de Menezes Soares Neto <mailto:[EMAIL PROTECTED]>
> *To:* Alexander Veremyev <mailto:[EMAIL PROTECTED]>
> *Cc:* [email protected]
<mailto:[email protected]> <mailto:[email protected]>
> *Sent:* Monday, April 02, 2007 3:10 PM
> *Subject:* Re: [fw-general] search engine
>
> Hi,
>
> But I already have a database, and this article shows how to
search
> an index created by zend_search_lucene
>
> So, I need to create a index from my database, and this is
not what
> they explain...
>
> Thanks!
>
>
> ----- Original Message -----
> *From:* Alexander Veremyev <mailto:[EMAIL PROTECTED]>
> *To:* José de Menezes Soares Neto <mailto:[EMAIL PROTECTED]>
> *Cc:* [email protected]
<mailto:[email protected]> <mailto:[email protected]>
> *Sent:* Monday, April 02, 2007 1:33 PM
> *Subject:* Re: [fw-general] search engine
>
> Hi,
>
> It looks like you need Zend_Search_Lucene component to be
used
> (http://framework.zend.com/manual/en/zend.search.html).
>
> Some number of Zend Search Lucene tutorials can be found
here -
> http://www.zftutorials.com/zend-search/
>
>
> With best regards,
> Alexander Veremyev.
>
>
> José de Menezes Soares Neto wrote:
> > hi friends,
> > how to create a search engine using zend framework??
> >
> > i have a database with a lot of products, and when
someone type
> > "notebook" for example, it searchs title and
description fields.
> >
> > best regards,
> >
> > José de Menezes
