hi friends,
please help me about the hanging problem in SQL QUERY at the same record access multiple user. when same record allocate the multiple user then hang the machine for 5-6 seconds.
regards,
Hemant Chaudhary
9867765755
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Riddhi ValechaPosted May 14, 2013, 11:55 PM
Visit-
http://www.mssqltips.com/sqlservertip/1359/locking-and-blocking-scripts-in-sql-server-2000-vs-sql-server-2005/
------------
http://www.sqlteam.com/article/introduction-to-locking-in-sql-server
-----------
http://blog.sqlauthority.com/2011/05/08/sql-server-what-kind-of-lock-with-nolock-hint-takes-on-object/
Hemant ChaudharyPosted May 14, 2013, 4:12 AM
There is 50000 records in database & please suggest how to use locking function in sql for resolving my software hanging problem. I used this function for storing data in data base while multi users are accessing the row at the same time.
Hemant
Riddhi ValechaPosted May 14, 2013, 12:53 AM
How many records are there is the database??
If there are more records(i.e. the database is heavy), I would suggest that you migrate from VB6.0 to VB.NET or C#.NET.
VB6.0 is now very old technology that is almost eradicated from the market.