<div>Olly,</div>
<div> </div>
<div>Thank for the suggestion to parse the query to multiple terms. Previously I implemented this same search engine using FullText Index in MySQL 5.0 having almost 1 million records (web pages) size of the table was approaching 3GB.
</div>
<div> </div>
<div>Running on the Suse 10.0 Pentium 2.8 GHz with 2 GB memory the search started to slow down using MySQL 5.0 where some results were coming after 10-15 seconds and the CPU usage was approaching 99% and memory usage 25%.
</div>
<div> </div>
<div>With Xapian I see CPU usage between 3-4% per search and memory usage only 0.3%.</div>
<div> </div>
<div>Check the Xapian performance for your self. :-)</div>
<div><a href="http://nitra.net/cgi-bin/hladaj.cgi?a=q&q=praha+hrad">http://nitra.net/cgi-bin/hladaj.cgi?a=q&q=praha+hrad</a></div>
<div> </div>
<div>Thanks.</div>
<div>Kevin Duraj</div>
<div> </div>
<div> </div>
<div><br><br> </div>
<div><span class="gmail_quote">On 3/1/06, <b class="gmail_sendername">Olly Betts</b> <<a href="mailto:olly@survex.com">olly@survex.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">On Wed, Mar 01, 2006 at 07:41:40AM -0800, Kevin SoftDev wrote:<br>> It works except the city is spelled praha, prague is the english version
<br>> <a href="http://nitra.net/cgi-bin/hladaj.cgi?a=q&q=praha">http://nitra.net/cgi-bin/hladaj.cgi?a=q&q=praha</a><br><br>Yeah, I'm aware that's the anglicised spelling - it was just the first<br>thing that came into my head to search for. The bug I was pointing out
<br>was the content-type, not the lack of results.<br><br>> One bug is still there that it works only with one term based on the<br>> Perl demo script that came with Xapian. As soon as user type two terms<br>> nothing come up. I am not sure if this is bug of Perl API or is mine.
<br>> [...]<br>> --- two terms is called like this?<br>> my $enq = $db->enquire( 'Praha Hrad' );<br><br>No, that produces a one term query with a space in. Try this:<br><br>my $qp = Search::Xapian::QueryParser->new();
<br># Set any options you want on $qp...<br>my $enq = $db->enquire($qp->parse_query('Praha Hrad'));<br><br>Cheers,<br> Olly<br></blockquote></div><br>