Software Channels

One of the things that you only find out, if you start to handle a few million files is, that MySQL is pretty cool, but if you do not 100% know, what you do, it can get pretty slow on bad SQL statements. But there is help:

http://enterprise.phpmagazine.net/2006/11/setup_an_open_source_search_en.html

We are implementing sphinx right now and it looks GREAT! That baby is fast and it takes custom datafeeds right out of the database to index and search.

You have to check-out and compile the sources right now, but I think next week we are ready to switch to sphinx for all searches on tradebit, which should speed us up like we need it for the new files coming soon.

This entry was posted on Thursday, May 31st, 2007 at 1:41 pm and is filed under Software. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.