how to solve hanging problem in sql query using vb 6.0.

Question

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

Riddhi Valecha · Answer

Hi.. 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 Chaudhary · Answer

Hi friend 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 /* Style Definitions */ table.MsoNormalTable{mso-style-name:Table Normal;mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:Calibrisans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:Times New Roman;mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;}

Riddhi Valecha · Answer

Hi.. 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.