Menu
▾
▴
Tree [0b5cf6] master / History
| File | Date | Author | Commit |
|---|---|---|---|
| mavenproject3 | 2024-04-29 |
Bruce
|
[0b5cf6] my30 |
| .gitignore | 2021-01-13 |
Bruce
|
[85154f] nosql |
| README.md | 2023-10-31 |
Bruce
|
[7c2093] jdk21 |
Read Me
Database Benchmark
SQL and NoSQL Databases Benchmark Version 3 with iBoxDB MySQL.
Prepare
Stop Tracker daemon
Why does Tracker consume resources on my PC?
[user@localhost ~]$ tracker daemon -k
Run
//close all,
//open new Terminal each test.
cd mavenproject3
mvn package exec:java
Downloading from Remote Repository takes time at first.
Java Version
//Java 11 Version
export JAVA_HOME=/usr/lib/jvm/java-11-openjdk
//Java 18 Version
export JAVA_HOME=/home/user/Downloads/jdk-18.0.1.1
//Java 21 Version
export JAVA_HOME=/home/user/Downloads/jdk-21.0.1
export PATH=$JAVA_HOME/bin:$PATH
Results
VM 2Cores + 8G
OpenJDK 1.8.0_242
threadCount= 100,000 batchCount= 10 reinterationSelect= 10
PATH= ../TEST_TEA_SQL
iBoxDB
Database Transaction Test: Succeeded
iBoxDB Insert: 1,000,000 AVG: 28,210 objects/s
iBoxDB Update: 1,000,000 AVG: 33,404 objects/s
iBoxDB Delete: 1,000,000 AVG: 31,249 objects/s
MySQL
Database Transaction Test: Succeeded
MySQL Insert: 1,000,000 AVG: 2,738 objects/s
MySQL Update: 1,000,000 AVG: 2,024 objects/s
MySQL Delete: 1,000,000 AVG: 2,580 objects/s
Local Deploy Jar
Create Local Repository from Downloaded iboxdb-version.jar if can't download from remote repository.
then copy to /mavenproject3/libs/repository .
mvn deploy:deploy-file -Dfile=iboxdb-3.9.2.jar -DgroupId=iboxdb -DartifactId=iboxdb -Dversion=3.9.2 -Dpackaging=jar -Durl=file:./repository/ -DrepositoryId=repository -DupdateReleaseInfo=true
