I am totally new to H2 database and have been following your posts in learning H2 database and working with it. I am stuck with a problem and need your advice .
We treat H2 database as a tmpDB for running the query which are not supported by our underlying DB. Ex: Order by and Group By are not supported by our DB. To get this done we can use normal way like running the basic query on our DB ,storing the results in csv format and bulk insert into H2(CSVREAD) and run the query once again on H2 to get the final results. The problem with above approach is that it includes double I/O . The data can include million records. What we think: - Understand CSVREAD code and customize it to our needs. - The data keeps coming-in in buffer . - Without manipulating it,directly insert into H2 like CSVREAD. - Assuming that CSVREAD reads data and stores in a buffer before inserting into data, we need to implement CSVREAD code for inserting the data from buffer. Please advice on how to proceed further. It will be very helpful if you could provide point us to the CSVREAD code. Also please let us know if you have any better approach for bulk insert of data into H2 for buffer. Thanks in advance. Regards, Bharath -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/MugfxCCwMMkJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
