public static long LookupFromDatabase(string server, string db, string table, string column, int nLookups, ILookupIndex t, int k)
{
SqlConnection connection = new SqlConnection(Util.GetConnectionString(server, db));
connection.Open();
string q = TrieQuery(db, table, column, nLookups);
SqlCommand sqlcmd = new SqlCommand(q, connection);
sqlcmd.CommandTimeout = 0;
string[] lookupStrings = new string[nLookups];
int idx = 0;
using (SqlDataReader reader = sqlcmd.ExecuteReader())
{
while (reader.Read())
{
lookupStrings[idx++] = reader.GetString(0);
}
}
connection.Close();
Stopwatch sw = new Stopwatch();
sw.Reset();
sw.Start();
foreach (string s in lookupStrings)
{
int nresults = t.Lookup(s, k);
}
sw.Stop();
return (sw.ElapsedMilliseconds);
}
public static long LookupFromDatabase(string server, string db, string table, string column, int nLookups, ILookupIndex t, int k)
{
SqlConnection connection = new SqlConnection(Util.GetConnectionString(server, db));
connection.Open();
string q = TrieQuery(db, table, column, nLookups);
SqlCommand sqlcmd = new SqlCommand(q, connection);
sqlcmd.CommandTimeout = 0;
string[] lookupStrings = new string[nLookups];
int idx = 0;
using (SqlDataReader reader = sqlcmd.ExecuteReader())
{
while (reader.Read())
{
lookupStrings[idx++] = reader.GetString(0);
}
}
connection.Close();
Stopwatch sw = new Stopwatch();
sw.Reset();
sw.Start();
foreach (string s in lookupStrings)
{
int nresults = t.Lookup(s, k);
}
sw.Stop();
return(sw.ElapsedMilliseconds);
}
