Databases comparative based on a Java project connected by JDBC to IRIS, MySQL and Postgresql.
You can find more in-depth information in https://learning.intersystems.com.
New to IRIS Interoperability framework? Have a look at IRIS Interoperability Intro Workshop.
Build the image we will use during the workshop:
$ git clone https://github.com/intersystems-ib/workshop-performance $ cd workshop-performance $ docker-compose build
The main purpose of this example is to test the performance of different databases connected by JDBC to a Java project.
docker-compose up -d
Automatically an IRIS instance, a MySQL and a PostgreSQL databases will be deployed, a Tomcat will be deployed with the war generated from our Java project (you can check the code under the src folder).
You can check PostgreSQL and MySQL databases from Adminer
The war generated doesn't need further modifications to work, but you can edit the java project to test different queries. In order to generate a new war you will have to install Maven in your computer and add the InterSystems IRIS JDBC library into your local maven repository.
To generate a new war file from Visual Studio you only have to open a terminal and run:
mvn package -DskipTests
A new war will be created under
\target\ folder, rename it to
performance.war and move it into
\tomcat\ folder. The next step to deploy your new war is to clean the Docker containers and images and recreate it again launching:
docker-compose build docker-compose up -d
This project contains a json file to be loaded into Postman application (
performance.postman_collection.json). Once you have imported this file you will be able to launch the tests created by default.