{"id":2227,"date":"2011-06-01T16:53:07","date_gmt":"2011-06-01T07:53:07","guid":{"rendered":"http:\/\/www.moonmile.net\/blog\/archives\/2227"},"modified":"2011-06-02T13:29:17","modified_gmt":"2011-06-02T04:29:17","slug":"select-%e3%81%ae%e3%83%91%e3%83%95%e3%82%a9%e3%83%bc%e3%83%9e%e3%83%b3%e3%82%b9%e3%83%81%e3%82%a7%e3%83%83%e3%82%af%ef%bc%88%e7%b6%9a%e3%81%8d%ef%bc%89","status":"publish","type":"post","link":"http:\/\/www.moonmile.net\/blog\/archives\/2227","title":{"rendered":"SELECT \u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30c1\u30a7\u30c3\u30af\uff08\u7d9a\u304d\uff09"},"content":{"rendered":"

\n.NET \u3092\u4f7f\u3063\u3066 SQL Server \u306b\u5bfe\u3057\u3066 SELECT \u3059\u308b\u306b\u306f\u3001\u3063\u3066\u3053\u3068\u3067\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u30c1\u30a7\u30c3\u30af\u3092\u3057\u307e\u3057\u305f\u3002\n<\/p>\n

    \n
  1. 10 \u500b\u306e\u30c6\u30fc\u30d6\u30eb\u306b 20000 \u4ef6\u305a\u3064\u30c7\u30fc\u30bf\u3092\u5165\u308c\u3066\u304a\u304d\u307e\u3059\u3002<\/li>\n
  2. 10 \u500b\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u5bfe\u3057\u3066\u30012000 \u56de\u305a\u3064\u691c\u7d22\u3057\u307e\u3059\u3002<\/li>\n
  3. \u30c6\u30fc\u30d6\u30eb\u306b\u306f\u4e3b\u30ad\u30fc\u3092\u4ed8\u3051\u3066\u304a\u304d\u307e\u3059\u3002<\/li>\n<\/ol>\n

    \n\u3068\u3044\u3046\u5f62\u3067\u30c7\u30fc\u30bf\u3092\u4f5c\u3063\u3066\u304a\u3044\u3066\u3001\u4ee5\u4e0b\u306e\u30d1\u30bf\u30fc\u30f3\u3067\u691c\u7d22\u3092\u3057\u307e\u3059\u3002\n<\/p>\n

      \n
    1. \u500b\u5225\u306b SqlDataAdapter \u3092\u4f7f\u3063\u3066\u547c\u3073\u51fa\u3057<\/li>\n
    2. 10 \u500b\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u691c\u7d22\u3092\u3072\u3068\u3064\u306b\u307e\u3068\u3081\u3066\u3001SqlDataAdapter \u3067\u547c\u3073\u51fa\u3057<\/li>\n
    3. 10 \u500b\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u691c\u7d22\u3092\u3072\u3068\u3064\u306b\u307e\u3068\u3081\u3066\u3001SqlCommand \u3067\u547c\u3073\u51fa\u3057<\/li>\n
    4. LINQ to Entities \u3092\u4f7f\u3063\u3066\u547c\u3073\u51fa\u3057<\/li>\n
    5. LINQ to SQL \u3092\u4f7f\u3063\u3066\u547c\u3073\u51fa\u3057<\/li>\n<\/ol>\n
      \n1.\u500b\u5225SELECT\n56.5\n59.3\n57.5\n\n2.\u307e\u3068\u3081\u3066SELECT\n\u203b 1 \u3088\u308a\u9045\u304f\u306a\u3063\u305f\u306e\u3067\u30d1\u30b9\n\n3.SqlCommand\n7.6\n7.5\n7.4\n\n4.LINQ to Entities\n112.5\n110.6\n108.2\n\n5.LINQ to SQL\n92.4\n112.3\n93.9\n<\/pre>\n
      \n\u7d50\u8ad6\u304b\u3089\u8a00\u3048\u3070\u3001\n<\/p>\n
        \n
      1. \u500b\u5225SELECT\u3088\u308a\u3082\u3001LINQ \u3092\u4f7f\u3046\u3068 2 \u500d\u3050\u3089\u3044\u9045\u304f\u306a\u308b\u3002<\/li>\n
      2. LINQ to Entities \u3068 LINQ to SQL \u306f\u30b9\u30d4\u30fc\u30c9\u304c\u5909\u308f\u3089\u306a\u3044\u3002<\/li>\n
      3. SqlCommand \u3092\u4f7f\u3046\u3068\u3001\u500b\u5225SELECT\u3088\u308a\u3082 5 \u500d\u4ee5\u4e0a\u3001LINQ \u3088\u308a\u3082 10 \u500d\u4ee5\u4e0a\u65e9\u3044\u3002<\/li>\n<\/ol>\n
        \n\u3068\u3044\u3046\u7d50\u679c\u306b\u306a\u308a\u307e\u3057\u305f\u3002\n<\/p>\n
        \nLINQ \u306e\u5834\u5408\u300110 \u500b\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u5bfe\u3057\u3066\u3001\u691c\u7d22\u3092\u5b9f\u884c\u3059\u308b\u305f\u3081\u306b 10 \u56de\u547c\u3073\u51fa\u3057\u3066\u3057\u307e\u3046\u306e\u3067\u3001\u3053\u306e\u624b\u306e\u65b9\u6cd5\u306f\u4e0d\u5229\u306a\u306e\u3067\u3059\u304c\u3001SqlDataAdapter \u3088\u308a\u3082\u9045\u3044\u306e\u306f\u610f\u5916\u3067\u3059…\u30b9\u30d4\u30fc\u30c9\u304c\u8981\u6c42\u3055\u308c\u308b\u3068\u3053\u308d\u3067\u3001LINQ \u3092\u4f7f\u3046\u306e\u306f\u7981\u7269\u3067\u3059\u306d\u3002\n<\/p>\n
        \n\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u3068\u3057\u3066\u306f\u3001SqlCommand \u304c\u4e00\u756a\u3084\u308a\u3084\u3059\u304f\u300110 \u500b\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u5bfe\u3059\u308b SELECT \u3092 1 \u56de\u3067\u6e08\u307e\u305b\u3089\u308c\u308b\u306e\u3082 SQL Server \u3067\u8907\u6570\u306e\u691c\u7d22\u7d50\u679c\uff08DataTable\uff09\u3092\u8fd4\u305b\u308b\u304b\u3089\u3067\u3059\u3002
        \n\u307e\u305f\u3001prepared statements \u3068\u3044\u3046\u5f62\u3067\u3001\u3042\u3089\u304b\u3058\u3081 SQL \u6587\u3092\u767a\u884c\u3055\u305b\u3066\u518d\u5229\u7528\u3067\u304d\u308b\u3068\u308d\u3082 SqlCommand \u306e\u6709\u5229\u306a\u3068\u3053\u308d\u3067\u3059\u306d\u3002\n<\/p>\n
        \n\u5b9f\u9a13\u30bd\u30fc\u30b9\u3092\u6652\u3057\u3066\u304a\u304d\u307e\u3059\u3002\n<\/p>\n
        \n\u25a0\u30c6\u30fc\u30d6\u30eb\u306e\u4f5c\u6210\n<\/p>\n
        \n\/\/\/ <summary>\n\/\/\/ \u30c6\u30fc\u30d6\u30eb\u4f5c\u6210\n\/\/\/ <\/summary>\n\/\/\/ <param name=&quot;sender&quot;><\/param>\n\/\/\/ <param name=&quot;e&quot;><\/param>\nprivate void button1_Click(object sender, EventArgs e)\n{\n    string sql = &quot;&quot;;\n    SqlConnection cn = new SqlConnection(CNSTR);\n    cn.Open();\n    SqlCommand cmd;\n    for (int i = 0; i < 10; i++)\n    {\n        sql = string.Format(&quot;drop table table{0}&quot;, i);\n        cmd = new SqlCommand(sql, cn);\n        try\n        {\n            cmd.ExecuteNonQuery();\n        }\n        catch { }\n\n        sql = string.Format(&quot;create table table{0} (&quot;, i);\n        for (int j = 0; j < 10; j++)\n        {\n\t\t\tif (j == 0)\n\t\t\t{\n\t\t\t\tsql += string.Format(&quot;col{0} varchar(50) not null,&quot;, j);\n\t\t\t}\n\t\t\telse\n\t\t\t{\n\t\t\t\tsql += string.Format(&quot;col{0} varchar(50),&quot;, j);\n\t\t\t}\n        }\n\t\tsql += string.Format(&quot; CONSTRAINT pk_table{0} PRIMARY KEY ( col0 ) &quot;, i );\n        sql += &quot;)&quot;;\n        cmd = new SqlCommand(sql, cn);\n        cmd.ExecuteNonQuery();\n    }\n    cn.Close();\n}\n<\/pre>\n
        \n\u25a020000\u4ef6\u306e\u30c7\u30fc\u30bf insert\n<\/p>\n
        \n\/\/\/ <summary>\n\/\/\/ \u30c7\u30fc\u30bf\u4f5c\u6210\n\/\/\/ <\/summary>\n\/\/\/ <param name=&quot;sender&quot;><\/param>\n\/\/\/ <param name=&quot;e&quot;><\/param>\nprivate void button2_Click(object sender, EventArgs e)\n{\n    int max = int.Parse(textBox1.Text);\n    SqlConnection cn = new SqlConnection(CNSTR);\n    cn.Open();\n\n    string s = toMD5(DateTime.Now.ToString());\n    int count = 0;\n    for (int i = 0; i < 10; i++)\n    {\n        string sql = string.Format(&quot;insert into table{0} values (&quot;, i);\n        SqlCommand cmd = new SqlCommand(&quot;&quot;, cn);\n        for (int k = 0; k < 10; k++)\n        {\n            cmd.Parameters.Add(new SqlParameter(\n                string.Format(&quot;@col{0}&quot;, k), SqlDbType.VarChar, 50));\n            sql += string.Format(&quot;@col{0},&quot;, k);\n        }\n        sql = sql.Substring(0, sql.Length - 1);\n        sql += &quot;)&quot;;\n        cmd.CommandText = sql;\n\n        for (int j = 0; j < max; j++)\n        {\n            for (int k = 0; k < 10; k++)\n            {\n                s = toMD5(s);\n                cmd.Parameters[k].Value = s;\n            }\n            cmd.ExecuteNonQuery();\n            count++;\n            if (count % 100 == 0)\n            {\n                toStatus(count, max * 10);\n            }\n        }\n    }\n    cn.Close();\n}\n<\/pre>\n
        \n\u25a0\u500b\u5225SELECT\n<\/p>\n
        \n\u307e\u305a\u3044\u3084\u308a\u65b9\u3067\u3059\u304c\u3001string.Format \u3067\u5024\u8fbc\u307f\u3067\u6587\u5b57\u5217\u3092\u4f5c\u3063\u3066\u3044\u307e\u3059\u3002
        \n\u3088\u304f\u3042\u308b\u30d1\u30bf\u30fc\u30f3\u3067\u3059\u306d\u3002\n<\/p>\n
        \n\/\/\/ <summary>\n\/\/\/ \u500b\u5225SELECT\n\/\/\/ <\/summary>\n\/\/\/ <param name=&quot;sender&quot;><\/param>\n\/\/\/ <param name=&quot;e&quot;><\/param>\nprivate void button3_Click(object sender, EventArgs e)\n{\n    \/\/ \u5f8b\u5100\u306bSELECT\u6587\u309210\u56de\u767a\u884c\u3057\u307e\u3059\u3002\n    DateTime start = DateTime.Now;\n    string s = toMD5(start.ToString());\n    int count = 0;\n    SqlConnection cn = new SqlConnection(CNSTR);\n    int max = 2000;\n    for (int i = 0; i < max; i++)\n    {\n        for ( int j=0; j<10; j++ ) {\n            DataTable dt = new DataTable();\n            SqlDataAdapter da = new SqlDataAdapter(\n                string.Format(&quot;SELECT * FROM table{0} WHERE col0 = '{1}'&quot;, j, s), cn);\n            s = toMD5(s);\n            da.Fill( dt );\n        }\n        if (++count % 10 == 0)\n            toStatus(count, max);\n    }\n    DateTime end = DateTime.Now;\n    textBox2.Text = ((TimeSpan)(end - start)).TotalSeconds.ToString(&quot;#.0&quot;);\n}\n<\/pre>\n
        \n\u25a0\u307e\u3068\u3081\u3066SELECT\n<\/p>\n
        \nSqlDataAdapter \u306b\u6e21\u3059 SQL \u6587\u3092\u3072\u3068\u307e\u3068\u3081\u306b\u3057\u305f\u306e\u3067\u3059\u304c\u3001\u5168\u7136\u99c4\u76ee\u3067\u3059\u3002\n<\/p>\n
        \n\/\/\/ <summary>\n\/\/\/ \u307e\u3068\u3081\u3066SELECT\n\/\/\/ <\/summary>\n\/\/\/ <param name=&quot;sender&quot;><\/param>\n\/\/\/ <param name=&quot;e&quot;><\/param>\n\/\/\/ <remarks>\n\/\/\/ \u9045\u304f\u3066\u305c\u3093\u305c\u3093\u3060\u3081\n\/\/\/ <\/remarks>\nprivate void button4_Click(object sender, EventArgs e)\n{\n    \/\/ 10\u56de\u306eSELECT\u3092\u3072\u3068\u307e\u3068\u3081\u306b\u3057\u3066 DataSet \u306b\u4fdd\u5b58\u3057\u307e\u3059\u3002\n    DateTime start = DateTime.Now;\n    string s = toMD5(start.ToString());\n    int count = 0;\n    SqlConnection cn = new SqlConnection(CNSTR);\n    string sql = &quot;&quot;;\n    int max = 2000;\n    for (int i = 0; i < max; i++)\n    {\n        for (int j = 0; j < 10; j++)\n        {\n            sql += string.Format(&quot;SELECT * FROM table{0} WHERE col0 = '{1}' &quot;, j, s);\n            s = toMD5(s);\n        }\n        DataSet ds = new DataSet();\n        SqlDataAdapter da = new SqlDataAdapter(sql, cn);\n        da.Fill(ds);\n        if (++count % 10 == 0)\n            toStatus(count, max );\n    }\n    DateTime end = DateTime.Now;\n    textBox2.Text = ((TimeSpan)(end - start)).TotalSeconds.ToString(&quot;#.0&quot;);\n}\n<\/pre>\n
        \n\u25a0SqlCommand \u3092\u4f7f\u3046\n<\/p>\n
        \n\u3042\u3089\u304b\u3058\u3081\u30b3\u30f3\u30d1\u30a4\u30eb\u3055\u308c\u308b\u3088\u3046\u306b SqlCommand \u3092\u4f7f\u3044\u307e\u3059\u3002
        \n\u30eb\u30fc\u30d7\u306e\u4e2d\u3067 SqlCommand \u3092\u4f7f\u3063\u3066\u306f\u3044\u3051\u307e\u305b\u3093\u3002\u30eb\u30fc\u30d7\u306e\u5916\u3067\u4f5c\u6210\u3057\u3066\u3001\u30d1\u30e9\u30e1\u30fc\u30bf\u3067\u6e21\u3057\u307e\u3059\u3002<\/p>\n
        \n\/\/\/ <summary>\n\/\/\/ SqlCommand \u306e\u5229\u7528\n\/\/\/ <\/summary>\n\/\/\/ <param name=&quot;sender&quot;><\/param>\n\/\/\/ <param name=&quot;e&quot;><\/param>\nprivate void button5_Click(object sender, EventArgs e)\n{\n    \/\/ 10\u56de\u306eSELECT\u3092\u3072\u3068\u307e\u3068\u3081\u306b\u3057\u3066 DataSet \u306b\u4fdd\u5b58\u3057\u307e\u3059\u3002\n    DateTime start = DateTime.Now;\n    string s = toMD5(start.ToString());\n    int count = 0;\n    SqlConnection cn = new SqlConnection(CNSTR);\n    string sql = &quot;&quot;;\n<\/p>\n<p>\n    SqlCommand cmd = new SqlCommand(&quot;&quot;,cn);\n    for (int j = 0; j < 10; j++)\n    {\n        sql += string.Format(&quot;SELECT * FROM table{0} WHERE col0 = @param{1} &quot;, j, j);\n        s = toMD5(s);\n        cmd.Parameters.Add(new SqlParameter(\n            string.Format(&quot;@param{0}&quot;, j), SqlDbType.VarChar, 50));\n    }\n    cmd.CommandText = sql;\n<\/p>\n<p>\n    int max = 2000;\n    for (int i = 0; i < max; i++)\n    {\n        for (int j = 0; j < 10; j++)\n        {\n            cmd.Parameters[j].Value = s;\n            s = toMD5(s);\n        }\n        DataSet ds = new DataSet();\n        SqlDataAdapter da = new SqlDataAdapter(cmd);\n        da.Fill(ds);\n        if (++count % 10 == 0)\n            toStatus(count, max);\n    }\n    DateTime end = DateTime.Now;\n    textBox2.Text = ((TimeSpan)(end - start)).TotalSeconds.ToString(&quot;#.0&quot;);\n}\n<\/pre>\n<\/p>\n
        \n\u25a0LINQ to Entities\n<\/p>\n
        \n\u6bd4\u8f03\u306e\u305f\u3081\u306b LINQ to Entities \u3067\u3082\u4f5c\u3063\u3066\u307f\u307e\u3059\u3002
        \nLINQ \u306e\u5834\u5408\u306f\u3001\u8907\u6570\u306e SELECT \u6587\u3092\u307e\u3068\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u306a\u3044\u306e\u3067\u3001\u30eb\u30fc\u30d7\u306e\u4e2d\u3067 10 \u56de\u547c\u3073\u51fa\u3057\u307e\u3059\u3002\u3053\u306e\u65b9\u6cd5\u306f\u3001SqlDataAdapter \u3068\u540c\u3058\u3067\u3059\u3088\u306d\u3002
        \n\u30b9\u30d4\u30fc\u30c9\u3092\u6bd4\u8f03\u3057\u305f\u3082\u306e\u304c\u306a\u3044\u306e\u3067\u3001\u521d\u3081\u3066\u8a66\u3057\u3066\u307f\u305f\u306e\u3067\u3059\u304c\u3001\u500b\u5225SELECT\u3088\u308a\u30822\u500d\u307b\u3069\u304a\u305d\u304f\u306a\u308a\u307e\u3059\u3002\n<\/p>\n
        \n\/\/\/ <summary>\n\/\/\/ LINQ to Entities \u306e\u5229\u7528\n\/\/\/ <\/summary>\n\/\/\/ <param name=&quot;sender&quot;><\/param>\n\/\/\/ <param name=&quot;e&quot;><\/param>\nprivate void button6_Click(object sender, EventArgs e)\n{\n\t\/\/ \u5f8b\u5100\u306bSELECT\u6587\u309210\u56de\u767a\u884c\u3057\u307e\u3059\u3002\n\tDateTime start = DateTime.Now;\n\tstring s = toMD5(start.ToString());\n\tint count = 0;\n\n\tstressEntities ent = new stressEntities();\n\tint max = 2000;\n\tfor (int i = 0; i < max; i++)\n\t{\n\t\tvar items0 = from t in ent.table0\n\t\t\t\t\twhere t.col0 == s\n\t\t\t\t\tselect t;\n\t\ts = toMD5(s);\n\t\tvar item1 = from t in ent.table1\n\t\t\t\t\t\twhere t.col0 == s\n\t\t\t\t\t\tselect t;\n\t\ts = toMD5(s);\n\t\tvar items2 = from t in ent.table2\n\t\t\t\t\t\twhere t.col0 == s\n\t\t\t\t\t\tselect t;\n\t\ts = toMD5(s);\n\t\tvar items3 = from t in ent.table3\n\t\t\t\t\t\twhere t.col0 == s\n\t\t\t\t\t\tselect t;\n\t\ts = toMD5(s);\n\t\tvar items4 = from t in ent.table4\n\t\t\t\t\t\twhere t.col0 == s\n\t\t\t\t\t\tselect t;\n\t\ts = toMD5(s);\n\t\tvar items5 = from t in ent.table5\n\t\t\t\t\t\twhere t.col0 == s\n\t\t\t\t\t\tselect t;\n\t\ts = toMD5(s);\n\t\tvar items6 = from t in ent.table6\n\t\t\t\t\t\twhere t.col0 == s\n\t\t\t\t\t\tselect t;\n\t\ts = toMD5(s);\n\t\tvar items7 = from t in ent.table7\n\t\t\t\t\t\twhere t.col0 == s\n\t\t\t\t\t\tselect t;\n\t\ts = toMD5(s);\n\t\tvar items8 = from t in ent.table8\n\t\t\t\t\t\twhere t.col0 == s\n\t\t\t\t\t\tselect t;\n\t\ts = toMD5(s);\n\t\tvar items9 = from t in ent.table9\n\t\t\t\t\t\twhere t.col0 == s\n\t\t\t\t\t\tselect t;\n\t\ts = toMD5(s);\n\n\t\tvar it0 = items0.SingleOrDefault();\n\t\tvar it1 = items0.SingleOrDefault();\n\t\tvar it2 = items0.SingleOrDefault();\n\t\tvar it3 = items0.SingleOrDefault();\n\t\tvar it4 = items0.SingleOrDefault();\n\t\tvar it5 = items0.SingleOrDefault();\n\t\tvar it6 = items0.SingleOrDefault();\n\t\tvar it7 = items0.SingleOrDefault();\n\t\tvar it8 = items0.SingleOrDefault();\n\t\tvar it9 = items0.SingleOrDefault();\n\n\t\tif (++count % 10 == 0)\n\t\t\ttoStatus(count, max);\n\t}\n\tDateTime end = DateTime.Now;\n\ttextBox2.Text = ((TimeSpan)(end - start)).TotalSeconds.ToString(&quot;#.0&quot;);\n}\n<\/pre>\n
        \n\u25a0LINQ to SQL \u3092\u5229\u7528\n<\/p>\n
        \n\u6bd4\u8f03\u306e\u305f\u3081\u306b LINQ to SQL \u3067\u3082\u52d5\u304b\u3057\u3066\u307f\u307e\u3059\u3002
        \n\u4e0d\u5229\u306a\u306e\u306f\u3001LINQ to Entities \u3068\u540c\u3058\u3067\u300110 \u56de\u547c\u3073\u51fa\u3055\u306a\u3044\u3068\u3044\u3051\u306a\u3044\u3068\u3053\u308d\u3067\u3059\u306d\u3002
        \n\u30b9\u30d4\u30fc\u30c9\u306b\u95a2\u3057\u3066\u306f\u3001LINQ to Entities \u3068\u5909\u308f\u308a\u307e\u305b\u3093\u3002\n<\/p>\n
        \n\/\/\/ <summary>\n\/\/\/ LINQ to SQL \u306e\u5229\u7528\n\/\/\/ <\/summary>\n\/\/\/ <param name=&quot;sender&quot;><\/param>\n\/\/\/ <param name=&quot;e&quot;><\/param>\nprivate void button7_Click(object sender, EventArgs e)\n{\n\t\/\/ \u5f8b\u5100\u306bSELECT\u6587\u309210\u56de\u767a\u884c\u3057\u307e\u3059\u3002\n\tDateTime start = DateTime.Now;\n\tstring s = toMD5(start.ToString());\n\tint count = 0;\n\n    SqlConnection cn = new SqlConnection(CNSTR);\n\tDataClasses1DataContext cnt = new DataClasses1DataContext(cn);\n\n\tint max = 2000;\n\tfor (int i = 0; i < max; i++)\n\t{\n\t\tvar items0 = from t in cnt.Dtable0\n\t\t\t\t\t\twhere t.col0 == s\n\t\t\t\t\t\tselect t;\n\t\ts = toMD5(s);\n\t\tvar item1 = from t in cnt.Dtable1\n\t\t\t\t\twhere t.col0 == s\n\t\t\t\t\tselect t;\n\t\ts = toMD5(s);\n\t\tvar items2 = from t in cnt.Dtable2\n\t\t\t\t\t\twhere t.col0 == s\n\t\t\t\t\t\tselect t;\n\t\ts = toMD5(s);\n\t\tvar items3 = from t in cnt.Dtable3\n\t\t\t\t\t\twhere t.col0 == s\n\t\t\t\t\t\tselect t;\n\t\ts = toMD5(s);\n\t\tvar items4 = from t in cnt.Dtable4\n\t\t\t\t\t\twhere t.col0 == s\n\t\t\t\t\t\tselect t;\n\t\ts = toMD5(s);\n\t\tvar items5 = from t in cnt.Dtable5\n\t\t\t\t\t\twhere t.col0 == s\n\t\t\t\t\t\tselect t;\n\t\ts = toMD5(s);\n\t\tvar items6 = from t in cnt.Dtable6\n\t\t\t\t\t\twhere t.col0 == s\n\t\t\t\t\t\tselect t;\n\t\ts = toMD5(s);\n\t\tvar items7 = from t in cnt.Dtable7\n\t\t\t\t\t\twhere t.col0 == s\n\t\t\t\t\t\tselect t;\n\t\ts = toMD5(s);\n\t\tvar items8 = from t in cnt.Dtable8\n\t\t\t\t\t\twhere t.col0 == s\n\t\t\t\t\t\tselect t;\n\t\ts = toMD5(s);\n\t\tvar items9 = from t in cnt.Dtable9\n\t\t\t\t\t\twhere t.col0 == s\n\t\t\t\t\t\tselect t;\n\t\ts = toMD5(s);\n\n\t\tvar it0 = items0.SingleOrDefault();\n\t\tvar it1 = items0.SingleOrDefault();\n\t\tvar it2 = items0.SingleOrDefault();\n\t\tvar it3 = items0.SingleOrDefault();\n\t\tvar it4 = items0.SingleOrDefault();\n\t\tvar it5 = items0.SingleOrDefault();\n\t\tvar it6 = items0.SingleOrDefault();\n\t\tvar it7 = items0.SingleOrDefault();\n\t\tvar it8 = items0.SingleOrDefault();\n\t\tvar it9 = items0.SingleOrDefault();\n\n\t\tif (++count % 10 == 0)\n\t\t\ttoStatus(count, max);\n\t}\n\tDateTime end = DateTime.Now;\n\ttextBox2.Text = ((TimeSpan)(end - start)).TotalSeconds.ToString(&quot;#.0&quot;);\n}\n<\/pre>\n
        \n\u305d\u3093\u306a\u8a33\u3067\u3001\u5b9f\u884c\u6642\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u304c\u6c17\u306b\u304b\u304b\u308b\u5834\u5408\u306f\u3001SqlCommand \u306b\u3059\u308b\u3068 10 \u500d\u307b\u3069\u65e9\u304f\u306a\u308b\u3088\u3001\u3068\u3044\u3046\u8a71\u3067\u3059\u3002\u9006\u306b\u8a00\u3048\u3070\u3001\u305f\u3044\u3057\u3066\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u304c\u6c17\u306b\u306a\u3089\u306a\u3044\u3068\u304d\u306f\u3001\u66f8\u304d\u3084\u3059\u3044 LINQ \u3092\u4f7f\u3063\u305f\u307b\u3046\u304c\u3088\u3044\u3067\u3057\u3087\u3046\u3063\u3066\u3053\u3068\u3067\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
        .NET \u3092\u4f7f\u3063\u3066 SQL Server \u306b\u5bfe\u3057\u3066 SELECT \u3059\u308b\u306b\u306f\u3001\u3063\u3066\u3053\u3068\u3067\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u30c1\u30a7\u30c3\u30af\u3092\u3057\u307e\u3057\u305f\u3002 10 \u500b\u306e\u30c6\u30fc\u30d6\u30eb\u306b 20000 \u4ef6\u305a\u3064\u30c7\u30fc\u30bf\u3092\u5165\u308c\u3066\u304a\u304d\u307e\u3059\u3002 10 \u500b\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u5bfe\u3057\u3066\u30012 … \u7d9a\u304d\u3092\u8aad\u3080 →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3,23],"tags":[],"class_list":["post-2227","post","type-post","status-publish","format-standard","hentry","category-dev","category-csharp"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts\/2227","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/comments?post=2227"}],"version-history":[{"count":1,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts\/2227\/revisions"}],"predecessor-version":[{"id":2229,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts\/2227\/revisions\/2229"}],"wp:attachment":[{"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/media?parent=2227"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/categories?post=2227"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/tags?post=2227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}