Node API - GET Method performance issue (disable sql logging)

[cps.git] / cps-application / src / main / resources / application.yml

diff --git a/cps-application/src/main/resources/application.yml b/cps-application/src/main/resources/application.yml
index f7fa735..e3ffd04 100644 (file)
--- a/cps-application/src/main/resources/application.yml
+++ b/cps-application/src/main/resources/application.yml
@@ -33,6 +33,7 @@ spring:
     application:\r
         name: "cps-application"\r
     jpa:\r
+        show-sql: false\r
         ddl-auto: create\r
         open-in-view: false\r
         properties:\r
@@ -45,13 +46,12 @@ spring:
         username: ${DB_USERNAME}\r
         password: ${DB_PASSWORD}\r
         driverClassName: org.postgresql.Driver\r
-        initialization-mode: always\r
         hikari:\r
             minimumIdle: 5\r
             maximumPoolSize: 80\r
-            idleTimeout: 120000\r
-            connectionTimeout: 300000\r
-            leakDetectionThreshold: 300000\r
+            idleTimeout: 60000\r
+            connectionTimeout: 120000\r
+            leakDetectionThreshold: 30000\r
             pool-name: CpsDatabasePool\r
 \r
     cache:\r
@@ -91,6 +91,9 @@ spring:
       default-property-inclusion: NON_NULL\r
       serialization:\r
         FAIL_ON_EMPTY_BEANS: false\r
+    sql:\r
+      init:\r
+        mode: ALWAYS\r
 app:\r
     ncmp:\r
         async-m2m:\r
@@ -157,18 +160,22 @@ logging:
             springframework: INFO\r
             onap:\r
                 cps: INFO\r
-\r
-dmi:\r
-    auth:\r
-        username: ${DMI_USERNAME}\r
-        password: ${DMI_PASSWORD}\r
-    api:\r
-        base-path: dmi\r
-\r
-timers:\r
-    advised-modules-sync:\r
-        sleep-time-ms: 5000\r
-    locked-modules-sync:\r
-        sleep-time-ms: 300000\r
-    cm-handle-data-sync:\r
-        sleep-time-ms: 30000\r
+ncmp:\r
+    dmi:\r
+        auth:\r
+            username: ${DMI_USERNAME}\r
+            password: ${DMI_PASSWORD}\r
+        api:\r
+            base-path: dmi\r
+\r
+    timers:\r
+        advised-modules-sync:\r
+            sleep-time-ms: 5000\r
+        locked-modules-sync:\r
+            sleep-time-ms: 300000\r
+        cm-handle-data-sync:\r
+            sleep-time-ms: 30000\r
+\r
+    modules-sync-watchdog:\r
+        async-executor:\r
+            parallelism-level: 10
\ No newline at end of file