matseng wrote:I'd be surprised if phpbb doesn't have support for putting the full text searching database (or a mirrored ReadOnly clone of it) on a separate db server to allow for searching without affecting the main db and the normal operations.
last time I checked - it didn't support anything similar.
contrary to common opinion phpbb is a piece of crap software with disgusting architecture and serious lack of both security and maintainability :( ... unfortunately it is very popular as from the user side it looks ok and ppl know how to use it as is common throughout the internet. Due to seriously flawed architecture if one would to patch it and add all the new functionality (I did few times moved some parts to a second server) you are either stuck with the version you created or you need to apply your patch every time you upgrade the piece of crap. There is no concept of plugins for phpbb - the "mods" they talk about are just a patches for the main source and they don't even use a proper patch system but a separate way more unsafe format they invented as "human readable".
as for the search capabilities, phpbb sucks big time. donno about few latest versions but it used to have 2 options
- use index created by phpbb system (works crappy, slows down insert of posts, clogs the database)
- use full text search ability of myisam storage engine (full text search in myisam works but is order of magnitude slower then specialized solutions like lucene, sphinx etc.. not to mention that myisam is by today's standards deprecated storage engine and that new mysql server pushes for dropping myisam completely getting innodb way faster in every segment of mysql usage)
moving phpbb's search engine to a new engine is possible but as I said for every future upgrade of the phpbb you need to do it again and the way updates go you often have to do it from scratch... since phpbb's security is piece of crap you have to upgrade phpbb every time the security updates are available 'cause there's gazilion little kids that call them self hackers that use those exploits to fsckup forums that are not up to date... I know some time ago phpbb dev's were discussing of adding a lucene search capability to phpbb especially as zend was then preparing Zend_Search_Lucene
but I don't know how far they went with it. I also know there was a mod for phpbb that was talked to be pushed into the main tree that use sphinx or to be more precise there was a talk that phpbb 3.1 will support sphinx out of the box .. donno if that's true iirc phpbb is still on 3.0 and 3.1 is still heavily beta .. depending on how many of the promised changes go into 3.1 it might be a quantum leap up from 3.0 .. but let's wait and see ... that's also a huge deterrent from investing time in fixing 3.0 and adding better search if 3.1 will have it out of the box as iirc 3.1 was already supposed to be out...