lucene-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Sojan <ilikeu...@gmx.net>
Subject Re: Database integration best practices ...
Date Wed, 27 Mar 2002 12:57:43 GMT
On Wed, Mar 27, 2002 at 10:53:30AM +0000, geoff webb wrote:

> Either:
> 
>    SELECT * FROM atable WHERE id IN ( 12, 23, 34 ... )
> 
> OR
> 
>    SELECT * FROM atable WHERE id = 12 OR id = 23 OR id = 34 OR
> 

Of course it has to be OR'ed. Must have been an "Freudian typo" :)

> Flow of retrieving an entry would be:
> 
>   search index
>      -> present results (from index)
>         -> select desired result (from database)
> 

This should be the right way to go. I just don't want to let my index grow
that much, but as you mention going directly into the database for displaying 
results would cause prohibitive bottlenecks in the backend ...

Thx
Peter


--
To unsubscribe, e-mail:   <mailto:lucene-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:lucene-user-help@jakarta.apache.org>


Mime
View raw message