Hello,

my question is close to the previous question but with some new elements so i rather prefere to start a new thread

Someone can explain me why with Page buffer 75

Page buffer 75
Page size 4096
Time to execute the sql: 9251 ms
Indexed Read: 128
Non Indexed Read: 0
Inserts: 40
Updates: 0
Deletes: 40
Time to commit the data: 78 ms

and now i change the page buffer to 2048 :

Page buffer 2048
Page size 4096
Time to execute the sql: 156 ms
Indexed Read: 128
Non Indexed Read: 0
Inserts: 40
Updates: 0
Deletes: 40
Time to commit the data: 2543 ms


why with a lower page buffer the commit time is very fast but the execution time is very slow and with a more larger buffer it's the opposite ?

It's seam also than changing the page size of the database decrease the comit time by 40%, (all the index was in depth 3 in page size 4096)!

Page buffer 2048
Page size 16384
Time to execute the sql: 172 ms
Indexed Read: 128
Non Indexed Read: 0
Inserts: 40
Updates: 0
Deletes: 40
Time to commit the data: 1529 ms


thanks by advance for you help !
stephane