MySQL Memory 存储引擎浅析(10)

            }

            Console.WriteLine("Memory SELECT Result: {0}", DateTime.Now.Ticks - begin);

        }

        static void DataTableInsertAndSelect()

        {

            //Insert

            DataTable dt = new DataTable();

            dt.Columns.Add("id", Type.GetType("System.Int32"));

            dt.Columns["id"].AutoIncrement = true;

            dt.Columns.Add("obj", Type.GetType("System.String"));

            DataRow dr = null;

            long begin = DateTime.Now.Ticks;

            for (int i = 0; i < LOOP_TOTAL; i++)

            {

                dr = null;

                dr = dt.NewRow();

                dr["obj"] = OBJ;

                dt.Rows.Add(dr);

            }

            Console.WriteLine("DataTable Insert Result: {0}", DateTime.Now.Ticks - begin);

            //Select

            long begin1 = DateTime.Now.Ticks;

            for (int i = LOOP_BEGIN; i < LOOP_END; i++)

            {

                dt.Select("id = " + i);

            }

            Console.WriteLine("DataTable Select Result: {0}", DateTime.Now.Ticks - begin1);

        }