Hi Pat, Ever since I populated my table with 200,000+ entries, indexing has been causing high disk IO rate. I have since reduced the frequency, and it seems looks fine.
However, when it comes to search/will_paginate, it took ages to load the page, and most of the time it returns 500 Internal Server Error, or causes Passenger to crash. I checked my Apache error log, and it says: No data received from the backend application (process 3753) within 300000 msec. Either the backend application is frozen, or your TimeOut value of 300 seconds is too low. Please check whether your application is frozen, or increase the value of the TimeOut configuration directive. and... [ pid=3544 file=ext/apache2/Hooks.cpp:706 time=2010-11-17 20:46:41.780 ]: The backend application (process 3733) did not send a valid HTTP response; instead, it sent nothing at all. It is possible that it has crashed; please check whether there are crashing bugs in this application. Any way to go around this? Thanks. -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
