big database on sqlCE - it Takes a long time to open connection RRS feed

  • Question

  • hi

    i have database on sqlCE 75.6MB with 600,000 rows  that has one table with 3 columns

    A - lenght 13 (text)

    B - lenght 20 (text)

    C - lenght 21 (text)

    i open the connection like this:

    bool OpenConn()
        Conn = new SqlCeConnection(String.Format(@"Data Source={0}\
                     {1}", PathI, "MyDB.SDF"));
        return true;
      catch (SqlCeException err)
        MessageBox.Show(err.Message, "Connetion error");
        return false;

    the problem that it take  a long time to open connection.

    is there any other way for open and work with big database ?

    i work on sqlCE for Windows-CE or Windows-Mobile in C#

    thanks in advance

    Monday, February 27, 2012 12:50 PM

All replies

  • You should put this database on server side. There is no enough memory space to open such a big database and using .NETCF.


    Wednesday, February 29, 2012 3:26 AM
  • It's actually relatively small database. Not sure why it would take a long time to open it. I would suggest running repair/compression on it. Also make sure it is indeed the opening part and not loading of the data.

    This posting is provided "AS IS" with no warranties, and confers no rights.

    Wednesday, February 29, 2012 7:07 AM