increase the performance

See more:

C#

ADO.NET

Dear Sir,

In mobile application for retriving data from database i am using Datareader concept for fast accessing the information
but while reading the data it takes minimum 5 minutes it has only 10 records.
How to increase the performance of my application please suggest me this argent requirement

This is my code

SqlCeConnection conn = null;
SqlCeCommand cmd = null;
SqlCeDataReader rdr = null;

try
{    
    conn = new SqlCeConnection("Data Source = AdventureWorks.sdf");
    conn.Open();

    cmd = new SqlCeCommand("SELECT * FROM DimEmployee", conn);

    rdr = cmd.ExecuteReader();
   
    while (rdr.Read())
    {
        int employeeID = rdr.GetInt32(0);   // or: rdr["EmployeeKey"];
        string lastName = rdr.GetString(5); // or: rdr["FirstName"];
    }
   
    rdr.Close();
    cmd.Dispose();
}
finally
{   
    conn.Close();
}

Regards
Ch.Sreenu