Locking a DB while updating...

Bucko

How important do you guys feel locking a database is while
updating/adding information? Do you do it with every app you make? Only
very high volume (traffic) apps? I'm trying to decide if my app needs it.

Nov 17 '05 #1

Subscribe Post Reply

1383

George Ter-Saakov

Not clear what do you mean by "updating/adding information".
If you are changing the database/tables structure then I would bring the IIS
down for that period of time.

But if you are updating/inserting records then there is no universal
solution. You should use appropriate Transaction level and it all depends on
the nature of your updates.

But you do not need to lock the database/tables. Only the updated records.
George.

"Bucko" <bu**@ddg.com> wrote in message news:3F**************@ddg.com...

How important do you guys feel locking a database is while
updating/adding information? Do you do it with every app you make? Only
very high volume (traffic) apps? I'm trying to decide if my app needs it.

Nov 17 '05 #2

Jan Limpens

probably your app doesn't need it, as you are asking yourself. when you
need it, you will know ;)

Bucko wrote:

How important do you guys feel locking a database is while
updating/adding information? Do you do it with every app you make? Only
very high volume (traffic) apps? I'm trying to decide if my app needs it.

Nov 17 '05 #3

Alvin Bruney

You don't lock a database because you force every thing touching the data
base to wait. Lock the row you want to adjust. I believe this is only
available in informix, otherwise lock the page.
Set lock mode to wait will do the trick for row level locking

--
-----------
Got TidBits?
Get it here: www.networkip.net/tidbits
"Bucko" <bu**@ddg.com> wrote in message news:3F**************@ddg.com...

How important do you guys feel locking a database is while
updating/adding information? Do you do it with every app you make? Only
very high volume (traffic) apps? I'm trying to decide if my app needs it.

Nov 17 '05 #4

Similar topics

Psycopg; How to detect row locking?

by: Alban Hertroys | last post by:

Good day, I have a number of threads doing inserts in a table, after which I want to do a select. This means that it will occur that the row that I want to select is locked (by the DB). In these...

Python

IntelliSense is locking VS C++.NET Express

by: Peteroid | last post by:

I was creating my application just fine for the last 3 weeks or so. Then, starting this morning, IntelliSense seems to be having problems. It goes into a locked 'Updating IntelliSense..." mode....

.NET Framework

Access Database Locking Up

by: Jess | last post by:

I have an access database that used to be on 1 box and now is on another. There's asp pages calling it. The gals that use it said they used to be able to get into the access database at anytime...

ASP / Active Server Pages

Locking Question around hashtable

by: akantrowitz | last post by:

In csharp, what is the correct locking around reading and writing into a hashtable. Note that the reader is not looping through the keys, simply reading an item out with a specific key: If i...

C# / C Sharp

Locking a table to stop duplicate updating

by: Roger Withnell | last post by:

I have a framed website. I plan to include in default.asp a routine to check if the annual subscription is due from the records in the People table. If so, then the routine would send emails...

ASP / Active Server Pages

Locking xml file

by: dchadha | last post by:

Hi, I am working on application in C# which uses and stores data in xml file. This app can use xml file from two different ways: (a) From User Interface (Windows application) and (b) From...

C# / C Sharp

Static Class, Updating DataTable and Locking?

by: Mark S. | last post by:

Hello, My c# aspx 2.0 web application has a static class. I would like to add a dataTable to it and have the heavy load (+100 requests a second) update it's values. This is the first time I used...

C# / C Sharp

Locking Hints

by: tim | last post by:

I am really new to ASP.NET and I was wondering if most developers use locking hints when accessing the data in SQL Server. What kind of multi-user issues come up when using an ASP.NET application?

ASP.NET

Locking a row...

by: Brad Pears | last post by:

I have a vb.net 2005 app that asks for a job number. After the job number has been entered, I run an SQL 2000 stored procedure that selects the appropriate row from the Jobs table. I do not want to...

Visual Basic .NET

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA