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 < [EMAIL PROTECTED]> 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?" >