A question about the Olympus search engine

[DragonlordP]

Hello, maybe this has been asked before but the search is disabled as you know.

I recently had some serious slowdown problems with my forum and the host said that it's a known phpbb problem that has to do with the way the search tables are created. So when you have a big forum, the whole thing like falls apart.
My host suggested that I optimize my databases, which I did and it helped, things are relatively better now (at least I don't need 10 minutes to load a page) but my host suggested that I use some other forum engine to make this problem go away - like vb. My question to you is this: the way the search engine in Olympus is designed, will this problem still exist? Basically all I want to know is if I should go for another forum engine or wait for olympus. Forums only get bigger and bigger, and I want this problem solved once and for all - that is, if olympus uses a better search engine than phpbb 2.0.x (as far as the slowdown goes) but still less good than vb or invision, I'll still go with one of the other two.
Thanks

[R45]

You can use MySQL's fulltext in phpBB, which would offer you much better performance for most forums. It eliminates phpBB's search tables and uses the built-in MySQL fulltext engine. Keep in mind though, when your forum gets very large, even MySQL's fulltext will become a problem.

In the meantime, you can implement delayed updates to the current phpBB 2.0 search which should help you greatly in posting/editing/deleting speeds, http://www.stardestroyer.net/Mike/GeekT ... _1_0_0.zip" target="_blank

[DragonlordP]

hmmm can you help me a bit with this mod? I have almost no experience with installing mods.. my problems are:

1. What do I do with this?

#
#-----[ SQL ]------------------------------------------
#
CREATE TABLE phpbb_search_delete (post_id MEDIUMINT(8));
CREATE TABLE phpbb_search_edit (post_id MEDIUMINT(8));
CREATE TABLE phpbb_search_new (post_id MEDIUMINT(8));


(I know how to find stuff in files and replace them as said in the file, but not sure what to do with this (I am not the webmaster of my forum, he's in the army now so I have to do it on my own)



2. What do I do with the file searchtable_update.php? Where do I have to upload it? Do I only have to run it once?


3. Do I do something with the file htaccess?

thanks

[Lastof]

Uh, if this is a mod you are trying to do for phpBB 2.0, I'd suggest asking over at http://www.phpBB.com/phpBB" target="_blank

If it's for olympus, well, no support. Sorry.

[skuddo]

for the SQL thing your gonna need something like phpMyAdmin. once you have that you just go to Import and put the SQL code in the big textfield.

[Spectral Dragon]

This board is extremely large and this is a runtime olympus reported on a search for my name:

Time : 0.095s

Much, much better performance search-wise IMO

[DragonlordP]

weeeell, it's not "extremely large", total posts are 80.000 and my forum has half a million..

[Spectral Dragon]

weeeell, it's not "extremely large", total posts are 80.000 and my forum has half a million..

I think 80 thousand is still a good high number for a search test. It's not simply 1000 or (like my board) near 8000 or the highly common 10,000

Also, I don't think some of the posts are counted because of the settings on some of the forums.

[DragonlordP]

Well, my phpbb 2.0.x forum never had slowdown problems before it reached 350.000 or 400.000 posts, so it would be a very unpleasant (and unreasonable) surprise if Olympus faced any problems with even half of that number.