Clarity

 View Only
  • 1.  Project tabs SQL query

    Posted Jul 04, 2016 10:30 AM

    Hey CA community !

     

    To introduce the context, we are using CA PPM with about 20k projects and 2k users. We are currently updating from v13.1 to v14.3.
    In fact, we have a specific performance problem during the switching of project tabs (Task, Team, Financial Plans...).
    Misc tools and the SQL tracer lead me to a SQL query calls on tab loading :

     

    select ip.object_instance_id object_instance_id, nm1.id, c.name, na1.action_code....
    


    see joined files for the completed queries.

     

    This query has changed from v13.1 to v14.3, more precisely the last "sub request" is now part of the "From clause" in the last request.

     

    We will make tests in both of v13.1 and v14.3, but do you know if this query is a sensitive query (for performance) ? Is the changing of query means that CA find a performance issue or improvement ? This query is linked to privacy. Our policies seems heavy and complex, it could be the reason of our issues ?

     

    I'm not expecting for precises answers, I know the that performances issues can have lot of sources, I'm more searching for feelings or ways to progress.

     

    Thanks,
    Julien

    Attachment(s)

    zip
    queryV13.sql.zip   805 B 1 version
    zip
    queryV14.sql.zip   936 B 1 version


  • 2.  Re: Project tabs SQL query

    Posted Jul 22, 2016 06:19 AM

    Ok it seems that the v14 request fixes the issue ! Good to know that if you have a performance issue with project tabs, you could fix it be use this query (of course, it's better to be up to date ).



  • 3.  Re: Project tabs SQL query

    Posted Jul 22, 2016 06:39 AM

    When you say

    v14 request fixes

    do you mean v14.3 or another version?



  • 4.  Re: Project tabs SQL query

    Posted Jul 22, 2016 07:50 AM

    Exactly, it is the v14.3 request version.