Search found 230 matches

by DavidMJ
Mon Jan 07, 2008 10:26 pm
Forum: [3.0/Olympus] Discussion
Topic: SQL optimisation
Replies: 70
Views: 53544

Re: SQL optimisation

jmpoure wrote:I am in charge of handling the various databases that phpBB is supported on.
I always do my query work on PostgreSQL as it is the most strict :)
by DavidMJ
Mon Jan 07, 2008 10:16 pm
Forum: [3.0/Olympus] Discussion
Topic: SQL optimisation
Replies: 70
Views: 53544

Re: SQL optimisation

jmpoure wrote:

Code: Select all

CREATE INDEX phpbb_forums_left_id
  ON phpbb_forums
  USING btree
  (right_id);
That looks like a bug, no?
by DavidMJ
Mon Jan 07, 2008 10:13 pm
Forum: [3.0/Olympus] Discussion
Topic: SQL optimisation
Replies: 70
Views: 53544

Re: SQL optimisation

Wow, I cannot believe we have missed this... Thanks for that!
by DavidMJ
Mon Jan 07, 2008 9:43 pm
Forum: [3.0/Olympus] Discussion
Topic: SQL optimisation
Replies: 70
Views: 53544

Re: SQL optimisation

Thank you very much for your efforts :)
by DavidMJ
Mon Jan 07, 2008 9:41 pm
Forum: [3.0/Olympus] Discussion
Topic: SQL optimisation
Replies: 70
Views: 53544

Re: SQL optimisation

I will look at this locally, I should have patches in CVS soon
by DavidMJ
Mon Jan 07, 2008 5:49 pm
Forum: [3.0/Olympus] Discussion
Topic: Dropped support of PHP4
Replies: 18
Views: 21172

Re: Dropped support of PHP4

EDIT: retracted
by DavidMJ
Mon Jan 07, 2008 5:42 pm
Forum: [3.0/Olympus] Discussion
Topic: SQL optimisation
Replies: 70
Views: 53544

Re: SQL optimisation

Thanks for the info, I will investigate this. :)
by DavidMJ
Mon Jan 07, 2008 5:12 pm
Forum: [3.0/Olympus] Discussion
Topic: Dropped support of PHP4
Replies: 18
Views: 21172

Re: Dropped support of PHP4

As of right here and now, making such a jump would be totally arbitrary... Why should we not support PHP 5.1?
by DavidMJ
Mon Jan 07, 2008 4:54 pm
Forum: [3.0/Olympus] Discussion
Topic: Dropped support of PHP4
Replies: 18
Views: 21172

Re: Dropped support of PHP4

This would matter if I liked PDO. However, PDO has multiple issues with it being a viable candidate to host a phpBB DBAL (using SQLite, try to do an UPDATE query inside of a loop, this loop is the "while" part of a SELECT query. Also, the "UPDATE" query has a transaction around it)
by DavidMJ
Mon Jan 07, 2008 4:40 pm
Forum: [3.0/Olympus] Discussion
Topic: Dropped support of PHP4
Replies: 18
Views: 21172

Re: Dropped support of PHP4

Can you give me a single feature of PHP 5.2 that we could use? That is mainly the issue.