Content Management and Capture

Content Management and Capture

Come for answers. Stay for best practices. All we’re missing is you.

 View Only

  • 1.  Queries become very slow

    Posted 02/03/21 03:54 AM

    I have a problems running queries via ICN and ACCE is too slow. But when I execute them in database it take less than 1 second. What should it be?



    #FileNet
    #Support
    #SupportMigration


  • 2.  RE: Queries become very slow

    Posted 02/03/21 08:39 PM

    How did you make sure it was 100% the same query? CPE significantly modifies the SQL to what you would think it should be.

    The only way is to activate database tracing , find the relevant statement in the convoluted output and try that...

    If you did that and it is still fast chances are your pool size is too small, but then the query would be fast after a restart...

    BR,

    /Gerold



    #FileNet
    #Support
    #SupportMigration


Related Content