Fastest way to load MASSIVE data into H2

101 views
Skip to first unread message

Andreas Reichel

unread,
Aug 21, 2023, 3:04:10 AM8/21/23
to h2-database
Greetings!

Please what would be the equivalent to Oracle SQL Loader for H2?
I know that H2 can read CSV directly, but I consider that (too) slow for large data. Is there any prepared facility for avoid parsing cell by cell and also skipping indices until the end?

Anything like Disable Index --> PARQUET File --> PreparedStatement --> Rebuild Index?

Thank you in advance and cheers
Andreas
Reply all
Reply to author
Forward
0 new messages