MySQL Memory 存储引擎浅析(8)

        }

        public static string DB_MemorySelect(int id)

        {

            string commandText = "SELECT obj FROM test_memory WHERE id = ?id";

            MySqlParameter[] parameters = {

                new MySqlParameter("?id", MySqlDbType.Int32)

            };

            parameters[0].Value = id;

            return DBUtility.MySqlHelper.ExecuteScalar(SQL_CONN, CommandType.Text, commandText, parameters).ToString();

        }

        #endregion

        #region Test Functions InnoDB

        static void InnoDBInsert()

        {

            long begin = DateTime.Now.Ticks;

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

            {

                DB_InnoDBInsert(OBJ);

            }

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

        }

        static void InnoDBSelect()

        {

            long begin = DateTime.Now.Ticks;

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

            {

                DB_InnoDBSelect(i);

            }

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

        }

        static void MyIsamInsert()