Performance Tuning when handling huge instance

Hi,

<xf:insert> and <xf:delete> performance is getting poor when the instance is large.

One insert or delete is taking more than 3 secs. Doing this in loop, completely makes the system poor.

Any suggestions here? How to improve this.

I am just talking about the insert or delete time, not the rebuild time.

Hi Vedha,

Would you be able to create a super-simple test case that reproduces this for us? 3 s for a single <xf:insert> or <xf:delete> sounds like a lot! If we can easily reproduce this, we'll then be able to take it from there.

Alex