use of org.jumpmind.db.platform.informix.InformixDatabasePlatform in project symmetric-ds by JumpMind.
the class DatabaseWriterTest method testBenchmark.
@Test
public void testBenchmark() throws Exception {
Table table = buildSourceTable(TEST_TABLE, TEST_KEYS, TEST_COLUMNS);
int startId = Integer.parseInt(getId()) + 1;
List<CsvData> datas = new ArrayList<CsvData>();
for (int i = 0; i < 1600; i++) {
String[] values = { getNextId(), UUID.randomUUID().toString(), UUID.randomUUID().toString(), UUID.randomUUID().toString(), UUID.randomUUID().toString(), "2007-01-02 03:20:10.0", "2007-02-03 04:05:06.0", "0", "47", "67.89", "-0.0747663" };
datas.add(new CsvData(DataEventType.INSERT, values));
}
for (int i = startId; i < 1600 + startId; i++) {
String[] values = { Integer.toString(i) };
datas.add(new CsvData(DataEventType.DELETE, values, null));
}
long startTime = System.currentTimeMillis();
long statementCount = writeData(new TableCsvData(table, datas));
double totalSeconds = (System.currentTimeMillis() - startTime) / 1000.0;
double targetTime = 15.0;
if (platform instanceof InformixDatabasePlatform) {
targetTime = 20.0;
}
Assert.assertEquals(3200, statementCount);
// TODO: this used to run in 1 second; can we do some optimization?
Assert.assertTrue("DataLoader running in " + totalSeconds + " is too slow", totalSeconds <= targetTime);
}
use of org.jumpmind.db.platform.informix.InformixDatabasePlatform in project symmetric-ds by JumpMind.
the class JdbcSymmetricDialectFactory method create.
public ISymmetricDialect create() {
AbstractSymmetricDialect dialect = null;
if (platform instanceof MariaDBDatabasePlatform) {
dialect = new MariaDBSymmetricDialect(parameterService, platform);
} else if (platform instanceof MySqlDatabasePlatform) {
dialect = new MySqlSymmetricDialect(parameterService, platform);
} else if (platform instanceof OracleDatabasePlatform) {
dialect = new OracleSymmetricDialect(parameterService, platform);
} else if (platform instanceof MsSql2008DatabasePlatform) {
dialect = new MsSqlSymmetricDialect(parameterService, platform);
} else if (platform instanceof MsSql2005DatabasePlatform) {
dialect = new MsSqlSymmetricDialect(parameterService, platform);
} else if (platform instanceof MsSql2000DatabasePlatform) {
dialect = new MsSql2000SymmetricDialect(parameterService, platform);
} else if (platform instanceof GreenplumPlatform) {
dialect = new GreenplumSymmetricDialect(parameterService, platform);
} else if (platform instanceof RedshiftDatabasePlatform) {
dialect = new RedshiftSymmetricDialect(parameterService, platform);
} else if (platform instanceof PostgreSqlDatabasePlatform) {
dialect = new PostgreSqlSymmetricDialect(parameterService, platform);
} else if (platform instanceof DerbyDatabasePlatform) {
dialect = new DerbySymmetricDialect(parameterService, platform);
} else if (platform instanceof H2DatabasePlatform) {
dialect = new H2SymmetricDialect(parameterService, platform);
} else if (platform instanceof HsqlDbDatabasePlatform) {
dialect = new HsqlDbSymmetricDialect(parameterService, platform);
} else if (platform instanceof HsqlDb2DatabasePlatform) {
dialect = new HsqlDb2SymmetricDialect(parameterService, platform);
} else if (platform instanceof InformixDatabasePlatform) {
dialect = new InformixSymmetricDialect(parameterService, platform);
} else if (platform instanceof Db2zOsDatabasePlatform) {
dialect = new Db2zOsSymmetricDialect(parameterService, platform);
} else if (platform instanceof Db2As400DatabasePlatform) {
dialect = new Db2As400SymmetricDialect(parameterService, platform);
} else if (platform instanceof Db2DatabasePlatform) {
int dbMajorVersion = platform.getSqlTemplate().getDatabaseMajorVersion();
int dbMinorVersion = platform.getSqlTemplate().getDatabaseMinorVersion();
if (dbMajorVersion < 9 || (dbMajorVersion == 9 && dbMinorVersion < 5)) {
dialect = new Db2SymmetricDialect(parameterService, platform);
} else {
dialect = new Db2v9SymmetricDialect(parameterService, platform);
}
} else if (platform instanceof FirebirdDatabasePlatform) {
int dbMajorVersion = platform.getSqlTemplate().getDatabaseMajorVersion();
int dbMinorVersion = platform.getSqlTemplate().getDatabaseMinorVersion();
if (dbMajorVersion == 2 && dbMinorVersion == 0) {
dialect = new Firebird20SymmetricDialect(parameterService, platform);
} else if (dbMajorVersion == 2) {
dialect = new Firebird21SymmetricDialect(parameterService, platform);
} else {
dialect = new FirebirdSymmetricDialect(parameterService, platform);
}
} else if (platform instanceof AseDatabasePlatform) {
dialect = new AseSymmetricDialect(parameterService, platform);
} else if (platform instanceof SqlAnywhereDatabasePlatform) {
dialect = new SqlAnywhereSymmetricDialect(parameterService, platform);
} else if (platform instanceof InterbaseDatabasePlatform) {
dialect = new InterbaseSymmetricDialect(parameterService, platform);
} else if (platform instanceof SqliteDatabasePlatform) {
dialect = new SqliteJdbcSymmetricDialect(parameterService, platform);
} else if (platform instanceof VoltDbDatabasePlatform) {
dialect = new VoltDbSymmetricDialect(parameterService, platform);
} else {
dialect = new GenericSymmetricDialect(parameterService, platform);
}
return dialect;
}
Aggregations