ASE Database forum - Enhanced full-text search references?

Author

Enhanced full-text search references?

robert.gumpertz@lexisnexis.com

2005-10-27, 8:21 am

We are evaluating EFTS, and would like feedback from
current/past users. Has anyone out there implemented in
production, or tried? If so, how did it scale? Any input
would be most appreciated.

Michael Peppler

2005-10-27, 8:21 am

On Thu, 20 Oct 2005 11:40:51 -0700, robert.gumpertz wrote:

> We are evaluating EFTS, and would like feedback from current/past users.
> Has anyone out there implemented in production, or tried? If so, how did
> it scale? Any input would be most appreciated.

I've used and still maintain a site that uses it. It works pretty well,
but it uses a lot of resources (in my case the table being indexed has
about 5.5 million rows, and the text engine uses a *lot* of filehandles
and 400+MB of RAM).

I'm running this on a 4 CPU linux machine.

Michael
--
Michael Peppler [TeamSybase] mpeppler@peppler.org - http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html

Bob Gumpertz

2005-10-27, 8:22 am

> On Thu, 20 Oct 2005 11:40:51 -0700, robert.gumpertz wrote:
>
> input would be most appreciated.
>
> I've used and still maintain a site that uses it. It works
> pretty well, but it uses a lot of resources (in my case
> the table being indexed has about 5.5 million rows, and
> the text engine uses a *lot* of filehandles and 400+MB of
> RAM).
>
> I'm running this on a 4 CPU linux machine.
>
> Michael
> --
> Michael Peppler [TeamSybase] mpeppler@peppler.org -
> http://www.peppler.org/ Sybase DBA/Developer
> Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html
>
>
Michael,
Many thanks for the feedback. One of the indexed tables in
our initial implementation of EFTS has ~1.5 million rows and
grows rapidly. We were assuming we could run the text
server on the same host with the dataserver, but based on
your intelligence it seems a modest ancillary box would be
more appropriate.

Sponsored Links