Index: openacs-4/packages/tasks/lib/tasks-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/tasks/lib/tasks-postgresql.xql,v
diff -u -r1.15 -r1.16
--- openacs-4/packages/tasks/lib/tasks-postgresql.xql	5 May 2006 18:32:02 -0000	1.15
+++ openacs-4/packages/tasks/lib/tasks-postgresql.xql	19 Oct 2006 17:05:01 -0000	1.16
@@ -76,8 +76,6 @@
           from t_task_status s,
                acs_objects ao,
                t_tasks t
-               left outer join t_process_instances pi on (pi.process_instance_id = t.process_instance_id)
-      	       left outer join t_processes p on (p.process_id = pi.process_id)
          where s.status_id = t.status_id
            and ao.object_id = t.task_id
         $limitations_clause
Index: openacs-4/packages/tasks/lib/tasks.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/tasks/lib/tasks.tcl,v
diff -u -r1.29 -r1.30
--- openacs-4/packages/tasks/lib/tasks.tcl	6 Jun 2006 16:09:18 -0000	1.29
+++ openacs-4/packages/tasks/lib/tasks.tcl	19 Oct 2006 17:05:01 -0000	1.30
@@ -131,7 +131,9 @@
     set object_query '$object_id'
 }
 
-append limitations_clause "\n and t.object_id in ( $object_query )"
+if {![string eq $object_query ""]} {
+    append limitations_clause "\n and t.object_id in ( $object_query )"
+}
 
 
 append limitations_clause "\n and ao.package_id = $package_id"
@@ -445,12 +447,6 @@
             orderby_asc "lower(t.title) asc, t.priority desc, t.due_date asc"
             default_direction asc
         }
-        process_title {
-	    label "[_ tasks.Process]"
-            orderby_desc "lower(p.title) desc, t.priority desc, t.due_date asc"
-            orderby_asc "lower(p.title) asc, t.priority desc, t.due_date asc"
-	    default_direction asc
-	}
 	contact_name {
 	    label "[_ tasks.Created_By]"
             orderby_desc "lower(contact__name(t.party_id)) desc, t.due_date asc, t.priority, lower(t.title)"
Index: openacs-4/packages/tasks/sql/postgresql/tasks-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/tasks/sql/postgresql/tasks-create.sql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/tasks/sql/postgresql/tasks-create.sql	1 Mar 2006 13:49:15 -0000	1.7
+++ openacs-4/packages/tasks/sql/postgresql/tasks-create.sql	19 Oct 2006 17:05:01 -0000	1.8
@@ -126,11 +126,12 @@
 	assignee_id             integer
 );
 
+ create index t_tasks_assignee_status_idx on t_tasks(assignee_id,status_id);
+ create index t_tasks_object_idx on t_tasks(object_id);
 
 
 
 
-
 CREATE FUNCTION inline_0()
 RETURNS integer
 AS 'declare