2 Replies Latest reply on Apr 5, 2008 6:02 PM by Mikael Andersson

    FilterChain, SeamFilter and very large List

    Matthias Hüller Newbie

      When I fill a list with quite a lot of objects (100000 - 200000) and then try to link to another JSF page I observe quite a strange behaviour.


      The performance is fine until I try to link to this other JSP page - but then the execution time of javax.servlet.FilterChain.doFilter is between 200 - 500 seconds.


      Here's is my method:


      public String startSearch() {
      
      
       timeDeposits = new LinkedList<TimeDeposit>();
      
      
       String sql = "SELECT * FROM TIMEDEPOSIT" 
      
       Query query = entityManager.createNativeQuery(sql);
      
       List<Object> list = (List) query.getResultList(); // 100000-200000 results
      
      
       if (list.size() > 0) {
      
        timeDeposit.setAccountNumber((BigDecimal) row[0]);
      
        timeDeposit.setCustomerNumber((BigDecimal) row[1]);
      
        .
      
        .
      
        .
      
       }
      
       // Until this line performance is fine
      
      
       return "data.xhtml"; // javax.servlet.FilterChain.doFilter() seems to get out of control ;-)
      
      }




      Two screenshots of JProfiler to visualize this problem:


      http://img406.imageshack.us/my.php?image=jprofiler1ix5.png


      http://img241.imageshack.us/my.php?image=jprofiler2qy1.png



      What does this FilterChain/SeamFilter do? Why is the execution time that long? When I fill the List with less objects (1000) I don’t get this problem.


      Thanks :-)


      altes-kind