lucene-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chris Lu" <chris...@gmail.com>
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
site: http://www.dbsight.net
demo: http://search.dbsight.com
Lucene Database Search in 3 minutes:
http://wiki.dbsight.com/index.php?title=Create_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 <
viniciusccarvalho@gmail.com> 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?"
>

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