Hi Guys, I must have considerable performances issues with h2 database.
Clearing step is running for more than 60 minutes. It’s using half of my CPU power. This clearing step will execute ALTER statement as show below for 10 tables. For executing these ALTER statements it takes almost 60mins. ====================================================================== [2017-06-09 00:23:16.722] Script execution started. [2017-06-09 00:23:16.731] Executing: SET SCHEMA s_dmask_001QOB1400000000002Q [2017-06-09 00:23:16.731] Executing: ALTER TABLE Opportunity DROP COLUMN IF EXISTS FLIP_COL [2017-06-09 00:23:17.917] Executing: ALTER TABLE Opportunity ADD COLUMN IF NOT EXISTS FLIP_COL VARCHAR(2) Below is the JDBC URL used jdbc:h2:tcp://INHYW00000423/C:\Program Files\<<AgentName>>\apps\Data_Integration_Server\data\cmask\database\dmask;CACHE_SIZE=209715 Tried to modify the JDBC URL by increasing the cache size and below options as well , but did not find any difference in performance improvement. *URL*: jdbc:h2:tcp://INHYW00000423/C:\Program Files \<<AgentName>>\apps\Data_Integration_Server\data\cmask\database\dmask;CACHE_SIZE= 2097152;FILE_LOCK=NO;TRACE_LEVEL_FILE=0;LOG=0;LOCK_MODE=0;UNDO_LOG=0 We are using h2 db of version "*h2-1.3.176.jar*". Your assistance in this matter is greatly appreciated *Regards*, Prasad -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
