Digital Marketing

Loading...

#Database Transaction Best Practices

  1. Keep transactions to the smallest number of commands needed. If you have transactions with multiple statements that can be divided up into multiple smaller transactions, it is advisable to do so to reduce the likelihood of a timeout. Always aim to create short transactions, not long-running reads.
  2. Always commit or abort the transaction after it is complete. Leaving a transaction in an incomplete state ties up database resources and can cause write conflicts.


Comments

Post a Comment

Popular posts from this blog

Make online money from the Internet

Make online money from the Internet   Create your own YouTube channel and become a YouTube partner to monetize your videos. You may use  Oneload  to distribute the same video to multiple video sites. Make something creative – like handbags, jewelry, paintings, craft items – and sell them on  Etsy ,  ArtFire  or eBay. Build your own online store with  Shopify  or  SquareSpace  and sell both physical goods and digital downloads. Sell everything from furniture to clothes to food. Create t-shirt designs and put them on  Threadless ,  Zazzle  and  CafePress . Write a book and publish it on the Kindle store, Google Play and iBooks. You can also sell your ebook to other retailers through services like  Smashwoods  and  BookBaby . Become an instructor at  SkillShare  and get paid for teaching your favorite subjects – from guitar to literature to yoga to foreign languages – to...
Read more