| Version | Limit on X86 | Limit on X64 |
|---|---|---|
| Windows 7 Ultimate |
4 GB
|
192 GB
|
| Windows 7 Enterprise |
4 GB
|
192 GB
|
| Windows 7 Professional |
4 GB
|
192 GB
|
| Windows 7 Home Premium |
4 GB
|
16 GB
|
| Windows 7 Home Basic |
4 GB
|
8 GB
|
| Windows 7 Starter |
2 GB
|
/// loop all data
ArrayList[] Array = new ArrayList[100];
SqlCeConnection cn = new SqlCeConnection(_ConnectionString);
if (cn.State == ConnectionState.Closed) cn.Open();
string query = "SELECT Phone FROM People";
SqlCeCommand command = new SqlCeCommand(query, cn);
command.CommandType = CommandType.Text;
SqlCeResultSet record = command.ExecuteResultSet(ResultSetOptions.Scrollable);
int RowCount = 0;
if (record.HasRows)
{
record.ReadFirst();
do{
string Data = record.GetString(0);
int Index = Convert.ToInt32(Data.Substring(0, 2));
if (Array[Index] == null) Array[Index] = new ArrayList();
Array[Index].Add(Data);
RowCount++;
} while (record.Read());
}
/// Create all index files from arrays
XmlSerializer Serializer = new XmlSerializer(typeof(ArrayList));
for (int i = 0; i <= 9; i++)
{
for (int j = 0; j <= 9; j++)
{
int Index = i * 10 + j;
Serializer.Serialize(new StreamWriter(_IndexFileName + Index + ".inx"), Array[Index]);
}
}
and the find result is so simple than making index files /// Read all index files XmlSerializer Serializer = new XmlSerializer(typeof(ArrayList)); int Index = Convert.ToInt32(SearchItem.Substring(0, 2)); ArrayList array = Serializer.Deserialize(new StreamReader(_IndexFileName + Index + ".inx")) as ArrayList; String Message = "NOT FOUND !!!"; if (array.BinarySearch(SearchItem) == 0) Message = "*** FOUND ON INDEX ***";I think that it's clear about SQL WHERE CLUSE search but i put coeds here for compare
/// Read all index files
SqlCeConnection cn = new SqlCeConnection(_ConnectionString);
if (cn.State == ConnectionState.Closed) cn.Open();
string query = String.Format("SELECT * FROM People WHERE Phone = '{0}'", editPhone.Text);
SqlCeCommand command = new SqlCeCommand(query, cn);
command.CommandType = CommandType.Text;
SqlCeResultSet record = command.ExecuteResultSet(ResultSetOptions.Scrollable);
if (record.HasRows) Message = "*** FIND ***";
else Message = "No record found!";
