Solved

SQL Transaction locking whloe table

Posted on 2004-09-19
3
249 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
3 Comments
 

Accepted Solution

by:
GRV_Consulting earned 125 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Displaying an arrayList in a listView using the default adapter is rarely the best solution. To get full control of your display data, and to be able to refresh it after editing, requires the use of a custom adapter.
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

816 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now