Index: openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-views.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-views.sql,v diff -u -r1.3 -r1.4 --- openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-views.sql 21 Nov 2001 01:26:11 -0000 1.3 +++ openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-views.sql 21 Nov 2001 01:33:28 -0000 1.4 @@ -11,6 +11,12 @@ -- using "in". It would be nice to avoid having two aggregate subselects -- but there's no easy way to to do this. +-- Also ... Postgres does seem to optimize away the two subselects that +-- calculate the number of replies and last reply date if the query +-- using the view doesn't include those columns in its resultset. So +-- at the moment it does not appear necessary to create simpler views +-- with those stripped out. + create view bboard_messages_all as select m.message_id, m.reply_to, m.sent_date, m.sender, m.title, m.mime_type, m.content, f.forum_id, f.status,