SQL Server

Nilesh Dalvi

12y1.4k

Hi there,

I am developing a winform application[with c#] with SQL Database [attached].

All process with SQL query are OK, but at the first time when application open and user Login for application; SQL query takes too much time [may application is HANG or STOP working (say for 5-6 seconds) and then after successfully login application start.

After it; all SQL process will executes well.

If user close application and start over again ... it's again slow / Hang/ Not working starts....

I can't getting wht is matter with this...?

Can you tell me what is mistake in my query?

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi12y ago
Hi,
I donot know what exact problem you are facing.
by considering some point you can improve startup performance.
like
Reduce code in Form Load
use lazy loading (load the data when required.
always Call Dispose()
Pre-compile your assemblies using NGEN when appropriate to decrease start-up time
Remove all references from your project that are not used
hope this will help you.
0
Nilesh Dalvi12y ago
As per suggestion given I put two labels for connection startup time and endup time...
it takes 6 sec to load my Home Page.

Abt how many entries in my Login table... its only 3 user in table and its only having name,username & password column.

Name------Username--------Password
Nilesh------Nilesh123--------Nil123
Sharad-----Sharad123-------Shar123
Sushant----Sush123---------Sus123
[thats it....]

Abt sql idexes ; i'm not shame to tell that I never used Index before...

Is it really work for me; then plz tell me hw to use SQL Index for login page.
0
Wim Sturkenboom12y ago
So how often do you call that code in your application. Once I guess.

You can add some timing checks to see what takes long. Opening the connection or executing the query or reading the result or ...

DateTime dtStart = DateTime.Now;
con.open();
DateTime dtEnd = DateTime.Now;

...
...
com.ExecuteNonQuery();
DateTime dtEnd = DateTime.Now;
...
...

etc

Put breakpoints at sensible places and check the durations of the steps.

How many records do you have in the table UserDetails? If there are a lot of them, is your table correctly indexed?

Note: your query is prone to SQL injection; read up on parameter queries.
0
Nilesh Dalvi12y ago
Here is my code for Login,

try
{
con.Open();
SqlCommand com = new SqlCommand(" select * from UserDetails where IDNumber = '" + txtLogin.Text + "' and Password = '" + txtPassword.Text + "' and Designation='" + cmbType.SelectedValue.ToString() + "' ", con);

com.ExecuteNonQuery();
SqlDataReader dr = com.ExecuteReader();
if (dr.Read())
{
con.Close();
this.Hide();
EXeSmart ex = new EXeSmart();
ex.Show();
}
else
{
MessageBox.Show("Invalid Login", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
con.Close();
txtLogin.Text = " ";
txtPassword.Clear();
txtLogin.Focus();
}
}
catch
{
MessageBox.Show("Invalid Operation");
txtLogin.Focus();
}
0
Munesh Sharma12y ago
please share your code .. after that we can get solution
0
Vithal Wadje12y ago
post sample code
0