Development Discussion Board

Many thanks! Our website runs Phpbb3 with full-text search patch and works like a charm. This is PostgreSQL 9.0. The database is 3,7 Go (postgreSQL text dump). We have more than 1.000.000 messages. Will report back after we upgrade using GIT head. All queries run in 3/4 ms. I hope that you can ...

This query is slowing down my server considerably. Example :

2009-05-15 11:14:17 CEST LOG: durée : 630.813 ms, instruction : SELECT COUNT(p1.post_id) AS prev_posts
FROM phpbb_posts p1, phpbb_posts p2
WHERE p1.topic_id = 43596
AND p2.post_id = 792501
AND p1.post_approved = 1
AND p1.post_time ...

Hello,

My board has more than 600.000 messages. I log slow running queries, more than 30ms.

In the log, I can read every second or so:

<code>2009-05-15 10:31:46 CEST LOG: durée : 606.712 ms, instruction : SELECT COUNT(p1.post_id) AS prev_posts
FROM phpbb_posts p1, phpbb_posts p2
WHERE p1.topic ...

Dear Friends,

I migrated from PhpBB 3.02to 3.04. The forum is +500.000 posts. I log any SQL query which lasts more than 30 ms, which is max on PostgreSQL.

Here are examples:
2009-03-13 15:33:39 CET LOG: durée : 574.715 ms, instruction : SELECT COUNT(p1.post_id) AS prev_posts
FROM phpbb_posts p1 ...

Is full-text search for PostgreSQL part of Phpbb3 main release?

Dear friends,

We are running PhpBB forum with 500.000 posts .

We would like to allow users to note posts.
Typically stars suffice : one to five stars.

Are you planning integration of a notation mode in PhpBB 3.x ?
If not, which notation mode would you recommend?

This is currently our first and ...

Could you integrate PostgreSQL full-text patch please?
Please read : viewtopic.php?f=4&t=28707&st=0&sk=t&sd=a&start=23

This kind of patch is really needed on large forum.
Thanks in advance.

Jean-Michel

Good patch as usual. Works on our 500.000 posts forum.

Could you comment on your technical choices?
Why do you let Php parse messages instead of using PostgreSQL full-text parsing function ?

Basically, PostgreSQL full-text search documentation explains how parsing queries work:

SELECT plainto ...

wagnerch wrote:I added a new version to the first post that should support 8.3.

Thanks. I am testing your patch.

Hello,

My forum recently got hacked by no-life people.
When looking at the logs, I can notice a lot of them are blacklisted in DNSBL.
I had to install mod_defense for Apache using DNSBL.

Could it be possible for PhpBB 3.1 to enable custom DNSBL.
This is an important issue for webmasters that do ...