?
Solved

SQL Transaction locking whloe table

Posted on 2004-09-19
3
Medium Priority
?
258 Views
Last Modified: 2010-04-17
if SqlTransaction applied while updating table its locks whole table so it not let other select command to fetch data from table as long Transaction is not finished
0
Comment
Question by:meharmahmood
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 

Accepted Solution

by:
GRV_Consulting earned 500 total points
ID: 12098699
That is correct. Some database systems use table locking on transactions to prevent other processes from altering the same data. You haven't mentioned what database system you are working with ... is it MS-SQL Server .. Oracle ..  MySQL?

Also keep in mind that the locking method a particular database uses is sometimes configurable by the administrator. MySQL for example can use MyISAM tables which lock the table on DELETE transactions, or it can use InnoDB which has row level locking.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
Introduction to Processes
Starting up a Project
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question