Thanks Arjen,<br>
<br>
my hardware is not so bad ;-) <br>
dual xeon 3.0GHz<br>
RAM 2Go<br>
but .... IDE 200Go HD<br>
<br>
I want to test all these on my SCSI HD server too when I have time.<br>
<br>
how many matches do you have in your results in general ? 100 ? 1000 ? more ?<br>
how many values do you store in xapian ?<br>
<br>
the times i provided are for first run queries of course :)<br>
<br><br><div><span class="gmail_quote">On 2/24/06, <b class="gmail_sendername">Arjen van der Meijden</b> <<a href="mailto:acmmailing@tweakers.net">acmmailing@tweakers.net</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
For our set-up I ran some tests and noticed the sorted-by-value runs<br>were indeed a slower, but not as dramatic as yours. It varied from 2 to<br>8 times as slow (the time Omega reports) than the non-value sorted<br>search. The query 'cpu ram' (wdf resp 80108 and 62900) took
0.107<br>seconds in relevance-sorting and 0.336 when sorting on a date.<br><br>Of course our hardware is (likely) much faster than yours, but our<br>database is larger too (1.1M documents and 12GB on disk in compacted<br>
flint). Are these the initial runs for those queries, or did you rerun<br>the tests a few times, i.e. its unfair to compare a non-cached<br>value-sorted run to a (then) cached relevance-sorted run.<br><br>Best regards,<br>
<br>Arjen<br><br>David Levy wrote:<br>> Ok for the directory :)<br>><br>> Here are some results :<br>><br>> (time /usr/local/lib/omega/bin/omega DB=products P=xxxxxxx SORT=3)<br>><br>> test paris<br>> real
0m5.130s<br>> user 0m0.035s<br>> sys 0m0.039s<br>><br>> paris france<br>> real 0m19.902s<br>> user 0m0.049s<br>> sys 0m0.116s<br>><br>> new york<br>> real 4m10.437s<br>> user
0m0.459s<br>> sys 0m1.601s<br>><br>> !!!!!!!!!!!!!!!!!!!!!!!!<br>><br>> that's crazy :)<br>><br>> maybe because today i don't hae many available RAM (i use most of my RAM<br>> to test RAMDISK for xapian on this server)
<br>><br>> what should i see with this figures ?<br>><br>> regards<br>><br>><br>> On 2/24/06, *Olly Betts* <<a href="mailto:olly@survex.com">olly@survex.com</a> <mailto:<a href="mailto:olly@survex.com">
olly@survex.com</a>>> wrote:<br>><br>> On Fri, Feb 24, 2006 at 02:35:46PM +0200, David Levy wrote:<br>> > Yes, I always use Omega PHP5 bindings were not available.<br>> > Do you think it would be faster with
0.9.3 + php5 bindings ??<br>><br>> I'd be suprised if it was.<br>><br>> > Thanks for the command, but I can't make it work. In which<br>> directory should<br>> > I execute it ?<br>
> > Here is the error :<br>> ><br>> > $ time /usr/local/lib/omega/bin/omega DB=products P='test query'<br>> SORT=1<br>> > Content-Type: text/html<br>> ><br>> > Exception: Couldn't read format template `query' (No such file or
<br>> directory)<br>><br>> Where is your omega.conf file? Where are the omegascript templates?<br>><br>> Cheers,<br>> Olly<br>><br>><br>><br>><br>> --<br>> David LEVY {selenium}
<br>> Website ~ <a href="http://www.davidlevy.org">http://www.davidlevy.org</a><br>> Wishlist Zlio ~ <a href="http://david.zlio.com/wishlist">http://david.zlio.com/wishlist</a><br>> <<a href="http://david.zlio.com/wishlist">
http://david.zlio.com/wishlist</a>><br>> Blog ~ <a href="http://selenium.blogspot.com">http://selenium.blogspot.com</a><br>><br>><br>> ------------------------------------------------------------------------
<br>><br>> _______________________________________________<br>> Xapian-discuss mailing list<br>> <a href="mailto:Xapian-discuss@lists.xapian.org">Xapian-discuss@lists.xapian.org</a><br>> <a href="http://lists.xapian.org/mailman/listinfo/xapian-discuss">
http://lists.xapian.org/mailman/listinfo/xapian-discuss</a><br></blockquote></div><br><br clear="all"><br>-- <br>David LEVY {selenium}<br>Website ~ <a href="http://www.davidlevy.org">http://www.davidlevy.org</a><br>Wishlist Zlio ~
<a href="http://david.zlio.com/wishlist">http://david.zlio.com/wishlist</a><br>Blog ~ <a href="http://selenium.blogspot.com">http://selenium.blogspot.com</a><br>