G
gus bjorklund
Guest
the reason that 1 record per transaction is slow compared to 50 or 100 is that the transaction log records and associated processing to start and end a transaction are each about the same or a little more than that to update/delete/create 1 record. the ratio is also dependent on how many indexes and row size. there isn’t really any “optimal” size. the start/end overhead is the same for 1 record as for 100 so making the transaction size larger than 10 or 20 will usually do the trick. bigger than that leads to diminishing returns.
Continue reading...
Continue reading...