5 Replies Latest reply on Jul 28, 2002 1:54 AM by Dain Sundstrom

    CMP, Cache, and Performance Degradation

    Ashar Zaman Newbie

      I have a CMP Entity which contains 18000 entries in the DB. On my first findAll() call, it takes only 2 seconds to return a collection with all of the data. If I make another call, after the initial call, to the same bean, it takes 87 seconds to return the same data. My cache is set to 1000000 beans, and I have 512 MB of RAM (no shortage). I am using DB2 as the database on W2K. Can someone please tell me what I am missing

      Thanks