lucene-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "emilien beucler" <>
Subject Re: Is Lucene relevant for big amount of small dynamic data?
Date Mon, 15 Oct 2007 11:50:22 GMT

Thank you for this quick answer. Of course a relational database is the most 
immediate answer, but there are two problems:

- I am not sure that performances would be great when potentially each 
criteria can be used/combined for searches. I am not an expert of databases 
but I guess you have to choose the indexes you will want to use, so a few 
kinds of searches will be performant, others will not, right? What seemed 
interesting in Lucène is that it is said to be performant for all kinds of 

- With this model I cannot add criteria "on the fly". Let's say I want a new 
criterion: "olympic games Beijing 2008" That will apply to some of the 
hotels, for a certain time range. With Lucène I guess I could enrich the 
documents with the new criterion before adding them to the index. With a 
database, I can only reserve a fixed number of columns for that, or have 
more complex queries (without indexing). Do you see what I mean?

Thanks again,


>From: Kurt Haegeman <>
>Subject: Re: Is Lucene relevant for big amount of small dynamic data?
>Date: Mon, 15 Oct 2007 12:43:52 +0200
>emilien beucler wrote:
>>I need to implement a search tool, and I would like to know if Lucene 
>>could be used for my particular problem. Let's take an example:
>>A hotel company has several hundreds of hotels around the world. for each 
>>hotel there are hundreds of rooms, whose price are constantly changing. 
>>The idea is to create a multi-criteria search tool to find a room. The 
>>pieces of information to store are all the same, they are something like: 
>>(room_size, number_of_stars, city, date_of_arrival, number_of_beds, 
>>Let's says there are around 15 caracteristics, and about 5 millions pieces 
>>of information. The goal is to obtain a tool that:
>None of the criteria you mention justifies the use of a full-text search 
>solution. If I were you (but I'm not), I'd stick to a relational database 
>for this project. Even if there's a small field or two with searchable text 
>data, the database itself could cope with this (Oracle Text, MySQL 
>full-text search etc...).
>My 2 cents,
>To unsubscribe, e-mail:
>For additional commands, e-mail:

Windows Live Spaces : créez votre blog à votre image !

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message