P
PG
First, why is there a "my tasks". Aren't tasks actually assignments? Wouldn't
it be better to call things what they are?
But, more importantly -- we have many users who manage other people who have
many 1000's of "tasks" that they status on behalf of those people. The
retrieval is so extrememly slow -- and frequently crashes. We are
PS2007/Project 2007 SP1 applied, sql2005 so that is not the issue and server
is NOT loaded at all.
When the query is done directly in sql we are talking 1.5 second response
and if we do an ASP web page we get great response. if we use my tasks, it is
PUNATIVE.
is retrieval for my tasks being done as a web service -- which would explain
the delay because imho that isn't a good use of a web service.
it be better to call things what they are?
But, more importantly -- we have many users who manage other people who have
many 1000's of "tasks" that they status on behalf of those people. The
retrieval is so extrememly slow -- and frequently crashes. We are
PS2007/Project 2007 SP1 applied, sql2005 so that is not the issue and server
is NOT loaded at all.
When the query is done directly in sql we are talking 1.5 second response
and if we do an ASP web page we get great response. if we use my tasks, it is
PUNATIVE.
is retrieval for my tasks being done as a web service -- which would explain
the delay because imho that isn't a good use of a web service.