/// <exception cref="System.Exception" /> public virtual void Perf() { TestProvider provider; provider = new InsertLongSQLGen(); provider = new InsertLongSQLGenShort(); provider = new SelectShort(); provider = new InsertLong(); provider = new SelectLongIn(); provider = new ShardingMultiTableSpace(); provider = new ShardingDefaultSpace(); provider = new ShardingTableSpace(); var schema = GetSchema(); var sql = provider.GetSql(); Console.Out.WriteLine(ServerRouter.Route(schema, sql, null, null)); var start = Runtime.CurrentTimeMillis(); provider.Route(schema, 1, sql); long end; var loop = 200 * 10000; start = Runtime.CurrentTimeMillis(); provider.Route(schema, loop, sql); end = Runtime.CurrentTimeMillis(); Console.Out.WriteLine((end - start) * 1000.0d / loop + " us"); }
/// <exception cref="System.Exception" /> public override string GetSql() { var sql = new InsertLong().GetSql(); var lexer = new MySqlLexer(sql); insert = new MySqlDmlInsertParser(lexer, new MySqlExprParser(lexer)).Insert(); return(sql); }
/// <exception cref="System.Exception" /> public virtual void Perf() { TestProvider provider; provider = new InsertLongSQLGen(); provider = new InsertLongSQLGenShort(); provider = new SelectShort(); provider = new InsertLong(); provider = new SelectLongIn(); provider = new ShardingMultiTableSpace(); provider = new ShardingDefaultSpace(); provider = new ShardingTableSpace(); var schema = GetSchema(); var sql = provider.GetSql(); Console.Out.WriteLine(ServerRouter.Route(schema, sql, null, null)); var start = Runtime.CurrentTimeMillis(); provider.Route(schema, 1, sql); long end; var loop = 200*10000; start = Runtime.CurrentTimeMillis(); provider.Route(schema, loop, sql); end = Runtime.CurrentTimeMillis(); Console.Out.WriteLine((end - start)*1000.0d/loop + " us"); }
/// <exception cref="System.Exception" /> public override string GetSql() { var sb = new StringBuilder("insert into offer_detail (offer_id, gmt) values "); for (var i = 0; i < 8; ++i) { if (i > 0) { sb.Append(", "); } sb.Append("(" + (i + 100) + ", now())"); } var sql = sb.ToString(); var lexer = new MySqlLexer(sql); insert = new MySqlDmlInsertParser(lexer, new MySqlExprParser(lexer)).Insert(); sqlSize = new InsertLong().GetSql().Length; return sql; }
/// <exception cref="System.Exception" /> public override string GetSql() { var sql = new InsertLong().GetSql(); var lexer = new MySqlLexer(sql); insert = new MySqlDmlInsertParser(lexer, new MySqlExprParser(lexer)).Insert(); return sql; }