Search found 230 matches

by DavidMJ
Mon Jan 07, 2008 4:22 pm
Forum: [3.0/Olympus] Discussion
Topic: SQL optimisation
Replies: 70
Views: 53545

Re: SQL optimisation

I know this query is a problem query with regarding to index use, I do not know why PostgreSQL is giving such a query plan...
by DavidMJ
Mon Jan 07, 2008 2:08 pm
Forum: [3.0/Olympus] Discussion
Topic: SQL optimisation
Replies: 70
Views: 53545

Re: SQL optimisation

I am afraid I do not see a quick fix.
by DavidMJ
Mon Jan 07, 2008 12:11 pm
Forum: [3.0/Olympus] Discussion
Topic: SQL optimisation
Replies: 70
Views: 53545

Re: SQL optimisation

We use pg_escape_string. I am in the middle of rewritting the LIKE functionality.
by DavidMJ
Fri Jan 04, 2008 5:26 pm
Forum: [3.0/Olympus] Discussion
Topic: SQL optimisation
Replies: 70
Views: 53545

Re: SQL optimisation

Here is a collection of SQL queries which run with * 008-01-04 14:44:43 CET LOG: instruction : SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = 'XXXXXXXXXXXXXXXXXXXXXXXX' AND u.user_id = s.session_user_id 2008-01-04 14:44:43 CET LOG: durée : 2.099 ms We really do need all t...
by DavidMJ
Fri Jan 04, 2008 5:10 pm
Forum: [3.0/Olympus] Discussion
Topic: SQL optimisation
Replies: 70
Views: 53545

Re: SQL optimisation

Searches are done on indexes: phpbb3=# EXPLAIN ANALYSE SELECT u.*, z.friend, z.foe, p.* FROM phpbb_users u, phpbb_posts p LEFT JOIN phpbb_zebra z ON (z.user_id = 1 AND z.zebra_id = p.poster_id) WHERE p.post_id IN ('432652', '433287', '433346', '433380') phpbb3-# AND u.user_id = p.poster_id; QUERY P...
by DavidMJ
Fri Jan 04, 2008 2:06 am
Forum: [3.0/Olympus] Discussion
Topic: Dropped support of PHP4
Replies: 18
Views: 21172

Re: Dropped support of PHP4

In the next few days, more and more code should be translated into proper PHP 5.1 support. If after a week, you may post bugs related to the PHP 5.1 work here (assuming we don't get the bug tracker online) Until then, please hold bugs to yourselves. Right them down somewhere ;)
by DavidMJ
Fri Jan 04, 2008 2:01 am
Forum: [3.0/Olympus] Discussion
Topic: SQL optimisation
Replies: 70
Views: 53545

Re: SQL optimisation

Try the following:
viewforum.patch
(2.06 KiB) Downloaded 681 times
by DavidMJ
Fri Jan 04, 2008 1:45 am
Forum: [3.0/Olympus] Discussion
Topic: SQL optimisation
Replies: 70
Views: 53545

Re: SQL optimisation

It looks like you are correct, this query can be optimized. If you find others, don't hesitate to post them.
by DavidMJ
Fri Dec 14, 2007 8:13 pm
Forum: [3.0/Olympus] Discussion
Topic: phpBB 3.2 Discussion
Replies: 257
Views: 206884

Re: phpBB 3.2 Discussion

Black Antitoon wrote:A database Restore tool which doesn't time out with big files.
The 3.0 one times out? How big a file?
by DavidMJ
Wed Dec 12, 2007 4:17 am
Forum: [3.0/Olympus] Discussion
Topic: Adding Advanced Custom BBCode (bbcode.php)
Replies: 5
Views: 18120

Re: Adding Advanced Custom BBCode (bbcode.php)

Adding core BBCodes to the current BBCode engine is not even close to trivial, I can't say that I am happy with the state of the current BBCode engine. This will be fixed for the next major release.