Click here to Skip to main content
15,905,912 members
Home / Discussions / C#
   

C#

 
GeneralRe: Drawing a rectangle Pin
Heath Stewart2-Feb-04 2:47
protectorHeath Stewart2-Feb-04 2:47 
GeneralSorting in cyclic order Pin
Shree29-Jan-04 2:26
Shree29-Jan-04 2:26 
GeneralRe: Sorting in cyclic order Pin
Heath Stewart29-Jan-04 3:57
protectorHeath Stewart29-Jan-04 3:57 
GeneralRe: Sorting in cyclic order Pin
Shree29-Jan-04 6:07
Shree29-Jan-04 6:07 
GeneralVoice in C# AGAIN Pin
Abkarino29-Jan-04 1:00
Abkarino29-Jan-04 1:00 
GeneralRe: Voice in C# AGAIN Pin
Heath Stewart29-Jan-04 2:35
protectorHeath Stewart29-Jan-04 2:35 
GeneralCall Webservice from windows client problem Pin
Mazdak28-Jan-04 23:56
Mazdak28-Jan-04 23:56 
GeneralRe: Call Webservice from windows client problem Pin
Heath Stewart29-Jan-04 3:20
protectorHeath Stewart29-Jan-04 3:20 
GeneralRe: Call Webservice from windows client problem Pin
Mazdak29-Jan-04 4:54
Mazdak29-Jan-04 4:54 
GeneralRe: Call Webservice from windows client problem Pin
Heath Stewart29-Jan-04 6:52
protectorHeath Stewart29-Jan-04 6:52 
GeneralRe: Call Webservice from windows client problem Pin
Mazdak29-Jan-04 7:04
Mazdak29-Jan-04 7:04 
GeneralRe: Call Webservice from windows client problem Pin
Heath Stewart29-Jan-04 7:32
protectorHeath Stewart29-Jan-04 7:32 
Generalmultiple search engine querying tool! Pin
mali28-Jan-04 23:15
mali28-Jan-04 23:15 
GeneralRe: multiple search engine querying tool! Pin
Heath Stewart29-Jan-04 3:12
protectorHeath Stewart29-Jan-04 3:12 
GeneralCancel Button on collection Editor Pin
arti_ab28-Jan-04 22:50
arti_ab28-Jan-04 22:50 
GeneralRe: Cancel Button on collection Editor Pin
Heath Stewart29-Jan-04 3:07
protectorHeath Stewart29-Jan-04 3:07 
GeneralAssertion in C# app Pin
ip_tgz28-Jan-04 20:23
ip_tgz28-Jan-04 20:23 
GeneralRe: Assertion in C# app Pin
Mazdak28-Jan-04 20:55
Mazdak28-Jan-04 20:55 
GeneralRe: Assertion in C# app Pin
ip_tgz28-Jan-04 22:58
ip_tgz28-Jan-04 22:58 
GeneralRe: Assertion in C# app Pin
Mazdak29-Jan-04 0:02
Mazdak29-Jan-04 0:02 
GeneralRe: Assertion in C# app Pin
Heath Stewart29-Jan-04 2:47
protectorHeath Stewart29-Jan-04 2:47 
Generalcontrolling devices in c# Pin
mahmoud12328-Jan-04 20:11
mahmoud12328-Jan-04 20:11 
GeneralRe: controlling devices in c# Pin
Heath Stewart29-Jan-04 2:42
protectorHeath Stewart29-Jan-04 2:42 
GeneralSecond Time Slow Code Pin
obelisk2928-Jan-04 16:59
obelisk2928-Jan-04 16:59 
Hello I am using Sql Server 2000 Developer Edition, Now I know there are limitations too how many connections you have BUT This piece of code below executes a whole lot slower the second time you run it.

C#
switch(cbSearch.SelectedItem.ToString())
{
    case "Lastname":
        cmd = new SqlCommand("SPSearchRmiInfoLastname", conn);
        cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@Lastname", txtSearch.Text);
            break;
    case "Firstname":
            cmd = new SqlCommand("SPSearchRmiInfoFirstname", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@Firstname", txtSearch.Text);
            break;
}
conn.Open();
Search.Clear();

SqlDataReader drd = cmd.ExecuteReader();
while(drd.Read())
{
    Search.Rows.Add(new object[] {drd[0], drd[1], drd[2], drd[3]});
    sbp.Text = Search.Rows.Count+" records found.";
}
dg.DataSource = Search;

drd.Close();
conn.Close();




The results are staggering.

First time: 1783 Milliseconds
Second time: 150326 Milliseconds

HOLY SHAZBOT!!

Now that's a difference right there,
Any ideas on why this is happening and how I can change it

Thanks,
Obe



NOTE: I already posted this in the Sql/ADO/ADO.NET Section
but it has todo with C# as well



------------------

I'm naked under my clothes...
GeneralRe: Second Time Slow Code Pin
Le centriste28-Jan-04 18:19
Le centriste28-Jan-04 18:19 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.