I've done some tests this morning and it seems that some of this slowlyness is due to sorting.<br>
<br>
Indeed, Omega requests with and with sorting do not produce the same
calculation time at all. < 1 s without sorting and sometimes > 30
s with sorting.... These 30 seconds happen with results having like
500+ matches. How can it be possible ? Sorting should not be so much
time consuming I guess. I think I am missing something in Omega cgi
parameters, Omega template, or scriptindex configuration.<br>
Can you help please :) ??<br>
<br>
For information, the field I use for sorting is a numeric field containing integers between ~ 1 and 100.<br>
<br>
Regards<br>
David <br>
<br><br><div><span class="gmail_quote">On 2/15/06, <b class="gmail_sendername">David Levy</b> <<a href="mailto:dvid.levy@gmail.com">dvid.levy@gmail.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;">
Hi (that's me again !! sorry :))<br>
<br>
I am experiencing bad response times with Xapian/Omega in the last few
days. My database has more than 700k records, using ~ 3Go disk space. <br>
Maybe my requests or my templates are not optimized, or maybe it's a
hardware (disk speed) issue. The weird thing is that often, the search
time provided in the response is sub second, and the response is
actually given by Omega over one second (even seconds ...). Did one of
you had this kind of issues ? Maybe my Apache (1.x) is not well
configured for Omega ? <br>
FYI, I am using PHP5 (so bindings are not available) and calling Omega
with HTTP GET requests returning XML documents between two servers.<br>
<br>
To solve this issue, I was been thinking about load balancing Xapian. I
could not find any information about that on Internet. One of you did
it yet ? How ? <br>
I've found Crossroads (<a href="http://public.e-tunity.com/crossroads/crossroads.html" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://public.e-tunity.com/crossroads/crossroads.html</a>) tonight, i think it could help :
<br>
"<em>Crossroads is a load balance and fail over utility for TCP
based services. It is a daemon program running in user
space, and features extensive configurability, polling of
back ends using 'wakeup calls', detailed status reporting,
'hooks' for special actions when backend calls fail, and much
more. Crossroads is service-independent: it is usable for
HTTP(S), SSH, SMTP, DNS, etc."<br>
<br>
</em>Thanks in advance !<br><span class="sg">
<br>-- <br>David LEVY {selenium}<br>Website ~ <a href="http://www.davidlevy.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.davidlevy.org</a><br>Wishlist Zlio ~ <a href="http://david.zlio.com/wishlist" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://david.zlio.com/wishlist</a><br>Blog ~ <a href="http://selenium.blogspot.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://selenium.blogspot.com</a><br>
</span></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>