|
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()
{
try
{
Conn = new SqlCeConnection(String.Format(@"Data Source={0}\
{1}", PathI, "MyDB.SDF"));
Conn.Open();
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
|
|
|
|
|
There is no other way.
If the first connection is very slow after deploying the database to the device, the indexes have to be rebuilt, so that's probably what's taking so long.
See this[^] for why.
|
|
|
|