private void SelectROWIDs(int nTimes, int[] ROWIDs)
{
var paramROWID = new SqlParameter("ROWID", System.Data.SqlDbType.BigInt);
var ridRow = new object[3];
var nTotalROWIDs = 0L;
var nTotalBytesROWIDs = 0L;
SutROWIDStopwatch.Restart();
for (int i = 0; i < nTimes; i++)
{
paramROWID.Value = ROWIDs[i];
SutROWIDCommand.Parameters.Clear();
SutROWIDCommand.Parameters.Add(paramROWID);
var reader = SutROWIDCommand.ExecuteReader(System.Data.CommandBehavior.Default);
if (reader.HasRows)
{
while (reader.Read())
{
reader.GetValues(ridRow);
nTotalROWIDs++;
nTotalBytesROWIDs += (((byte[])ridRow[0]).Length + BitConverter.GetBytes((long)ridRow[1]).Length + Encoding.Default.GetBytes((string)ridRow[2]).Length);
}
}
else
{
Console.WriteLine("No rows found.");
}
reader.Close();
}
SutROWIDStopwatch.Stop();
Console.WriteLine("- Total ROWID rows read: **{0}** / Total Bytes read: **{1}** / Total ms: **{2}**", nTotalROWIDs, nTotalBytesROWIDs, SutROWIDStopwatch.ElapsedMilliseconds);
}
private void ArrangeIDs(int nTimes, int[] ROWIDs, byte[][] GDIDs)
{
// First pass needed to just fill the buffer of GDIDs.
var paramROWID = new SqlParameter("ROWID", System.Data.SqlDbType.BigInt);
var ridRow = new object[3];
for (int i = 0; i < nTimes; i++)
{
paramROWID.Value = ROWIDs[i];
SutROWIDCommand.Parameters.Clear();
SutROWIDCommand.Parameters.Add(paramROWID);
var reader = SutROWIDCommand.ExecuteReader(System.Data.CommandBehavior.Default);
if (reader.HasRows)
{
while (reader.Read())
{
reader.GetValues(ridRow);
if (i < 10)
{
Console.WriteLine(ridRow[1].ToString());
}
GDIDs[i] = (byte[])ridRow[0];
}
}
else
{
Console.WriteLine("No rows found.");
}
reader.Close();
}
}
