<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Kevin SoftDev wrote:
<blockquote
cite="mid562be3af0603010959n3ad4d7cfoc7788ff8a9c6526c@mail.gmail.com"
type="cite">
<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>
</blockquote>
Using xapian is the right thing, but with only 25% memory used I wonder
if you needed to allocate more buffer space or more index space to
improve search times.<br>
<br>
Sam<br>
<blockquote
cite="mid562be3af0603010959n3ad4d7cfoc7788ff8a9c6526c@mail.gmail.com"
type="cite">
<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="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">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>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
Xapian-discuss mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Xapian-discuss@lists.xapian.org">Xapian-discuss@lists.xapian.org</a>
<a class="moz-txt-link-freetext" href="http://lists.xapian.org/mailman/listinfo/xapian-discuss">http://lists.xapian.org/mailman/listinfo/xapian-discuss</a>
</pre>
</blockquote>
<br>
</body>
</html>