java - H2 Database - Creating Indexes -

java - H2 Database - Creating Indexes -

i'm using h2 database - running in embedded mode - , when app starts load h2 database info mysql database. i'm using linked tables point mysql tables.

my issue i'm trying speed time h2 takes create indexes on tables, particularly larger tables (5million+).

does know if safe run create index commands in separate thread while load next table's info h2? example: thread 1: loads table 1 -> tells thread 2 start creating indexes , thread 1 loads table 2, etc.

i can't utilize mvcc mode when loading tables because later on need utilize multi_threaded mode when selects. when seek using multi_threaded mode got locking errors though loading info discrete tables.

many thanks!

what might work (but i'm not sure if it's faster) create tables , indexes first, , load tables in parallel. should avoid locking problems in scheme table.

java database h2