C# (CSharp) Tup.Cobar4Net.Route.Perf ShardingMultiTableSpace示例

示例#1

        /// <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");
        }

示例#2

文件： ShardingMultiTableSpace.cs 项目： tupunco/Tup.Cobar4Net

 /// <exception cref="System.Exception" />
 public static void Main(string[] args)
 {
     var test = new ShardingMultiTableSpace();
     Runtime.CurrentTimeMillis();
     var start = Runtime.CurrentTimeMillis();
     test.TestTableSpace();
     var end = Runtime.CurrentTimeMillis();
     Console.Out.WriteLine("take " + (end - start) + " ms.");
 }

示例#3

        /// <exception cref="System.Exception" />
        public static void Main(string[] args)
        {
            var test = new ShardingMultiTableSpace();

            Runtime.CurrentTimeMillis();
            var start = Runtime.CurrentTimeMillis();

            test.TestTableSpace();
            var end = Runtime.CurrentTimeMillis();

            Console.Out.WriteLine("take " + (end - start) + " ms.");
        }

示例#4

文件： ServerRoutePerformance.cs 项目： tupunco/Tup.Cobar4Net

 /// <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");
 }