hmmm that's not such a random idea ;-)<br>
Actually I store 5 other values which I don't really use yet. Can I
delete them from my database without having to reindex it all (very
long :()) ? <br>
<br>
My value DB file is 1Go file. I have 2Go RAM, so I guess I could cache the entire file yes ... <br>
<br>
Actually I am using /dev/shm filesystem instead of RAMDISK for test purpose.<br>
<br>
I think I should remove some values as I understand it would really help....<br>
<br><br><div><span class="gmail_quote">On 2/24/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: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On Fri, Feb 24, 2006 at 03:36:42PM +0200, David Levy wrote:<br>> new york<br>> real 4m10.437s<br>> user 0m0.459s<br>> sys 0m1.601s<br>><br>> !!!!!!!!!!!!!!!!!!!!!!!!<br>><br>> that's crazy :)
<br><br>And rather revealing!<br><br>> what should i see with this figures ?<br><br>You want real - (user+sys) to be much lower. Assuming there's no other<br>load on the server, and you're only running one test search at a time,
<br>the difference will be pretty much entirely I/O overhead.<br><br>> maybe because today i don't hae many available RAM (i use most of my RAM to<br>> test RAMDISK for xapian on this server)<br><br>How much RAM does the server have?
<br><br>I don't know if the Linux VM system understands what a RAM disk is - if<br>not it may be trying to cache blocks from it, which would be unhelpful<br>at best.<br><br>If Xapian's value.DB file is comfortably less than the free RAM, then
<br>you could try using the database from disk, but before running tests<br>do:<br><br>cat value.DB > /dev/null<br><br>That should make sure most of the file is cached.<br><br>Hmm, one random thought - how many values are you adding per document?
<br>Currently both quartz and flint have to retrieve all the values for a<br>document to get just one, which isn't a good design for how values<br>are generally used... But that means having unused "sort keys" around
<br>currently actually makes all sorting slower.<br><br>Cheers,<br> Olly<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>