Discussion of general topics related to the new version and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Forum rules
Discussion of general topics related to the new release and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
2008-01-07 23:04:58 CET LOG: instruction : UPDATE phpbb_config
SET config_value = 'eXXXXXXXXXXXXXae6'
WHERE config_name = 'rand_seed'
2008-01-07 23:04:58 CET LOG: durée : 26.001 ms
2008-01-07 23:06:50 CET LOG: instruction : SELECT u.*, s.*
FROM phpbb_sessions s, phpbb_users u
WHERE s.session_id = 'cXXXXXXXXXXXXXXXX9'
AND u.user_id = s.session_user_id
2008-01-07 23:06:50 CET LOG: durée : 37.006 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------
Nested Loop (cost=0.00..16.55 rows=1 width=610) (actual time=0.092..0.094 rows=1 loops=1)
-> Index Scan using phpbb_sessions_pkey on phpbb_sessions s (cost=0.00..8.27 rows=1 width=206) (actual time=0.063..0.063 rows=1 loops=1)
Index Cond: (session_id = 'XXXXXXXXXXXXXXXXx'::bpchar)
-> Index Scan using phpbb_users_pkey on phpbb_users u (cost=0.00..8.27 rows=1 width=404) (actual time=0.020..0.020 rows=1 loops=1)
Index Cond: (u.user_id = s.session_user_id)
Total runtime: 0.251 ms
(6 lignes)
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------
Nested Loop Left Join (cost=0.00..16.55 rows=1 width=610) (actual time=0.031..0.033 rows=1 loops=1)
-> Index Scan using phpbb_sessions_pkey on phpbb_sessions s (cost=0.00..8.27 rows=1 width=206) (actual time=0.021..0.022 rows=1 loops=1)
Index Cond: (session_id = 'cXXXXXXXXXXXXXXx9'::bpchar)
-> Index Scan using phpbb_users_pkey on phpbb_users u (cost=0.00..8.27 rows=1 width=404) (actual time=0.005..0.006 rows=1 loops=1)
Index Cond: (u.user_id = s.session_user_id)
Total runtime: 0.120 ms
(6 lignes)
Three times as fast.
Left joins are always faster than inner joins.