Search found 230 matches

by DavidMJ
Sun Apr 13, 2008 7:00 am
Forum: [3.0/Olympus] Discussion
Topic: phpBB 3.2 Discussion
Replies: 257
Views: 206346

Re: phpBB 3.2 Discussion

I consider that pollution of the namespace... I see no changes in how we structure the DBAL in 3.2 from what we have right now

Having ported two more drivers over _today_, I see nothing wrong with how we do it right now... Perhaps if you could give a more "full" proposal?
by DavidMJ
Sat Feb 16, 2008 7:15 pm
Forum: [3.0/Olympus] Discussion
Topic: sid on style.php?? requested every new session.
Replies: 8
Views: 7396

Re: sid on style.php?? requested every new session.

The style the user has can differ from the default style. Him being logged in might have a different style than him being logged out. However, work is underway to increase the efficiency of the style.php script.
by DavidMJ
Fri Jan 25, 2008 3:40 pm
Forum: [3.0/Olympus] Discussion
Topic: let's get rid of {S_FORM_TOKEN}
Replies: 8
Views: 8495

Re: let's get rid of {S_FORM_TOKEN}

In the end, functionality wins. Without an alternative implemented here and now, {S_FORM_TOKEN} is here to stay...
by DavidMJ
Sat Jan 19, 2008 4:16 am
Forum: [3.0/Olympus] Discussion
Topic: phpBB 3.2 Discussion
Replies: 257
Views: 206346

Re: phpBB 3.2 Discussion

The posting system is getting a shot in the arm, we will have soft deletes.
by DavidMJ
Wed Jan 16, 2008 10:26 pm
Forum: [3.0/Olympus] Discussion
Topic: The CVS is not working !!!
Replies: 4
Views: 5281

Re: The CVS is not working !!!

I highly discourage using CVS on a live board at this juncture.
by DavidMJ
Thu Jan 10, 2008 7:16 am
Forum: [3.0/Olympus] Discussion
Topic: SQL optimisation
Replies: 70
Views: 53435

Re: SQL optimisation

In my post, there are examples where using a LEFT JOIN gives 20% speedup on an INNER JOIN. The advantage may be better given context change, memory use, CPU time, etc .. You can look at this post which is the perfect example : http://area51.phpbb.com/phpBB/viewtopic.php?f=3&t=29260&start=40#p191366...
by DavidMJ
Wed Jan 09, 2008 4:53 pm
Forum: [3.0/Olympus] Discussion
Topic: Transactions and MyISAM
Replies: 7
Views: 6918

Re: Transactions and MyISAM

Right, all the transaction code becomes a NOP if the underlying engine does not support transactions. phpBB installs the schema using the default installed engine.
by DavidMJ
Tue Jan 08, 2008 7:48 am
Forum: [3.0/Olympus] Discussion
Topic: SQL optimisation
Replies: 70
Views: 53435

Re: SQL optimisation

In this case, it looks like the query planner chose the same join order on the tables...
by DavidMJ
Tue Jan 08, 2008 4:23 am
Forum: [3.0/Olympus] Discussion
Topic: SQL optimisation
Replies: 70
Views: 53435

Re: SQL optimisation

This is too slow: 2008-01-04 21:53:58 CET LOG: instruction : SELECT u.username, u.username_clean, u.user_id, u.user_type, u.user_allow_viewonline, u.user_colour, s.session_ip, s.session_viewonline FROM phpbb_users u, phpbb_sessions s WHERE s.session_time >= 1199479738 AND u.user_id = s.session_user...
by DavidMJ
Tue Jan 08, 2008 4:22 am
Forum: [3.0/Olympus] Discussion
Topic: SQL optimisation
Replies: 70
Views: 53435

Re: SQL optimisation

That one is quite slow: 2008-01-04 19:31:15 CET LOG: instruction : SELECT g.group_id, g.group_name, g.group_colour, g.group_type FROM phpbb_groups g LEFT JOIN phpbb_user_group ug ON ( g.group_id = ug.group_id AND ug.user_id = 1 AND ug.user_pending = 0 ) WHERE g.group_legend = 1 AND (g.group_type <>...