workshop-performance

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.

What do you need to install?

• Git
• Docker (if you are using Windows, make sure you set your Docker installation to use “Linux containers”).
• Docker Compose
• Visual Studio Code + InterSystems ObjectScript VSCode Extension

Setup

Build the image we will use during the workshop:

$ git clone https://github.com/intersystems-ib/workshop-performance
$ cd workshop-performance
$ docker-compose build

Configuration

The main purpose of this example is to test the performance of different databases connected by JDBC to a Java project.

Test Production

• Run the containers we will use in the workshop:

docker-compose build
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

MySQL Adminer

• Open Adminer using the following parameters:
  • Server: mysql
  • Username: testuser
  • Password: testpassword
  • Database: test
• Review the records in patient, city and country tables.

PostgreSQL Adminer

• Open Adminer using the following parameters:
  • Server: posrgres
  • Username: testuser
  • Password: testpassword
  • Database: testuser
• Select Schema test
• Review the records in patient, city and country tables.

IRIS database

• Open the Management Portal.
• Login using the default superuser/ SYS account.
• Open System Explorer –> SQL
• Select NAMESPACE USER and Schema Test

Modifying default war file

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

Testing with Postman

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.