MySQL Memory 存储引擎浅析(6)

        const int LOOP_TOTAL = 10000;

        const int LOOP_BEGIN = 8000;

        const int LOOP_END = 9000;

        #region Database Functions

        public static bool DB_InnoDBInsert(string obj)

        {

            string commandText = "INSERT INTO test_innodb (obj) VALUES (?obj)";

            MySqlParameter[] parameters = {

                new MySqlParameter("?obj", MySqlDbType.VarChar, 255)

            };

            parameters[0].Value = obj;

            if (DBUtility.MySqlHelper.ExecuteNonQuery(SQL_CONN, CommandType.Text, commandText, parameters) > 0)

                return true;

            else

                return false;

        }

        public static string DB_InnoDBSelect(int id)

        {

            string commandText = "SELECT obj FROM test_innodb 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();

        }

        public static bool DB_MyIsamInsert(string obj)

        {

            string commandText = "INSERT INTO test_myisam (obj) VALUES (?obj)";

            MySqlParameter[] parameters = {