Tag Info

New answers tagged

1

BEGIN or START TRANSACTION initiates a transaction. It is ended by COMMIT or ROLLBACK in the same connection. SET TRANSACTION provides optional attributes for the transaction; it is not often used. If you need a long-running transaction, or something that spans multiple web page invocations, you need to do it some other way. (This is probably a common ...


0

If performance is your primary concern, I suggest the second approach. No need to touch the parent User table. Use the serializable isolation level to address concurrency if the same user can have multiple sessions. CREATE TABLE Vote( userId int NOT NULL , contentId int NOT NULL , quantity int NOT NULL , CONSTRAINT PK_Vote PRIMARY KEY ...


0

If you talk about continuous integration then I assume it's a development environment. In that case I would say the person doing structural changes has to test them to ensure not to break things for others, much the same way someone updating a common library: Test in your own sandbox before commiting such changes. In a production deployment process you ...


0

I ended up doing this, to do it in batches of 1krow (which takes about .2s per batch if there's nothing to update, 2s otherwise; basically it has the same total speed per row if it's in batches of 10k, 5k or 1k): SET SESSION sql_mode = 'strict_all_tables'; SET SESSION sql_warnings = 1; \W DELIMITER // DROP PROCEDURE IF EXISTS update_dmf_lifespan// CREATE ...


0

It seems Windows Firewall blocks DTC packages. To allow it to communicate through Windows Firewall, go to Control Panel > Windows Firewall > Allowed Apps and from list of apps, check Distributed Transaction Coordinator for both Private and Public networks. If it doesn't works for you check out these solutions: Unable to begin a distributed transaction No ...



Top 50 recent answers are included