4 Replies Latest reply on Jul 23, 2002 11:26 AM by Ben Wong

    CMP, Cache, and performance

    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. Once I make another 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. Can someone please tell me what I am missing.

      Thanks

      Ashar