Table of Contents

Search

  1. Introduction
  2. Samples and Examples
  3. Tools and Utilities
  4. SDK Resources

Sample Database Performance Test Result

Sample Database Performance Test Result

You run the database testing utility on 60 million records. The DML operations of the utility runs on 10 parallel java threads.
The following sample shows the summary of the DML operations when the database testing utility is run on 60 million records:
07-15-2015 06:56:46:895 : ************************** Summary ************************** 07-15-2015 06:56:46:896 : All DML operations ran in multiple threads with thread count = 10 07-15-2015 06:56:46:897 : All the timings are in hour:min:second:millisecond 07-15-2015 06:56:46:897 : Total distinct database interactions: 9 07-15-2015 06:56:46:898 : 0- operation type: CREATE, count:1 07-15-2015 06:56:46:899 : 1- operation type: INSERT, count:60000001 07-15-2015 06:56:46:901 : 2- operation type: UPDATE, count:200000 07-15-2015 06:56:46:903 : 3- operation type: UPDATE_INDEX, count:200000 07-15-2015 06:56:46:906 : 4- operation type: SELECT, count:200000 07-15-2015 06:56:46:908 : 5- operation type: DELETE, count:200000 07-15-2015 06:56:46:910 : 6- operation type: CTAS, count:1 07-15-2015 06:56:46:912 : 7- operation type: DROP, count:1 07-15-2015 06:56:46:915 : 8- operation type: DROP, count:1 07-15-2015 06:56:46:932 : Total time for the test: 7:31:45:791.0 07-15-2015 06:56:46:933 : Number of operations: 60800005 07-15-2015 06:56:46:937 : Average time for all operations: 0:0:0:0.4458188942583146 07-15-2015 06:56:46:939 : Average transactions/second for all operations: 2243 07-15-2015 06:56:46:941 : 07-15-2015 06:56:46:944 : Number of create operations: 1 07-15-2015 06:56:46:946 : Total time for create operations: 0:0:0:307.0 07-15-2015 06:56:46:948 : Average time for all create operations: 0:0:0:307.0 07-15-2015 06:56:46:951 : Average transactions/second for all create operations: 3 07-15-2015 06:56:46:953 : 07-15-2015 06:56:46:955 : Number of create table as select operations: 1 07-15-2015 06:56:46:958 : Total time for create table as select operations: 0:31:29:121.0 07-15-2015 06:56:46:960 : Average time for all create table as select operations: 0:31:29:121.0 07-15-2015 06:56:46:962 : Average transactions/second for all create table as select operations: 0 07-15-2015 06:56:46:964 : 07-15-2015 06:56:46:966 : Number of drop operations: 2 07-15-2015 06:56:46:968 : Total time for drop operations: 0:0:1:71.0 07-15-2015 06:56:46:971 : Average time for all drop operations: 0:0:0:535.5 07-15-2015 06:56:46:973 : Average transactions/second for all drop operations: 1 07-15-2015 06:56:46:975 : 07-15-2015 06:56:46:977 : Number of insert operations: 60000001 07-15-2015 06:56:46:980 : Total time for insert operations: 6:51:31:743.0 07-15-2015 06:56:46:984 : Average time for all insert operations: 0:0:0:0.4115290431411826 07-15-2015 06:56:46:986 : Average transactions/second for all insert operations: 2429 07-15-2015 06:56:46:988 : Total bytes of data inserted: 1158196632 07-15-2015 06:56:46:991 : Average bytes of data inserted/second (bytes/second): 46906 07-15-2015 06:56:46:993 : 07-15-2015 06:56:46:995 : Number of update operations in non-indexed table: 200000 07-15-2015 06:56:46:997 : Total time for update operations in non-indexed table: 0:1:41:826.0 07-15-2015 06:56:47:000 : Average time for all update operations in non-indexed table: 0:0:0:0.50913 07-15-2015 06:56:47:002 : Average transactions/second for all update operations in non-indexed table: 1964 07-15-2015 06:56:47:004 : 07-15-2015 06:56:47:006 : Number of update operations in indexed table: 200000 07-15-2015 06:56:47:009 : Total time for update operations in indexed table: 0:2:25:359.0 07-15-2015 06:56:47:011 : Average time for all update operations in indexed table: 0:0:0:0.726795 07-15-2015 06:56:47:013 : Average transactions/second for all update operations in indexed table: 1375 07-15-2015 06:56:47:017 : 07-15-2015 06:56:47:019 : Number of select operations: 200000 07-15-2015 06:56:47:022 : Total time for select operations: 0:1:19:136.0 07-15-2015 06:56:47:024 : Average time for all select operations: 0:0:0:0.39568 07-15-2015 06:56:47:025 : Average transactions/second for all select operations: 2527 07-15-2015 06:56:47:028 : 07-15-2015 06:56:47:031 : Number of delete operations: 200000 07-15-2015 06:56:47:033 : Total time for delete operations: 0:3:17:228.0 07-15-2015 06:56:47:035 : Average time for all delete operations: 0:0:0:0.98614 07-15-2015 06:56:47:038 : Average transactions/second for all delete operations: 1014 07-15-2015 06:56:47:040 : *************************************************************

0 COMMENTS

We’d like to hear from you!