Search found 67 matches

by jmpoure
Tue May 24, 2011 9:42 am
Forum: [3.0/Olympus] New features discussion
Topic: PostgreSQL Fulltext Search
Replies: 40
Views: 100544

Re: PostgreSQL Fulltext Search

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 integ...
by jmpoure
Fri May 15, 2009 9:16 am
Forum: [3.0/Olympus] Discussion
Topic: Very long running query (600ms): could be security issue
Replies: 4
Views: 5268

Re: Very long running query (600ms): could be security issue

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 <= p2.po...
by jmpoure
Fri May 15, 2009 8:55 am
Forum: [3.0/Olympus] Discussion
Topic: Very long running query (600ms): could be security issue
Replies: 4
Views: 5268

Very long running query (600ms): could be security issue

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_id = ...
by jmpoure
Fri Mar 13, 2009 2:38 pm
Forum: [3.0/Olympus] Discussion
Topic: Long running SQL queries
Replies: 0
Views: 2334

Long running SQL queries

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, php...
by jmpoure
Mon Mar 09, 2009 11:23 am
Forum: [3.0/Olympus] New features discussion
Topic: PostgreSQL Fulltext Search
Replies: 40
Views: 100544

Re: PostgreSQL Fulltext Search

Is full-text search for PostgreSQL part of Phpbb3 main release?
by jmpoure
Thu Jun 05, 2008 10:48 am
Forum: [3.0/Olympus] New features discussion
Topic: Notation & evaluation mode
Replies: 1
Views: 4261

Notation & evaluation mode

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 only ...
by jmpoure
Thu Jun 05, 2008 10:32 am
Forum: [3.0/Olympus] Discussion
Topic: phpBB 3.2 Discussion
Replies: 257
Views: 174971

Re: phpBB 3.2 Discussion

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
by jmpoure
Thu Jun 05, 2008 9:18 am
Forum: [3.0/Olympus] New features discussion
Topic: PostgreSQL Fulltext Search
Replies: 40
Views: 100544

Re: PostgreSQL Fulltext Search

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_tsquer...
by jmpoure
Thu Jun 05, 2008 8:48 am
Forum: [3.0/Olympus] New features discussion
Topic: PostgreSQL Fulltext Search
Replies: 40
Views: 100544

Re: PostgreSQL Fulltext Search

wagnerch wrote:I added a new version to the first post that should support 8.3.
Thanks. I am testing your patch.
by jmpoure
Wed Mar 12, 2008 10:32 pm
Forum: [3.0/Olympus] Discussion
Topic: Feature request : customized DNSBL in ACP
Replies: 2
Views: 2720

Feature request : customized DNSBL in ACP

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 not ...