lucene-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chris Lu" <>
Subject Re: Boosting Search
Date Fri, 16 May 2008 17:37:12 GMT
You may need some more data to really compare the performance.

>From previous experience, I would expect MySql's search time would increase
as data grows, but Lucene's time stays almost unchanged.

Chris Lu
Instant Scalable Full-Text Search On Any Database/Application
Lucene Database Search in 3 minutes:
DBSight customer, a shopping comparison site, (anonymous per request) got
2.6 Million Euro funding!

On Fri, May 16, 2008 at 10:20 AM, Vinicius Carvalho <> wrote:

> Hello there! We are starting with lucene, and in order to prove it's usage
> one of the benefits is performance. I do know that lucene (as other full
> text search engines) provide many more benefits than using a SGDB.
> Ok, so here's a simple test:
> I have a Table with 17.700 rows. It is stored on mysql, and has no index on
> the title row.
> A query using: SELECT * FROM MOVIE WHERE LOWER(TITLE) like '%matrix%'. It
> returns 9 matches in 4ms (I'm not counting the opening connection time)
> Ok, now, I have indexed this same table in lucene (indexed title,id, and
> stored both). After performing a termquery(term("title","matrix")) the time
> was 27ms (not counting the indexsearcher  instantiation time).
> I know its a dumb test, but what can be done in order to speed things up?
> Regards
> --
> "In a world without fences and walls, who needs Gates and Windows?"

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message