Package com.bleujin.framework.db.procedure

Examples of com.bleujin.framework.db.procedure.IUserCommandBatch

168
169
170
171
172
173
174
175
176
177
178
179
180
        upt.execUpdate() ;
    }


    public void xtestBlobInsertBatch() throws Exception {
        IUserCommandBatch command = dc.createUserCommandBatch("insert into aaa## values(?,?,?,?)") ;
        command.addParam(0, new int[]{1,2,3}); ;
        command.addParamSize(1, "abcdefg", 3); ;
        command.addClobSize(2, getLongString(), 3);
        command.addBlobSize(3, "c:/temp/article.csv", 3);

        int result = command.execUpdate() ;
    }
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
    int batchCount = 3 ; // 10000 * 10 = 100,000
   
    StopWatch sw = new StopWatch() ;
    sw.start() ;
    for (int k = 0; k < batchCount; k++) {
      IUserCommandBatch cmd = dc.createUserCommandBatch("insert into performance_sample(a, b, c) values(?, ?, ?)") ;
      for (int i = 0; i < unitCount; i++) {
        cmd.addBatchParam(0, k * unitCount + i) ;
        cmd.addBatchParam(1, "No." + (k * unitCount + i) + ".....") ;
        cmd.addBatchParam(2, RandomUtil.nextRandomString(RandomUtil.nextRandomInt(10, 50), RandomUtil.NUMBER_CHAR_TYPE)) ;
      }
      cmd.execUpdate() ;
      cmd.clearParam() ;
      assertEquals(true, unitCount > sw.getTime()) ;
      sw.stop() ;
      sw.reset() ;
      sw.start() ;
    }
View Full Code Here
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
    dc.execUpdate("create table millon_tblt(no int primary key auto_increment, subject varchar(400), content text)") ;
    //dc.execUpdate("create unique index millon_pk on millon_tblt(no)") ;
  }
 
  public void insertBatch() throws Exception {
    IUserCommandBatch batch = dc.createUserCommandBatch("insert into millon_tblt(subject) values(?)") ;
   
    for (int k = 0; k < 5; k++) {
      for (int i = 0; i < 50000; i++) {
        // 10000 -> 4.1 sec
        // 100000 -> 33.547 sec
        batch.addBatchParam(0, i + " Batch ..............................................................................................................") ;
      }
      Debug.line() ;
      batch.execUpdate() ;
      batch.clearParam() ;
    }
  }
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
    StopWatch watch = new StopWatch();
    watch.start();
    int iMax = 100;
    int jMax = 5000;
    for (int i = 0; i < iMax; i++) {
      IUserCommandBatch batch = dc.createUserCommandBatch("insert into test values(?,?)");

      int[] a = new int[jMax];
      String[] b = new String[jMax];
      for (int j = 0; j < jMax; j++) {
        a[j] = j + i * iMax + aMax + 1;
        b[j] = "0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789:" + j;
      }
      batch.addParam(a).addParam(b);

      batch.execUpdate();
    }
    watch.stop();
    System.out.println("time(ms):" + watch.getTime());
  }
View Full Code Here
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
    dc.initSelf() ;
   
    String query = "insert into node_tblc#(uuid, ntid, name, explain, status, viewcount, reguserid, parentid, versionnum) " +
    "values(?,?,?,?,?, ?,?,?,?)" ;

    IUserCommandBatch batch = dc.createUserCommandBatch(query) ;
    int max = 1000 ;

    for (int i = 0; i < max; i++) {
      batch.addBatchParam(0, RandomUtil.nextRandomString(35, RandomUtil.DOWNCASE_CHAR_TYPE)) ;
      batch.addBatchParam(1, RandomUtil.nextRandomString(10, RandomUtil.DOWNCASE_CHAR_TYPE)) ;
      batch.addBatchParam(2, RandomUtil.nextRandomString(10, RandomUtil.DOWNCASE_CHAR_TYPE)) ;
      batch.addBatchParam(3, RandomUtil.nextRandomString(20, RandomUtil.DOWNCASE_CHAR_TYPE)) ;
      batch.addBatchParam(4, "NORMAL") ;
      batch.addBatchParam(5, RandomUtil.nextInt()) ;
      batch.addBatchParam(6, RandomUtil.nextRandomString(12, RandomUtil.DOWNCASE_CHAR_TYPE)) ;
      batch.addBatchParam(7, RandomUtil.nextRandomString(10, RandomUtil.DOWNCASE_CHAR_TYPE)) ;
      batch.addBatchParam(8, RandomUtil.nextInt()) ;
    }
    batch.execUpdate() ;
    dc.destroySelf() ;
  }
View Full Code Here
TOP

Related Classes of com.bleujin.framework.db.procedure.IUserCommandBatch

  • com.bleujin.framework.db.mysql.TestFirst
  • com.bleujin.framework.db.performance.TestFirst
  • com.bleujin.framework.db.sample.extend.NamedParameter
  • com.bleujin.framework.db.sample.first.P3_BatchCommandQuery
  • com.bleujin.framework.db.sample.performance.BatchInsertSpeed
  • com.bleujin.framework.db.TestBatchSpeed
  • com.bleujin.framework.db.TestDefaultFn
  • com.bleujin.framework.db.TestLobTest
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.