0 Replies Latest reply on May 15, 2009 1:49 AM by sridhar_ratna

    Batch update issue

    sridhar_ratna

      HI,

      Under a "FQN" Node i am trying to persist 100,000 key value pairs. Key is a Long and the value is a byte[]. The size of value is 3KB. so that total data size is 320 MB.

      When i tried to persist to oracle with and without batching. it took more than 180 minutes to persist just 3,000 key value pairs.

      After that i tried to persist the entire data in a single shot by committing batch after loading the contents into memory. This time failed with error "batch failure"

      Is there any mechanism to improve the performance for persisting cache data.