Search found 140 matches

by Albert Wiersch
Fri Nov 16, 2018 7:34 pm
Forum: phpBB Discussion
Topic: Why require username for forgotten password?
Replies: 53
Views: 6501

Re: Why require username for forgotten password?

As of phpBB 3.2.4-RC1 the username is not required any more. https://tracker.phpbb.com/browse/PHPBB3-10432 https://github.com/phpbb/phpbb/pull/4223 Awesome! And it only took a little more than 7 years since I started this topic! :D But seriously... I'm happy to see this change made. A special thank...
by Albert Wiersch
Fri Mar 30, 2018 1:30 pm
Forum: [3.2.x] Support Forum
Topic: Slow searches on new Linode machine
Replies: 56
Views: 4021

Re: Very slow searches for simple words

Also, try enabling mbstring on your server. I asked my buddy to go ahead and enable that and HOLY CRAP!! That must have been it because searches are VERY FAST now. There should be a warning about this somewhere in the phpBB Administration Control Panel if mbstring is not enabled! Now I can turn bac...
by Albert Wiersch
Fri Mar 30, 2018 4:52 am
Forum: [3.2.x] Support Forum
Topic: Slow searches on new Linode machine
Replies: 56
Views: 4021

Re: Very slow searches for simple words

Find this line (line 669 in 3.2.2) $hilit = str_replace(' ', '|', $hilit); replace it with $hilit = false; Not truly tested but I am sure there will be no more highlights visible. edit: tested after I did recreate the index, it doesn't show the results in other pages. Thanks. Too bad it also doesn'...
by Albert Wiersch
Fri Mar 30, 2018 4:33 am
Forum: [3.2.x] Support Forum
Topic: Slow searches on new Linode machine
Replies: 56
Views: 4021

Re: Very slow searches for simple words

Interesting. It's impossible to know for sure what's making it slow on your installation without profiling it. If it's not the regexp used in preg_replace() then the second likeliest culprit would be the algorithm in get_context() , although I can't reproduce it locally. You can test this hypothesi...
by Albert Wiersch
Fri Mar 30, 2018 12:32 am
Forum: [3.2.x] Support Forum
Topic: Slow searches on new Linode machine
Replies: 56
Views: 4021

Re: Very slow searches for simple words

Alternatively, you can comment the 3 individual lines that contain the <span class="posthilit"> part. That's lines 1089, 1172 and 1173 on my local copy. That got rid of the highlights but it didn't fix the search time problem... so you get the bad stuff but not the good stuff. Maybe the problem is ...
by Albert Wiersch
Thu Mar 29, 2018 11:18 pm
Forum: [3.2.x] Support Forum
Topic: Slow searches on new Linode machine
Replies: 56
Views: 4021

Re: Very slow searches for simple words

JoshyPHP wrote:
Thu Mar 29, 2018 11:05 pm
Based on a cursory examination of the file, I don't believe there are any side-effects to disabling highlighting apart from the obvious.
Unfortunately I think I found one... I updated my previous post with it.
by Albert Wiersch
Thu Mar 29, 2018 10:48 pm
Forum: [3.2.x] Support Forum
Topic: Slow searches on new Linode machine
Replies: 56
Views: 4021

Re: Very slow searches for simple words

JoshyPHP, Again, thank you so much for helping me find this issue. It was really irritating me! But what do I do here? I really like the search highlights but the search time is a huge problem and is unacceptable. If the only practical solution to fixing search times is to disable highlighting by ma...
by Albert Wiersch
Thu Mar 29, 2018 9:23 pm
Forum: [3.2.x] Support Forum
Topic: Slow searches on new Linode machine
Replies: 56
Views: 4021

Re: Very slow searches for simple words

You may also try to edit search.php and replace $hilit = str_replace(' ', '|', $hilit); with $hilit = ''; to see if disabling this feature makes any difference with the slow search terms. That made a HUGE difference and must be it! But what does this mean exactly and how do I bring this feature bac...
by Albert Wiersch
Thu Mar 29, 2018 7:31 pm
Forum: [3.2.x] Support Forum
Topic: Slow searches on new Linode machine
Replies: 56
Views: 4021

Re: Very slow searches for simple words

You'd need to profile the script to see where most of the time is spent. That's something that's easier to do on a development server rather than live. Thanks. I have never profiled a PHP script before so I'd have to figure this out. If you post a copy of your phpinfo() it may reveal some important...
by Albert Wiersch
Thu Mar 29, 2018 2:36 pm
Forum: [3.2.x] Support Forum
Topic: Slow searches on new Linode machine
Replies: 56
Views: 4021

Re: Very slow searches for simple words

It's Linode virtual server but my buddy who manages it for me replicated the system on a dedicated machine and it still had the same problem. We've checked the databases for errors and they came back "OK". So we are (still) stumped too and have just been living with it for almost a year now because ...
by Albert Wiersch
Thu Mar 29, 2018 2:24 pm
Forum: [3.2.x] Support Forum
Topic: Slow searches on new Linode machine
Replies: 56
Views: 4021

Re: Very slow searches for simple words

But 25 seconds for a search? Is it normal for some phpBB search to be that slow? It's not just "apple" as that was just an example. I could come up with some other slow searches, and sometimes they are so slow that they just time out. A search for "optimization" comes back rather quickly and has 29 ...
by Albert Wiersch
Thu Mar 29, 2018 2:06 pm
Forum: [3.2.x] Support Forum
Topic: Slow searches on new Linode machine
Replies: 56
Views: 4021

Re: Very slow searches for simple words

Thank you. I've enabled 'Cookie secure'.
by Albert Wiersch
Thu Mar 29, 2018 1:43 pm
Forum: [3.2.x] Support Forum
Topic: Slow searches on new Linode machine
Replies: 56
Views: 4021

Re: Very slow searches for simple words

Mick wrote:
Thu Mar 29, 2018 1:10 pm
Can you supply a user/test account as you have search turned off for guests please?
I will PM a test account to you. Thank you!
by Albert Wiersch
Thu Mar 29, 2018 1:04 pm
Forum: [3.2.x] Support Forum
Topic: Slow searches on new Linode machine
Replies: 56
Views: 4021

Re: Very slow searches for simple words

Did you try the MySQL Fulltext for the "Search backend". Yes, tried that and just tried again (and I did rebuild the MySQL Fulltext index before searching). A search for "apple" took about 26 seconds. The index rebuild took less time than the search for "apple". The rebuild took about 6 seconds wit...
by Albert Wiersch
Thu Mar 29, 2018 4:47 am
Forum: [3.2.x] Support Forum
Topic: Slow searches on new Linode machine
Replies: 56
Views: 4021

Very slow searches for simple words

I'm running phpBB 3.2.2 with PHP 7.1.15, mysqli (MariaDB), (FPM/FastCGI) and phpBB Native Fulltext search backend. Searching for something like "apple" can take around 25 seconds which seems rather ridiculous. I don't seem to have performance issues with anything else on the server and other forum p...

Go to advanced search