Whenever I am browsing the forums, sometimes the web page hangs and I get the attached error. I happens to me at work and at home so its not my computer. Also I am not using a proxy in either location, so its not that. I seem to be getting the problem fairly often nowdays.
Yup - I'm aware of it. AD described the general problem above. It a priority to fix. We're working on moving the entire search functionality of the Dropzone.com forums onto it's own search server.
MySQL is not that great at doing full text searches. We're setting up a separate and new server called Lucene. This will take over the entire searching functionality of the forums.
Searches eats up a lot of server resources on this site. We've done more than 700 searches in the last 24 hours! I never knew people were doing that many. We're quite a way down the path of developing and implementing this. In fact, I've been able to test it since last night. Just to give you an idea of the difference here's a result from the new server:
Search results: --------------------- Your search for skydive returned 30633 results in 0.371 seconds! ---------------------
And that's on a small testing machine! Just tried that same search on the current forums and it took more than 25 seconds to return the results.
Once this is set up were hoping to release a lot of database connections which should solve the Proxy Error issues we've been having. If they persist, well.... then I guess we'll look at some alternative optimizations and maybe some additional hardware. I'm optimistic though. I think the new search is going to rock!
Jun 14, 2004, 12:55 PM
Post #6 of 8