def runMySQL(numberOfExecutions, polygonID): print('Started MySQL Benchmark') db = mysql.Mysql() results = db.runQueries(mysqlqueries(polygonID), numberOfExecutions) db.disconnect() print('Finished MySQL Benchmark') output.printSingleResult(results) return results
def runMonetDB(numberOfExecutions, polygonID): print('Started MonetDB Benchmark') db = monetdb_db.Monetdb() results = db.runQueries(monetdbqueries(polygonID), numberOfExecutions) db.disconnect() print('Finished MonetDB Benchmark') output.printSingleResult(results) return results
def runHana(numberOfExecutions, polygonID): print('Starting Hana Benchmark') hanaDB = hana.Hana() hanaResults = hanaDB.runQueries(hanaqueries(polygonID), numberOfExecutions) hanaDB.disconnect() print('Finished Hana Benchmark') output.printSingleResult(hanaResults) return hanaResults
def runPostgis(numberOfExecutions, params): print('Started postgis Benchmark') postgisDB = postgis.Postgis() postgisResults = postgisDB.runQueries(postgisqueries(), numberOfExecutions, params) postgisDB.disconnect() print('Finished postgis Benchmark') output.printSingleResult(postgisResults) return postgisResults
def runPostgis(numberOfExecutions): print('Starting postgresql (postgis) Benchmark') postgisDB = postgis.Postgis() postgisResults = postgisDB.runQueries(postgisqueries(), numberOfExecutions) postgisDB.disconnect() print('Finished postgresql (postgis) Benchmark') output.printSingleResult(postgisResults) return postgisResults
def runMySQL(numberOfExecutions): print('Starting MySQL Benchmark') mysqlDB = mysql.Mysql() mySQLResults = mysqlDB.runQueries(mysqlqueries(), numberOfExecutions) mysqlDB.disconnect() print('Finished MySQL Benchmark') output.printSingleResult(mySQLResults) return mySQLResults
def runSpatialiteMain(numberOfExecutions, params): print('Started spatialite Benchmark') db = spatialite.Spatialite(':memory:') db.loadDiskData('benchmark.db') spatialiteResults = db.runQueries(spatialitequeries(), numberOfExecutions, params) db.disconnect() print('Finished spatialite Benchmark') output.printSingleResult(spatialiteResults) return spatialiteResults
def runPostgis(numberOfExecutions, areaPoints): print('Started postgis Benchmark') postgisDB = postgis.Postgis() areaString = postgisDB.polygonString(areaPoints) postgisResults = postgisDB.runQueries(postgisqueries(areaString), numberOfExecutions) postgisDB.disconnect() print('Finished postgis Benchmark') output.printSingleResult(postgisResults) return postgisResults
def runSpatialiteMain(numberOfExecutions): enableIndex = False print('Starting spatialite Benchmark - main-memory') spatialiteDBMain = spatialite.Spatialite(':memory:') # spatialiteDBMain = spatialite.Spatialite('benchmark.db') spatialiteDBMain.setUpSoccerData(enableIndex) spatialiteResultsMain = spatialiteDBMain.runQueries( spatialitequeries(), numberOfExecutions) spatialiteDBMain.disconnect() print('Finished spatialite Benchmark - main-memory') output.printSingleResult(spatialiteResultsMain) return spatialiteResultsMain