Yes, currently we do the entire upgrade within a single database transaction. It would probably improve performance to break that up into smaller transactions. When you have a huge amount of changes inside of a transaction, it can eat up a lot of database resources, and it also creates the potential for blocking & locking.
Yes, currently we do the entire upgrade within a single database transaction. It would probably improve performance to break that up into smaller transactions. When you have a huge amount of changes inside of a transaction, it can eat up a lot of database resources, and it also creates the potential for blocking & locking.