Re: TSearch vs. Homebrew

On Tue, 27 Jun 2006, Hannes Dorbath wrote:

> On 27.06.2006 13:31, Oleg Bartunov wrote:
>> On Tue, 27 Jun 2006, Hannes Dorbath wrote:
>>
>>> http://www.symfony-project.com/askeet/21
>>>
>>> How does this dead simple approach compare to TSearch performance /
>>> scaling wise?
>>
>> You miss the main point in tsearch2 - full integration with database, i.e.,
>> full access to metadata, ACID..... Lucene has no of these features, so it
>> could use some well known optimization
>> and, and so,  scales better. If you don't need ACID, metadata access, why
>> do you need database at all ?
>
> Yes, I know the benefits of using TSearch :) (I'm using it on many projects)
> I just found that article and wondered how well this simple approach might
> scale. Sorry for wasting your time ;)

Sorry, I was a bit off-topic. Lucene scales as any inverted index based
engine. In 8.2 tsearch2 also has inverted index support, but we obey
relational approach and couldn't provide a whole set of optimization,
which file based engines could provide.



     Regards,
         Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83