Example #1
0
        /// <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");
        }
Example #2
0
            /// <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;
 }