>I suspect Gunnar is dealing with the same issue we are -- we don't want
>to use both swish-e and the database, we just want to use one.
>Particularly when dealing with millions of documents, it's very hard to
>first do a full-text search, get all the results, then use those results
>as a way to filter a database query.

Exactly!

>I thought that swish-e did have some sort of numerical filter though --
>at least for dates?  Or am I thinking of something else?

You are right, it has a sort of numerical filter, and as I found out in the
meantime it should (with some "workaround") do what i need.

Best regards

Gunnar Mätzler


-----Ursprüngliche Nachricht-----
Von: swish-e@sunsite3.berkeley.edu
[mailto:swish-e@sunsite3.berkeley.edu]Im Auftrag von Tac Tacelosky
Gesendet: Montag, 6. Dezember 2004 16:23
An: Multiple recipients of list
Betreff: [SWISH-E] Re: Working with SwishSetSearchLimit (or -L)


In the ideal world, full-text and database searching would be tightly
integrated, and MySQL has done a pretty good job of doing that, but the
full-text search is not as fast or as strong as swish-e.

I suspect Gunnar is dealing with the same issue we are -- we don't want
to use both swish-e and the database, we just want to use one.
Particularly when dealing with millions of documents, it's very hard to
first do a full-text search, get all the results, then use those results
as a way to filter a database query.

I thought that swish-e did have some sort of numerical filter though --
at least for dates?  Or am I thinking of something else?

Tac


-----Original Message-----
From: swish-e@sunsite3.berkeley.edu
[mailto:swish-e@sunsite3.berkeley.edu] On Behalf Of Bill Moseley
Sent: Monday, December 06, 2004 9:39 AM
To: Multiple recipients of list
Subject: [SWISH-E] Re: Working with SwishSetSearchLimit (or -L)


On Mon, Dec 06, 2004 at 03:28:51AM -0800, Gunnar Mätzler wrote:
> Hello again,
>
> since there is (for the time beeing) no "numerical" search in swish-e,

> i learned it should be possible to achive the same by using the -L
> param or in my case SwishSetSearchLimit.
>
> However, what i am looking for is a way to get results like "All
> companies with more than 150 employees".

That sure sounds like a database query, not a full-text search.  Are you
sure you are using the right tool for the job?

--
Bill Moseley
moseley@hank.org

Unsubscribe from or help with the swish-e list:
   http://swish-e.org/Discussion/

Help with Swish-e:
   http://swish-e.org/current/docs
   swish-e@sunsite.berkeley.edu