I was doing performance tuning for one of the code and implemented the Multi row fetch and Multi row insert in the code.
I did design the cursor size (how many rows to fetch/insert) based on the following criteria.
1) Size of the buffer pool (I've used BP0 -4K Buffer Pool)
2) Size of the row-lengh (80 bytes)
I've decided the number of rows in a cursor should be 45 as
(4k(Size of the bufferpool)/80(Row size) ~ 45).
But we were able to test with the cursor size as 80 also and it worked fine.
I'd like to know if this way of calculation for the row size is correct? Can you please suggest me if any thing else needs to be considered for calculation of the cursor size?.
Thanks & Regards,