http://www.theserverside.com Most recent forum messages en Jive Forums Silver 5.5.30 (www.jivesoftware.com) Wed, 19 Jun 2013 01:16:24 -0400 http://www.theserverside.com/discussions/thread.tss?thread_id=58018 One approach is for the Lucene query to return primary keys. You can then use those to execute your sql query... where pk in (...)

Given you are often "paging" the search results this works well - limiting the number of primary keys to...]]> Fri, 16 Oct 2009 08:43:30 -0400 Fri, 16 Oct 2009 08:43:30 -0400 Fri, 16 Oct 2009 08:43:30 -0400 Oct 16, 2009 Martin Wildam 0 http://www.theserverside.com/discussions/thread.tss?thread_id=58018 Do not use SQL at all, why bother? :)
I mean it....]]> Fri, 16 Oct 2009 08:43:05 -0400 Fri, 16 Oct 2009 08:43:05 -0400 Fri, 16 Oct 2009 08:43:05 -0400 Oct 16, 2009 Martin Wildam 0 http://www.theserverside.com/discussions/thread.tss?thread_id=58018 Mon, 05 Oct 2009 17:28:52 -0400 Mon, 05 Oct 2009 17:28:52 -0400 Mon, 05 Oct 2009 17:28:52 -0400 Oct 5, 2009 rob bygrave 1 http://www.theserverside.com/discussions/thread.tss?thread_id=58018 And if I want to use Lucene over the DB fulltext features, how can I combine an SQL query with the fulltext results? - I do see a challenge here. Is there a solution? Do not use SQL at all, why bother? :) I mean it.]]> Fri, 02 Oct 2009 09:10:43 -0400 Fri, 02 Oct 2009 09:10:43 -0400 Fri, 02 Oct 2009 09:10:43 -0400 Oct 2, 2009 Istvan Soos 1 http://www.theserverside.com/discussions/thread.tss?thread_id=58018 Plus using a db's search means you will need a db....]]> Fri, 02 Oct 2009 06:08:44 -0400 Fri, 02 Oct 2009 06:08:44 -0400 Fri, 02 Oct 2009 06:08:44 -0400 Oct 2, 2009 Martin Wildam 4 http://www.theserverside.com/discussions/thread.tss?thread_id=58018 Generally, DB full text search has been very slow and lacking in customizability. I won't single any one out, but go do some perf tests and you will quickly see what I mean. They can be very useful for limited needs, but you will find...]]> Thu, 01 Oct 2009 13:28:15 -0400 Thu, 01 Oct 2009 13:28:15 -0400 Thu, 01 Oct 2009 13:28:15 -0400 Oct 1, 2009 Mark N 5 http://www.theserverside.com/discussions/thread.tss?thread_id=58018 Wed, 30 Sep 2009 08:53:26 -0400 Wed, 30 Sep 2009 08:53:26 -0400 Wed, 30 Sep 2009 08:53:26 -0400 Sep 30, 2009 Mark Miller 6 http://www.theserverside.com/discussions/thread.tss?thread_id=58018 Tue, 29 Sep 2009 15:07:34 -0400 Tue, 29 Sep 2009 15:07:34 -0400 Tue, 29 Sep 2009 15:07:34 -0400 Sep 29, 2009 augustientje bloem 0 http://www.theserverside.com/discussions/thread.tss?thread_id=58018 Tue, 29 Sep 2009 03:05:30 -0400 Tue, 29 Sep 2009 03:05:30 -0400 Tue, 29 Sep 2009 03:05:30 -0400 Sep 29, 2009 Nicholas Hrycan 0 http://www.theserverside.com/discussions/thread.tss?thread_id=58018 Mon, 28 Sep 2009 16:24:18 -0400 Mon, 28 Sep 2009 16:24:18 -0400 Mon, 28 Sep 2009 16:24:18 -0400 Sep 28, 2009 Mark Miller 0 http://www.theserverside.com/discussions/thread.tss?thread_id=58018 Mon, 28 Sep 2009 12:51:31 -0400 Mon, 28 Sep 2009 12:51:31 -0400 Mon, 28 Sep 2009 12:51:31 -0400 Sep 28, 2009 Mark N 0 http://www.theserverside.com/discussions/thread.tss?thread_id=58018 Near real-time search capabilities added to IndexWriter You have just made my day, thanks! Lucene was/is/will be great :) Btw, you have skipped a few version, why not 3.0 now?]]> Mon, 28 Sep 2009 11:48:08 -0400 Mon, 28 Sep 2009 11:48:08 -0400 Mon, 28 Sep 2009 11:48:08 -0400 Sep 28, 2009 Istvan Soos 0 http://www.theserverside.com/discussions/thread.tss?thread_id=58018 Mon, 28 Sep 2009 09:37:38 -0400 Mon, 28 Sep 2009 09:37:38 -0400 Mon, 28 Sep 2009 09:37:38 -0400 Sep 28, 2009 sheesh kebab 1 http://www.theserverside.com/discussions/thread.tss?thread_id=58018 Mon, 28 Sep 2009 07:56:37 -0400 Mon, 28 Sep 2009 07:56:37 -0400 Mon, 28 Sep 2009 07:56:37 -0400 Sep 28, 2009 Mark Miller 13