Click here to Skip to main content
15,915,324 members
Home / Discussions / Database
   

Database

 
GeneralRe: Retrieving autonumber when inserting data in a table Pin
Anonymous31-Jan-04 10:18
Anonymous31-Jan-04 10:18 
GeneralADO Pin
monrobot1329-Jan-04 8:50
monrobot1329-Jan-04 8:50 
GeneralRe: ADO Pin
RChin30-Jan-04 4:05
RChin30-Jan-04 4:05 
GeneralRe: ADO Pin
monrobot1330-Jan-04 9:19
monrobot1330-Jan-04 9:19 
GeneralSP that support data Paging Pin
Aryo Handono29-Jan-04 3:32
professionalAryo Handono29-Jan-04 3:32 
GeneralRe: SP that support data Paging Pin
michanne29-Jan-04 4:09
michanne29-Jan-04 4:09 
GeneralRe: SP that support data Paging Pin
basementman30-Jan-04 10:36
basementman30-Jan-04 10:36 
GeneralSame code running slower second time Pin
obelisk2928-Jan-04 11:37
obelisk2928-Jan-04 11:37 
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

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

I'm naked under my clothes...
GeneralRe: Same code running slower second time Pin
Aryo Handono29-Jan-04 3:14
professionalAryo Handono29-Jan-04 3:14 
GeneralRe: Same code running slower second time Pin
obelisk2929-Jan-04 4:40
obelisk2929-Jan-04 4:40 
GeneralRe: Same code running slower second time Pin
obelisk2929-Jan-04 5:35
obelisk2929-Jan-04 5:35 
Questionusing a query as array data? Pin
Anonymous28-Jan-04 10:54
Anonymous28-Jan-04 10:54 
AnswerRe: using a query as array data? Pin
Mazdak28-Jan-04 19:47
Mazdak28-Jan-04 19:47 
GeneralCreating Tables on Access/SQL/MSDE Pin
Jeremy Pullicino27-Jan-04 23:33
Jeremy Pullicino27-Jan-04 23:33 
GeneralRe: Creating Tables on Access/SQL/MSDE Pin
Mazdak27-Jan-04 23:40
Mazdak27-Jan-04 23:40 
GeneralRe: Creating Tables on Access/SQL/MSDE Pin
Jeremy Pullicino28-Jan-04 4:27
Jeremy Pullicino28-Jan-04 4:27 
GeneralSQL-DMO Pin
monrobot1327-Jan-04 18:08
monrobot1327-Jan-04 18:08 
GeneralRe: SQL-DMO Pin
LizardWiz28-Jan-04 4:45
LizardWiz28-Jan-04 4:45 
GeneralRe: SQL-DMO Pin
monrobot1328-Jan-04 7:16
monrobot1328-Jan-04 7:16 
GeneralSimple question: storing strings with quotation marks ( ' ) Pin
trndbrg27-Jan-04 17:36
trndbrg27-Jan-04 17:36 
GeneralRe: Simple question: storing strings with quotation marks ( ' ) Pin
Guillermo Rivero27-Jan-04 18:39
Guillermo Rivero27-Jan-04 18:39 
GeneralRe: Simple question: storing strings with quotation marks ( ' ) Pin
Mike Dimmick28-Jan-04 2:01
Mike Dimmick28-Jan-04 2:01 
GeneralRe: Simple question: storing strings with quotation marks ( ' ) Pin
Mysterious_must29-Jan-04 20:02
Mysterious_must29-Jan-04 20:02 
Generalrowfilter in vb.net2003 Pin
Member 76660827-Jan-04 16:02
Member 76660827-Jan-04 16:02 
GeneralRe: rowfilter in vb.net2003 Pin
-Dr_X-31-Jan-04 3:53
-Dr_X-31-Jan-04 3:53 

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.