之前写的批量插值程序只是五六半自动版本，因为表的字段还需要手工填写，这回只要指定表名和要插多少数据就行了，类似于全自动突击步枪，扣动扳机就把字段打完为止。
全自动程序如下，诸位拿下去后可以修改成自己想要的样子：
package com.hy.tableautoinsert; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.sql.Statement; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Calendar; import java.util.Date; import java.util.List; import org.apache.log4j.Logger; import com.hy.DBParam; class TbCnt{ String tb;// tablename int cnt;// count should be inserted public TbCnt(String tb,int cnt) { this.tb=tb; this.cnt=cnt; } } class Field{ String name; // 列名 int size; // 列容量 String type; // 列数据类型 boolean allowNull;// 列是否允許为空 } /** * 输入表名和需要插入的记录数，自动将所需记录插入表，不需要指定主键和必填字段 * @author 逆火 * * 2019年11月23日 下午2:19:02 */ public class TableAutoInserter { private static Logger log = Logger.getLogger(TableAutoInserter.class); private final int BatchSize=250;// 一次性插入记录数 private List<TbCnt> tbCntList;// 容纳表名和插入数量的链表 /** * 构造函数 */ public TableAutoInserter() { tbCntList=new ArrayList<TbCnt>(); } /** * 加入一张要插入的表 * @param tc * @return */ public TableAutoInserter add(TbCnt tc) { tbCntList.add(tc); return this; } /** * 给已有的所有表插值 */ public void insertAllTables() { Connection conn = null; Statement stmt = null; try{ Class.forName(DBParam.Driver).newInstance(); conn = DriverManager.getConnection(DBParam.DbUrl, DBParam.User, DBParam.Pswd); stmt = conn.createStatement(); log.info("Begin to access "+DBParam.DbUrl+" as "+DBParam.User+"..."); int index=0; for(TbCnt tc:tbCntList) { String table=tc.tb; int count=tc.cnt; long startTime = System.currentTimeMillis(); truncateTable(table,conn,stmt); List<TypeField> fieldList=fetchTableFields(conn,stmt,table,false); insertDataToTable(index,table,count,fieldList,conn,stmt); if(isAllInserted(count,table,stmt)) { long endTime = System.currentTimeMillis(); log.info("#"+index+" "+count+" records were inserted to table:'" + table + "' used " + sec2DHMS(startTime,endTime) ); } index++; } } catch (Exception e) { System.out.print(e.getMessage()); e.printStackTrace(); } finally { try { stmt.close(); conn.close(); } catch (SQLException e) { log.error("Can't close stmt/conn because of " + e.getMessage()); } } } /** * 从表中取字段信息 * @param conn * @param stmt * @param table * @param isFetchall:此参数为真时取所有字段，为假时取非空字段 * @return * @throws Exception */ private List<TypeField> fetchTableFields(Connection conn,Statement stmt,String table,boolean isFetchall) throws SQLException{ List<TypeField> fields=new ArrayList<TypeField>(); String sql = "select * from "+table+""; ResultSet rs = stmt.executeQuery(sql); ResultSetMetaData rsMetadata = rs.getMetaData(); int count = rsMetadata.getColumnCount(); for (int i=0; i<count; i++) { int index=i+1; String columnName = rsMetadata.getColumnLabel(index);// 列名 String columnType = rsMetadata.getColumnTypeName(index);// 列数据类型 boolean allowNull=(rsMetadata.isNullable(index)!=0);// 列是否允許为空 //int size =rsMetadata.getColumnDisplaySize(index);// 列容量 此值在数据超过列容量限制时能用到 TypeField tf=new TypeField(); tf.field=columnName; tf.type=getShortType(columnName,columnType); if(isFetchall==true) { fields.add(tf); }else { if(allowNull==false) { fields.add(tf); } } } rs.close(); return fields; } /** * 得到列类型的短名称，此短名称在getInsertSql函数中会用到 * @param columnType * @return * @throws SQLException */ private String getShortType(String field,String columnType) throws SQLException{ if(field.equalsIgnoreCase("id")) { return "PK"; } if(columnType.equalsIgnoreCase("timestamp")) { return "DT"; }else if(columnType.equalsIgnoreCase("number")) { return "NB"; }else if(columnType.equalsIgnoreCase("nvarchar2")) { return "CH"; }else { throw new SQLException("Unknown columnType:'"+columnType+"'."); } } /** * delete all data in a table quickly * @param tableName * @param conn * @param stmt * @throws SQLException */ private void truncateTable(String tableName,Connection conn,Statement stmt) throws SQLException{ String sql="truncate table "+tableName; stmt.execute(sql); log.info("truncated table:"+tableName); } /** * Insert date to a table * @param tableIndex * @param tableName * @param count * @param innerArr * @param conn * @param stmt * @throws SQLException */ private void insertDataToTable(int tableIndex,String tableName,int count,List<TypeField> typefields,Connection conn,Statement stmt) throws SQLException{ List<String> fields=new ArrayList<String>(); List<String> values=new ArrayList<String>(); int index=0; for(TypeField tf:typefields) { fields.add(tf.field); values.add("''{"+index+"}''"); index++; } int interval=2*365*24*60*60/count;// 涓ゅ勾鐨勭�鏁伴櫎浠ユ�讳釜鏁板嵆涓洪棿闅� index=0; int times=count/BatchSize; for(int i=0;i<times;i++) { StringBuilder sb=new StringBuilder(); sb.append("INSERT ALL "); for(int j=0;j<BatchSize;j++) { index=i*BatchSize+j; sb.append(getInsertSql(tableName,typefields,index,interval)); } sb.append(" select * from dual"); String sql = sb.toString(); long startTime = System.currentTimeMillis(); stmt.executeUpdate(sql); long endTime = System.currentTimeMillis(); log.info("#"+tableIndex+"-"+i+" "+BatchSize+" records inserted to '"+tableName+"' used " + sec2DHMS(startTime,endTime)); } } /** * get insert sql * @param tableName * @param typefields * @param index * @return */ private String getInsertSql(String tableName,List<TypeField> typefields,int index,int interval) { String currTime=getDatetimeBefore(index,interval); StringBuilder sb=new StringBuilder(); sb.append(" INTO "+tableName+"("); List<String> fields=new ArrayList<String>(); for(TypeField tf:typefields) { fields.add(tf.field); } sb.append(String.join(",",fields)); sb.append(") values("); List<String> values=new ArrayList<String>(); for(TypeField tf:typefields) { if(tf.type.equals("PK")) { values.add("'"+String.valueOf(index)+"'"); }else if(tf.type.equals("CH")) { values.add("'0'"); }else if(tf.type.equals("NB")) { values.add("'0'"); }else if(tf.type.equals("DT")) { values.add("to_date('"+currTime+"','yyyy-MM-dd HH24:mi:ss')"); } } sb.append(String.join(",",values)); sb.append(")"); String insertSql=sb.toString(); return insertSql; } /** * get datetime n seconds before * @param n * @param interval * @return */ private static String getDatetimeBefore(int n,int interval) { try { Calendar now = Calendar.getInstance(); now.add(Calendar.SECOND,-n*interval);//鏃ユ湡鍑忓幓n*10绉� Date newDate=now.getTime(); SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); String retval = sdf.format(newDate); return retval; } catch(Exception ex) { ex.printStackTrace(); return null; } } /** * judge if all records are inserted * @param count * @param table * @param stmt * @return * @throws SQLException */ private boolean isAllInserted(int count,String table,Statement stmt) throws SQLException { String sql="SELECT COUNT (*) as cnt FROM "+table; ResultSet rs = stmt.executeQuery(sql); while (rs.next()) { int cnt = rs.getInt("cnt"); return cnt==count; } return false; } /** * change seconds to DayHourMinuteSecond format * @param stratMs * @param endMs * @return */ private static String sec2DHMS(long stratMs,long endMs) { String retval = null; long secondCount=(endMs-stratMs)/1000; long days = secondCount / (60 * 60 * 24); long hours = (secondCount % (60 * 60 * 24)) / (60 * 60); long minutes = (secondCount % (60 * 60)) / 60; long seconds = secondCount % 60; if (days > 0) { retval = days + "d" + hours + "h" + minutes + "m" + seconds + "s"; } else if (hours > 0) { retval = hours + "h" + minutes + "m" + seconds + "s"; } else if (minutes > 0) { retval = minutes + "m" + seconds + "s"; } else { retval = seconds + "s"; } return retval; } protected static final class TypeField{ String type; String field; } public static void main(String[] args) { TableAutoInserter ti=new TableAutoInserter(); String[] tablenames= { "TestTB01", "TestTB02", "TestTB03", "TestTB04", "TestTB05", "TestTB06", "TestTB07", "TestTB08", "TestTB09", "TestTB10", "TestTB11", "TestTB12", "TestTB13", "TestTB14", "TestTB15", "TestTB16", }; for(String table:tablenames) { ti.add(new TbCnt(table,10000)); } ti.insertAllTables(); } }
本例用到数据库连接参数：
/** * 数据库连接参数 * @author 逆火 * * 2019年11月16日 上午8:09:24 */ public final class DBParam { public final static String Driver = "oracle.jdbc.driver.OracleDriver"; public final static String DbUrl = "jdbc:oracle:thin:@127.0.0.1:1521:orcl"; public final static String User = "ufo"; public final static String Pswd = "1234"; }
控制台输出：
2019-11-23 15:36:02,198 INFO[main]-Begin to access jdbc:oracle:thin:@127.0.0.1:1521:orcl as ufo... 2019-11-23 15:36:02,470 INFO[main]-truncated table:TestTB01 2019-11-23 15:36:02,878 INFO[main]-#0-0 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:03,184 INFO[main]-#0-1 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:03,473 INFO[main]-#0-2 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:03,772 INFO[main]-#0-3 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:04,065 INFO[main]-#0-4 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:04,380 INFO[main]-#0-5 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:04,662 INFO[main]-#0-6 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:04,961 INFO[main]-#0-7 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:05,259 INFO[main]-#0-8 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:05,554 INFO[main]-#0-9 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:05,846 INFO[main]-#0-10 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:06,117 INFO[main]-#0-11 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:06,383 INFO[main]-#0-12 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:06,654 INFO[main]-#0-13 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:06,937 INFO[main]-#0-14 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:07,208 INFO[main]-#0-15 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:07,493 INFO[main]-#0-16 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:07,786 INFO[main]-#0-17 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:08,065 INFO[main]-#0-18 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:08,342 INFO[main]-#0-19 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:08,607 INFO[main]-#0-20 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:08,910 INFO[main]-#0-21 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:09,216 INFO[main]-#0-22 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:09,502 INFO[main]-#0-23 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:09,801 INFO[main]-#0-24 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:10,079 INFO[main]-#0-25 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:10,357 INFO[main]-#0-26 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:10,635 INFO[main]-#0-27 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:10,913 INFO[main]-#0-28 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:11,179 INFO[main]-#0-29 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:11,455 INFO[main]-#0-30 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:11,748 INFO[main]-#0-31 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:12,022 INFO[main]-#0-32 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:12,294 INFO[main]-#0-33 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:12,568 INFO[main]-#0-34 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:12,855 INFO[main]-#0-35 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:13,168 INFO[main]-#0-36 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:13,457 INFO[main]-#0-37 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:13,765 INFO[main]-#0-38 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:14,052 INFO[main]-#0-39 250 records inserted to 'TestTB01' used 0s 2019-11-23 15:36:14,053 INFO[main]-#0 10000 records were inserted to table:'TestTB01' used 11s 2019-11-23 15:36:14,121 INFO[main]-truncated table:TestTB02 2019-11-23 15:36:14,438 INFO[main]-#1-0 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:14,758 INFO[main]-#1-1 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:15,027 INFO[main]-#1-2 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:15,289 INFO[main]-#1-3 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:15,561 INFO[main]-#1-4 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:15,845 INFO[main]-#1-5 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:16,130 INFO[main]-#1-6 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:16,399 INFO[main]-#1-7 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:16,686 INFO[main]-#1-8 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:16,960 INFO[main]-#1-9 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:17,242 INFO[main]-#1-10 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:17,528 INFO[main]-#1-11 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:17,821 INFO[main]-#1-12 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:18,086 INFO[main]-#1-13 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:18,357 INFO[main]-#1-14 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:18,624 INFO[main]-#1-15 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:18,904 INFO[main]-#1-16 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:19,212 INFO[main]-#1-17 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:19,527 INFO[main]-#1-18 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:19,855 INFO[main]-#1-19 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:20,125 INFO[main]-#1-20 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:20,400 INFO[main]-#1-21 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:20,680 INFO[main]-#1-22 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:20,945 INFO[main]-#1-23 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:21,209 INFO[main]-#1-24 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:21,518 INFO[main]-#1-25 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:21,803 INFO[main]-#1-26 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:22,077 INFO[main]-#1-27 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:22,355 INFO[main]-#1-28 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:22,625 INFO[main]-#1-29 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:22,908 INFO[main]-#1-30 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:23,165 INFO[main]-#1-31 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:23,434 INFO[main]-#1-32 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:23,731 INFO[main]-#1-33 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:24,008 INFO[main]-#1-34 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:24,283 INFO[main]-#1-35 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:24,578 INFO[main]-#1-36 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:24,865 INFO[main]-#1-37 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:25,136 INFO[main]-#1-38 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:25,400 INFO[main]-#1-39 250 records inserted to 'TestTB02' used 0s 2019-11-23 15:36:25,402 INFO[main]-#1 10000 records were inserted to table:'TestTB02' used 11s 2019-11-23 15:36:25,448 INFO[main]-truncated table:TestTB03 2019-11-23 15:36:25,876 INFO[main]-#2-0 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:26,164 INFO[main]-#2-1 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:26,437 INFO[main]-#2-2 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:26,728 INFO[main]-#2-3 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:26,995 INFO[main]-#2-4 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:27,267 INFO[main]-#2-5 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:27,538 INFO[main]-#2-6 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:27,822 INFO[main]-#2-7 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:28,087 INFO[main]-#2-8 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:28,359 INFO[main]-#2-9 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:28,622 INFO[main]-#2-10 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:28,904 INFO[main]-#2-11 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:29,274 INFO[main]-#2-12 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:29,589 INFO[main]-#2-13 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:29,864 INFO[main]-#2-14 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:30,129 INFO[main]-#2-15 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:30,398 INFO[main]-#2-16 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:30,746 INFO[main]-#2-17 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:31,013 INFO[main]-#2-18 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:31,292 INFO[main]-#2-19 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:31,554 INFO[main]-#2-20 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:31,839 INFO[main]-#2-21 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:32,107 INFO[main]-#2-22 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:32,364 INFO[main]-#2-23 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:32,635 INFO[main]-#2-24 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:32,926 INFO[main]-#2-25 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:33,186 INFO[main]-#2-26 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:33,464 INFO[main]-#2-27 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:33,749 INFO[main]-#2-28 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:34,025 INFO[main]-#2-29 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:34,302 INFO[main]-#2-30 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:34,646 INFO[main]-#2-31 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:34,923 INFO[main]-#2-32 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:35,202 INFO[main]-#2-33 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:35,478 INFO[main]-#2-34 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:35,767 INFO[main]-#2-35 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:36,042 INFO[main]-#2-36 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:36,313 INFO[main]-#2-37 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:36,589 INFO[main]-#2-38 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:36,889 INFO[main]-#2-39 250 records inserted to 'TestTB03' used 0s 2019-11-23 15:36:36,891 INFO[main]-#2 10000 records were inserted to table:'TestTB03' used 11s 2019-11-23 15:36:36,941 INFO[main]-truncated table:TestTB04 2019-11-23 15:36:37,264 INFO[main]-#3-0 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:37,573 INFO[main]-#3-1 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:37,901 INFO[main]-#3-2 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:38,173 INFO[main]-#3-3 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:38,461 INFO[main]-#3-4 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:38,756 INFO[main]-#3-5 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:39,027 INFO[main]-#3-6 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:39,305 INFO[main]-#3-7 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:39,570 INFO[main]-#3-8 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:39,854 INFO[main]-#3-9 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:40,125 INFO[main]-#3-10 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:40,394 INFO[main]-#3-11 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:40,656 INFO[main]-#3-12 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:40,941 INFO[main]-#3-13 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:41,206 INFO[main]-#3-14 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:41,478 INFO[main]-#3-15 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:41,767 INFO[main]-#3-16 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:42,041 INFO[main]-#3-17 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:42,312 INFO[main]-#3-18 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:42,581 INFO[main]-#3-19 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:42,893 INFO[main]-#3-20 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:43,166 INFO[main]-#3-21 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:43,443 INFO[main]-#3-22 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:43,748 INFO[main]-#3-23 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:44,024 INFO[main]-#3-24 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:44,292 INFO[main]-#3-25 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:44,560 INFO[main]-#3-26 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:44,855 INFO[main]-#3-27 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:45,125 INFO[main]-#3-28 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:45,393 INFO[main]-#3-29 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:45,659 INFO[main]-#3-30 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:45,941 INFO[main]-#3-31 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:46,203 INFO[main]-#3-32 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:46,470 INFO[main]-#3-33 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:46,797 INFO[main]-#3-34 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:47,110 INFO[main]-#3-35 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:47,376 INFO[main]-#3-36 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:47,638 INFO[main]-#3-37 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:47,916 INFO[main]-#3-38 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:48,190 INFO[main]-#3-39 250 records inserted to 'TestTB04' used 0s 2019-11-23 15:36:48,192 INFO[main]-#3 10000 records were inserted to table:'TestTB04' used 11s 2019-11-23 15:36:48,289 INFO[main]-truncated table:TestTB05 2019-11-23 15:36:48,624 INFO[main]-#4-0 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:48,904 INFO[main]-#4-1 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:49,166 INFO[main]-#4-2 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:49,465 INFO[main]-#4-3 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:49,754 INFO[main]-#4-4 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:50,025 INFO[main]-#4-5 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:50,289 INFO[main]-#4-6 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:50,564 INFO[main]-#4-7 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:50,853 INFO[main]-#4-8 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:51,116 INFO[main]-#4-9 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:51,381 INFO[main]-#4-10 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:51,650 INFO[main]-#4-11 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:51,926 INFO[main]-#4-12 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:52,207 INFO[main]-#4-13 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:52,527 INFO[main]-#4-14 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:52,815 INFO[main]-#4-15 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:53,085 INFO[main]-#4-16 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:53,357 INFO[main]-#4-17 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:53,627 INFO[main]-#4-18 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:53,911 INFO[main]-#4-19 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:54,174 INFO[main]-#4-20 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:54,447 INFO[main]-#4-21 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:54,751 INFO[main]-#4-22 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:55,011 INFO[main]-#4-23 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:55,275 INFO[main]-#4-24 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:55,541 INFO[main]-#4-25 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:55,837 INFO[main]-#4-26 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:56,105 INFO[main]-#4-27 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:56,375 INFO[main]-#4-28 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:56,652 INFO[main]-#4-29 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:56,925 INFO[main]-#4-30 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:57,196 INFO[main]-#4-31 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:57,469 INFO[main]-#4-32 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:57,809 INFO[main]-#4-33 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:58,119 INFO[main]-#4-34 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:58,398 INFO[main]-#4-35 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:58,718 INFO[main]-#4-36 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:58,986 INFO[main]-#4-37 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:59,255 INFO[main]-#4-38 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:59,525 INFO[main]-#4-39 250 records inserted to 'TestTB05' used 0s 2019-11-23 15:36:59,526 INFO[main]-#4 10000 records were inserted to table:'TestTB05' used 11s 2019-11-23 15:36:59,593 INFO[main]-truncated table:TestTB06 2019-11-23 15:36:59,952 INFO[main]-#5-0 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:00,259 INFO[main]-#5-1 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:00,529 INFO[main]-#5-2 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:00,829 INFO[main]-#5-3 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:01,096 INFO[main]-#5-4 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:01,359 INFO[main]-#5-5 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:01,632 INFO[main]-#5-6 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:01,912 INFO[main]-#5-7 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:02,174 INFO[main]-#5-8 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:02,449 INFO[main]-#5-9 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:02,750 INFO[main]-#5-10 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:03,026 INFO[main]-#5-11 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:03,295 INFO[main]-#5-12 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:03,558 INFO[main]-#5-13 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:03,853 INFO[main]-#5-14 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:04,124 INFO[main]-#5-15 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:04,390 INFO[main]-#5-16 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:04,749 INFO[main]-#5-17 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:05,066 INFO[main]-#5-18 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:05,327 INFO[main]-#5-19 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:05,596 INFO[main]-#5-20 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:05,880 INFO[main]-#5-21 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:06,152 INFO[main]-#5-22 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:06,420 INFO[main]-#5-23 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:06,721 INFO[main]-#5-24 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:06,991 INFO[main]-#5-25 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:07,264 INFO[main]-#5-26 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:07,533 INFO[main]-#5-27 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:07,816 INFO[main]-#5-28 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:08,086 INFO[main]-#5-29 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:08,349 INFO[main]-#5-30 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:08,625 INFO[main]-#5-31 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:08,901 INFO[main]-#5-32 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:09,168 INFO[main]-#5-33 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:09,434 INFO[main]-#5-34 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:09,742 INFO[main]-#5-35 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:10,021 INFO[main]-#5-36 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:10,282 INFO[main]-#5-37 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:10,548 INFO[main]-#5-38 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:10,828 INFO[main]-#5-39 250 records inserted to 'TestTB06' used 0s 2019-11-23 15:37:10,830 INFO[main]-#5 10000 records were inserted to table:'TestTB06' used 11s 2019-11-23 15:37:10,869 INFO[main]-truncated table:TestTB07 2019-11-23 15:37:11,165 INFO[main]-#6-0 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:11,447 INFO[main]-#6-1 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:11,745 INFO[main]-#6-2 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:12,073 INFO[main]-#6-3 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:12,350 INFO[main]-#6-4 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:12,622 INFO[main]-#6-5 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:12,900 INFO[main]-#6-6 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:13,166 INFO[main]-#6-7 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:13,432 INFO[main]-#6-8 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:13,725 INFO[main]-#6-9 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:13,997 INFO[main]-#6-10 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:14,260 INFO[main]-#6-11 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:14,530 INFO[main]-#6-12 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:14,817 INFO[main]-#6-13 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:15,082 INFO[main]-#6-14 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:15,351 INFO[main]-#6-15 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:15,620 INFO[main]-#6-16 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:15,892 INFO[main]-#6-17 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:16,151 INFO[main]-#6-18 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:16,423 INFO[main]-#6-19 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:16,731 INFO[main]-#6-20 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:17,006 INFO[main]-#6-21 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:17,282 INFO[main]-#6-22 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:17,546 INFO[main]-#6-23 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:17,829 INFO[main]-#6-24 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:18,094 INFO[main]-#6-25 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:18,360 INFO[main]-#6-26 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:18,637 INFO[main]-#6-27 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:18,921 INFO[main]-#6-28 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:19,220 INFO[main]-#6-29 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:19,485 INFO[main]-#6-30 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:19,771 INFO[main]-#6-31 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:20,040 INFO[main]-#6-32 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:20,300 INFO[main]-#6-33 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:20,567 INFO[main]-#6-34 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:20,861 INFO[main]-#6-35 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:21,133 INFO[main]-#6-36 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:21,420 INFO[main]-#6-37 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:21,725 INFO[main]-#6-38 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:22,010 INFO[main]-#6-39 250 records inserted to 'TestTB07' used 0s 2019-11-23 15:37:22,012 INFO[main]-#6 10000 records were inserted to table:'TestTB07' used 11s 2019-11-23 15:37:22,051 INFO[main]-truncated table:TestTB08 2019-11-23 15:37:22,322 INFO[main]-#7-0 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:22,626 INFO[main]-#7-1 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:22,920 INFO[main]-#7-2 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:23,199 INFO[main]-#7-3 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:23,520 INFO[main]-#7-4 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:23,813 INFO[main]-#7-5 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:24,078 INFO[main]-#7-6 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:24,378 INFO[main]-#7-7 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:24,737 INFO[main]-#7-8 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:25,020 INFO[main]-#7-9 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:25,332 INFO[main]-#7-10 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:25,671 INFO[main]-#7-11 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:25,940 INFO[main]-#7-12 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:26,211 INFO[main]-#7-13 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:26,469 INFO[main]-#7-14 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:26,811 INFO[main]-#7-15 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:27,122 INFO[main]-#7-16 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:27,390 INFO[main]-#7-17 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:27,654 INFO[main]-#7-18 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:27,930 INFO[main]-#7-19 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:28,193 INFO[main]-#7-20 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:28,463 INFO[main]-#7-21 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:28,761 INFO[main]-#7-22 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:29,034 INFO[main]-#7-23 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:29,319 INFO[main]-#7-24 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:29,577 INFO[main]-#7-25 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:29,861 INFO[main]-#7-26 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:30,134 INFO[main]-#7-27 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:30,397 INFO[main]-#7-28 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:30,666 INFO[main]-#7-29 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:30,996 INFO[main]-#7-30 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:31,265 INFO[main]-#7-31 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:31,529 INFO[main]-#7-32 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:31,823 INFO[main]-#7-33 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:32,083 INFO[main]-#7-34 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:32,357 INFO[main]-#7-35 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:32,631 INFO[main]-#7-36 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:32,897 INFO[main]-#7-37 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:33,163 INFO[main]-#7-38 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:33,436 INFO[main]-#7-39 250 records inserted to 'TestTB08' used 0s 2019-11-23 15:37:33,438 INFO[main]-#7 10000 records were inserted to table:'TestTB08' used 11s 2019-11-23 15:37:33,497 INFO[main]-truncated table:TestTB09 2019-11-23 15:37:33,821 INFO[main]-#8-0 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:34,103 INFO[main]-#8-1 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:34,375 INFO[main]-#8-2 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:34,643 INFO[main]-#8-3 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:34,932 INFO[main]-#8-4 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:35,201 INFO[main]-#8-5 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:35,507 INFO[main]-#8-6 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:35,793 INFO[main]-#8-7 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:36,062 INFO[main]-#8-8 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:36,353 INFO[main]-#8-9 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:36,652 INFO[main]-#8-10 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:36,932 INFO[main]-#8-11 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:37,216 INFO[main]-#8-12 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:37,478 INFO[main]-#8-13 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:37,774 INFO[main]-#8-14 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:38,082 INFO[main]-#8-15 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:38,432 INFO[main]-#8-16 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:38,771 INFO[main]-#8-17 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:39,065 INFO[main]-#8-18 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:39,343 INFO[main]-#8-19 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:39,623 INFO[main]-#8-20 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:39,908 INFO[main]-#8-21 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:40,287 INFO[main]-#8-22 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:40,602 INFO[main]-#8-23 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:40,943 INFO[main]-#8-24 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:41,293 INFO[main]-#8-25 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:41,571 INFO[main]-#8-26 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:41,912 INFO[main]-#8-27 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:42,259 INFO[main]-#8-28 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:42,602 INFO[main]-#8-29 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:42,900 INFO[main]-#8-30 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:43,172 INFO[main]-#8-31 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:43,439 INFO[main]-#8-32 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:43,722 INFO[main]-#8-33 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:44,011 INFO[main]-#8-34 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:44,287 INFO[main]-#8-35 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:44,558 INFO[main]-#8-36 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:44,850 INFO[main]-#8-37 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:45,119 INFO[main]-#8-38 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:45,388 INFO[main]-#8-39 250 records inserted to 'TestTB09' used 0s 2019-11-23 15:37:45,390 INFO[main]-#8 10000 records were inserted to table:'TestTB09' used 11s 2019-11-23 15:37:45,469 INFO[main]-truncated table:TestTB10 2019-11-23 15:37:45,774 INFO[main]-#9-0 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:46,049 INFO[main]-#9-1 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:46,343 INFO[main]-#9-2 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:46,620 INFO[main]-#9-3 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:46,909 INFO[main]-#9-4 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:47,190 INFO[main]-#9-5 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:47,456 INFO[main]-#9-6 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:47,773 INFO[main]-#9-7 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:48,052 INFO[main]-#9-8 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:48,323 INFO[main]-#9-9 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:48,594 INFO[main]-#9-10 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:48,877 INFO[main]-#9-11 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:49,151 INFO[main]-#9-12 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:49,435 INFO[main]-#9-13 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:49,745 INFO[main]-#9-14 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:50,015 INFO[main]-#9-15 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:50,287 INFO[main]-#9-16 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:50,569 INFO[main]-#9-17 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:50,923 INFO[main]-#9-18 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:51,200 INFO[main]-#9-19 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:51,477 INFO[main]-#9-20 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:51,764 INFO[main]-#9-21 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:52,031 INFO[main]-#9-22 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:52,298 INFO[main]-#9-23 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:52,576 INFO[main]-#9-24 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:52,859 INFO[main]-#9-25 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:53,141 INFO[main]-#9-26 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:53,484 INFO[main]-#9-27 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:53,790 INFO[main]-#9-28 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:54,072 INFO[main]-#9-29 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:54,394 INFO[main]-#9-30 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:54,721 INFO[main]-#9-31 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:54,998 INFO[main]-#9-32 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:55,267 INFO[main]-#9-33 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:55,535 INFO[main]-#9-34 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:55,818 INFO[main]-#9-35 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:56,097 INFO[main]-#9-36 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:56,377 INFO[main]-#9-37 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:56,641 INFO[main]-#9-38 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:56,916 INFO[main]-#9-39 250 records inserted to 'TestTB10' used 0s 2019-11-23 15:37:56,918 INFO[main]-#9 10000 records were inserted to table:'TestTB10' used 11s 2019-11-23 15:37:56,999 INFO[main]-truncated table:TestTB11 2019-11-23 15:37:57,305 INFO[main]-#10-0 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:37:57,566 INFO[main]-#10-1 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:37:57,850 INFO[main]-#10-2 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:37:58,166 INFO[main]-#10-3 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:37:58,433 INFO[main]-#10-4 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:37:58,717 INFO[main]-#10-5 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:37:58,988 INFO[main]-#10-6 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:37:59,265 INFO[main]-#10-7 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:37:59,532 INFO[main]-#10-8 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:37:59,818 INFO[main]-#10-9 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:00,093 INFO[main]-#10-10 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:00,355 INFO[main]-#10-11 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:00,623 INFO[main]-#10-12 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:00,904 INFO[main]-#10-13 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:01,161 INFO[main]-#10-14 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:01,433 INFO[main]-#10-15 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:01,731 INFO[main]-#10-16 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:01,988 INFO[main]-#10-17 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:02,254 INFO[main]-#10-18 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:02,510 INFO[main]-#10-19 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:02,797 INFO[main]-#10-20 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:03,070 INFO[main]-#10-21 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:03,354 INFO[main]-#10-22 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:03,664 INFO[main]-#10-23 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:03,945 INFO[main]-#10-24 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:04,220 INFO[main]-#10-25 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:04,507 INFO[main]-#10-26 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:04,838 INFO[main]-#10-27 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:05,103 INFO[main]-#10-28 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:05,402 INFO[main]-#10-29 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:05,759 INFO[main]-#10-30 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:06,037 INFO[main]-#10-31 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:06,297 INFO[main]-#10-32 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:06,561 INFO[main]-#10-33 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:06,841 INFO[main]-#10-34 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:07,162 INFO[main]-#10-35 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:07,462 INFO[main]-#10-36 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:07,761 INFO[main]-#10-37 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:08,026 INFO[main]-#10-38 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:08,289 INFO[main]-#10-39 250 records inserted to 'TestTB11' used 0s 2019-11-23 15:38:08,291 INFO[main]-#10 10000 records were inserted to table:'TestTB11' used 11s 2019-11-23 15:38:08,359 INFO[main]-truncated table:TestTB12 2019-11-23 15:38:08,653 INFO[main]-#11-0 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:08,934 INFO[main]-#11-1 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:09,239 INFO[main]-#11-2 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:09,516 INFO[main]-#11-3 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:09,819 INFO[main]-#11-4 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:10,118 INFO[main]-#11-5 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:10,444 INFO[main]-#11-6 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:10,763 INFO[main]-#11-7 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:11,023 INFO[main]-#11-8 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:11,300 INFO[main]-#11-9 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:11,572 INFO[main]-#11-10 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:11,849 INFO[main]-#11-11 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:12,118 INFO[main]-#11-12 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:12,386 INFO[main]-#11-13 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:12,656 INFO[main]-#11-14 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:12,946 INFO[main]-#11-15 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:13,220 INFO[main]-#11-16 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:13,491 INFO[main]-#11-17 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:13,775 INFO[main]-#11-18 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:14,151 INFO[main]-#11-19 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:14,449 INFO[main]-#11-20 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:14,740 INFO[main]-#11-21 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:15,021 INFO[main]-#11-22 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:15,290 INFO[main]-#11-23 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:15,562 INFO[main]-#11-24 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:15,849 INFO[main]-#11-25 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:16,117 INFO[main]-#11-26 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:16,385 INFO[main]-#11-27 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:16,648 INFO[main]-#11-28 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:16,918 INFO[main]-#11-29 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:17,191 INFO[main]-#11-30 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:17,455 INFO[main]-#11-31 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:17,755 INFO[main]-#11-32 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:18,024 INFO[main]-#11-33 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:18,295 INFO[main]-#11-34 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:18,563 INFO[main]-#11-35 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:18,856 INFO[main]-#11-36 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:19,125 INFO[main]-#11-37 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:19,402 INFO[main]-#11-38 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:19,708 INFO[main]-#11-39 250 records inserted to 'TestTB12' used 0s 2019-11-23 15:38:19,709 INFO[main]-#11 10000 records were inserted to table:'TestTB12' used 11s 2019-11-23 15:38:19,917 INFO[main]-truncated table:TestTB13 2019-11-23 15:38:20,228 INFO[main]-#12-0 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:20,489 INFO[main]-#12-1 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:20,783 INFO[main]-#12-2 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:21,042 INFO[main]-#12-3 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:21,354 INFO[main]-#12-4 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:21,657 INFO[main]-#12-5 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:21,932 INFO[main]-#12-6 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:22,204 INFO[main]-#12-7 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:22,476 INFO[main]-#12-8 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:22,772 INFO[main]-#12-9 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:23,037 INFO[main]-#12-10 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:23,311 INFO[main]-#12-11 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:23,600 INFO[main]-#12-12 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:23,883 INFO[main]-#12-13 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:24,156 INFO[main]-#12-14 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:24,425 INFO[main]-#12-15 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:24,720 INFO[main]-#12-16 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:24,985 INFO[main]-#12-17 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:25,258 INFO[main]-#12-18 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:25,571 INFO[main]-#12-19 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:25,852 INFO[main]-#12-20 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:26,122 INFO[main]-#12-21 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:26,512 INFO[main]-#12-22 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:26,878 INFO[main]-#12-23 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:27,142 INFO[main]-#12-24 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:27,413 INFO[main]-#12-25 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:27,742 INFO[main]-#12-26 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:28,131 INFO[main]-#12-27 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:28,402 INFO[main]-#12-28 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:28,712 INFO[main]-#12-29 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:28,978 INFO[main]-#12-30 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:29,252 INFO[main]-#12-31 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:29,522 INFO[main]-#12-32 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:29,806 INFO[main]-#12-33 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:30,070 INFO[main]-#12-34 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:30,339 INFO[main]-#12-35 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:30,608 INFO[main]-#12-36 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:30,886 INFO[main]-#12-37 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:31,196 INFO[main]-#12-38 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:31,480 INFO[main]-#12-39 250 records inserted to 'TestTB13' used 0s 2019-11-23 15:38:31,481 INFO[main]-#12 10000 records were inserted to table:'TestTB13' used 11s 2019-11-23 15:38:31,515 INFO[main]-truncated table:TestTB14 2019-11-23 15:38:31,820 INFO[main]-#13-0 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:32,084 INFO[main]-#13-1 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:32,357 INFO[main]-#13-2 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:32,633 INFO[main]-#13-3 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:32,920 INFO[main]-#13-4 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:33,200 INFO[main]-#13-5 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:33,465 INFO[main]-#13-6 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:33,755 INFO[main]-#13-7 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:34,031 INFO[main]-#13-8 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:34,305 INFO[main]-#13-9 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:34,569 INFO[main]-#13-10 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:34,852 INFO[main]-#13-11 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:35,122 INFO[main]-#13-12 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:35,385 INFO[main]-#13-13 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:35,649 INFO[main]-#13-14 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:35,923 INFO[main]-#13-15 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:36,189 INFO[main]-#13-16 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:36,451 INFO[main]-#13-17 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:36,755 INFO[main]-#13-18 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:37,019 INFO[main]-#13-19 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:37,278 INFO[main]-#13-20 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:37,540 INFO[main]-#13-21 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:37,826 INFO[main]-#13-22 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:38,097 INFO[main]-#13-23 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:38,371 INFO[main]-#13-24 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:38,638 INFO[main]-#13-25 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:38,905 INFO[main]-#13-26 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:39,209 INFO[main]-#13-27 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:39,475 INFO[main]-#13-28 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:39,775 INFO[main]-#13-29 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:40,049 INFO[main]-#13-30 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:40,327 INFO[main]-#13-31 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:40,609 INFO[main]-#13-32 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:40,926 INFO[main]-#13-33 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:41,203 INFO[main]-#13-34 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:41,477 INFO[main]-#13-35 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:41,805 INFO[main]-#13-36 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:42,136 INFO[main]-#13-37 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:42,413 INFO[main]-#13-38 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:42,769 INFO[main]-#13-39 250 records inserted to 'TestTB14' used 0s 2019-11-23 15:38:42,770 INFO[main]-#13 10000 records were inserted to table:'TestTB14' used 11s 2019-11-23 15:38:42,853 INFO[main]-truncated table:TestTB15 2019-11-23 15:38:43,218 INFO[main]-#14-0 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:43,535 INFO[main]-#14-1 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:43,861 INFO[main]-#14-2 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:44,158 INFO[main]-#14-3 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:44,438 INFO[main]-#14-4 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:44,738 INFO[main]-#14-5 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:45,042 INFO[main]-#14-6 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:45,328 INFO[main]-#14-7 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:45,602 INFO[main]-#14-8 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:45,945 INFO[main]-#14-9 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:46,255 INFO[main]-#14-10 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:46,766 INFO[main]-#14-11 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:47,075 INFO[main]-#14-12 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:47,352 INFO[main]-#14-13 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:47,627 INFO[main]-#14-14 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:47,907 INFO[main]-#14-15 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:48,187 INFO[main]-#14-16 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:48,461 INFO[main]-#14-17 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:48,778 INFO[main]-#14-18 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:49,345 INFO[main]-#14-19 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:49,739 INFO[main]-#14-20 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:50,014 INFO[main]-#14-21 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:50,276 INFO[main]-#14-22 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:50,548 INFO[main]-#14-23 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:50,831 INFO[main]-#14-24 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:51,110 INFO[main]-#14-25 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:51,379 INFO[main]-#14-26 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:51,648 INFO[main]-#14-27 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:51,922 INFO[main]-#14-28 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:52,187 INFO[main]-#14-29 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:52,455 INFO[main]-#14-30 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:52,757 INFO[main]-#14-31 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:53,036 INFO[main]-#14-32 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:53,298 INFO[main]-#14-33 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:53,562 INFO[main]-#14-34 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:53,845 INFO[main]-#14-35 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:54,106 INFO[main]-#14-36 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:54,377 INFO[main]-#14-37 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:54,641 INFO[main]-#14-38 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:54,925 INFO[main]-#14-39 250 records inserted to 'TestTB15' used 0s 2019-11-23 15:38:54,927 INFO[main]-#14 10000 records were inserted to table:'TestTB15' used 12s 2019-11-23 15:38:54,989 INFO[main]-truncated table:TestTB16 2019-11-23 15:38:55,278 INFO[main]-#15-0 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:38:55,536 INFO[main]-#15-1 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:38:55,831 INFO[main]-#15-2 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:38:56,094 INFO[main]-#15-3 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:38:56,435 INFO[main]-#15-4 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:38:56,750 INFO[main]-#15-5 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:38:57,040 INFO[main]-#15-6 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:38:57,375 INFO[main]-#15-7 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:38:57,677 INFO[main]-#15-8 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:38:57,939 INFO[main]-#15-9 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:38:58,209 INFO[main]-#15-10 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:38:58,483 INFO[main]-#15-11 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:38:58,788 INFO[main]-#15-12 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:38:59,076 INFO[main]-#15-13 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:38:59,458 INFO[main]-#15-14 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:38:59,815 INFO[main]-#15-15 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:39:00,102 INFO[main]-#15-16 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:39:00,382 INFO[main]-#15-17 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:39:00,643 INFO[main]-#15-18 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:39:00,918 INFO[main]-#15-19 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:39:01,181 INFO[main]-#15-20 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:39:01,442 INFO[main]-#15-21 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:39:01,743 INFO[main]-#15-22 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:39:02,005 INFO[main]-#15-23 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:39:02,273 INFO[main]-#15-24 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:39:02,560 INFO[main]-#15-25 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:39:02,858 INFO[main]-#15-26 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:39:03,152 INFO[main]-#15-27 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:39:03,429 INFO[main]-#15-28 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:39:03,721 INFO[main]-#15-29 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:39:04,010 INFO[main]-#15-30 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:39:04,313 INFO[main]-#15-31 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:39:04,596 INFO[main]-#15-32 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:39:04,889 INFO[main]-#15-33 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:39:05,159 INFO[main]-#15-34 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:39:05,419 INFO[main]-#15-35 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:39:05,706 INFO[main]-#15-36 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:39:06,001 INFO[main]-#15-37 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:39:06,288 INFO[main]-#15-38 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:39:06,585 INFO[main]-#15-39 250 records inserted to 'TestTB16' used 0s 2019-11-23 15:39:06,587 INFO[main]-#15 10000 records were inserted to table:'TestTB16' used 11s
程序下载地址：https://files.cnblogs.com/files/xiandedanteng/OracleAccessComparison20191123-1.rar
好了，今天又以程序自娱自乐了一把，如果它对你有所帮助，那就是再好不过的事情了。
--END-- 2019年11月23日15:45:02