IT. Expert System.

public class NewDatabasePerformanceTests
extends Object

• Nested Class Summary

  Nested Classes

  Modifier and Type	Class and Description
  static class	NewDatabasePerformanceTests.Delete1000 1000 Deletes
  static class	NewDatabasePerformanceTests.DeleteIndexed1000 1000 Deletes on an indexed table
  static class	NewDatabasePerformanceTests.DeleteIndexWhere1000 1000 DELETE's with an index with where clause
  static class	NewDatabasePerformanceTests.DeleteWhere1000 1000 DELETE's without an index with where clause
  static class	NewDatabasePerformanceTests.InnerJoin100 INNER JOIN without an index
  static class	NewDatabasePerformanceTests.InnerJoinNoIndex100 INNER JOIN without an index on one side
  static class	NewDatabasePerformanceTests.InnerJoinOneSide100 INNER JOIN without an index on one side
  static class	NewDatabasePerformanceTests.Insert1000 Test 1000 inserts.
  static class	NewDatabasePerformanceTests.InsertIndexed1000 Test 1000 inserts into an indexed table.
  static class	NewDatabasePerformanceTests.InsertInteger10000 10000 inserts for an integer
  static class	NewDatabasePerformanceTests.InsertIntegerIndex10000 10000 inserts for an integer -indexed table
  static class	NewDatabasePerformanceTests.InsertString10000 10000 inserts for a String
  static class	NewDatabasePerformanceTests.InsertStringIndexed10000 10000 inserts for a String - indexed table
  static class	NewDatabasePerformanceTests.PerformanceBase
  static class	NewDatabasePerformanceTests.Select100 100 SELECTs without an index
  static class	NewDatabasePerformanceTests.SelectIndex100 100 SELECTs with an index
  static class	NewDatabasePerformanceTests.SelectIndexString100 100 SELECTs on String with index
  static class	NewDatabasePerformanceTests.SelectIndexStringComparison100 100 SELECTs on string comparison with Index
  static class	NewDatabasePerformanceTests.SelectInteger100 100 SELECTs on integer
  static class	NewDatabasePerformanceTests.SelectInteger10000 10000 selects for an integer -
  static class	NewDatabasePerformanceTests.SelectIntegerIndex100 100 SELECTs on integer with index
  static class	NewDatabasePerformanceTests.SelectIntegerIndexed10000 10000 selects for an integer -indexed table
  static class	NewDatabasePerformanceTests.SelectString100 100 SELECTs on String
  static class	NewDatabasePerformanceTests.SelectStringComparison100 100 SELECTs on a string comparison
  static class	NewDatabasePerformanceTests.SelectStringContains10000 10000 selects for a String - contains 'e'
  static class	NewDatabasePerformanceTests.SelectStringIndexedContains10000 10000 selects for a String - contains 'e'-indexed table
  static class	NewDatabasePerformanceTests.SelectStringIndexedStartsWith10000 10000 selects for a String - indexed table -starts with
  static class	NewDatabasePerformanceTests.SelectStringStartsWith100 100 SELECTs on String with starts with
  static class	NewDatabasePerformanceTests.SelectStringStartsWith10000 10000 selects for a String -starts with
  static class	NewDatabasePerformanceTests.SelectSubQIndex100 100 SELECTs with subqueries.
  static class	NewDatabasePerformanceTests.UpdateIndexWhere1000 1000 update's with an index with where clause
  static class	NewDatabasePerformanceTests.UpdateWhere1000 1000 update's without an index with where clause

• Field Summary

  Fields

  Modifier and Type	Field and Description
  static String[]	ONES
  static String[]	TENS

• Constructor Summary

  Constructors

  Constructor and Description
  NewDatabasePerformanceTests()

• Method Summary

  • Methods inherited from class java.lang.Object

    clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

• Field Detail

  • ONES

    public static final String[] ONES

  • TENS

    public static final String[] TENS

• Constructor Detail

  • NewDatabasePerformanceTests

    public NewDatabasePerformanceTests()