Hi, I have a speed problem - I have one or several large datasets - each of which is might be to big to be handeld in memory only. But I basically need a random access to each row in these datasets. So I thought I try out a H2 for temporary storage of the data.
I can first read in the data from a csv-file create a table (temporary or cached temporary) and transfer the data into that table via a prepared statement. Until then everything works fine. but when I then open the table it takes ages. And to position the cursor/resultset via absolute() takes just as long. Any idea on how to improve the situation? Thank you, Lutz --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. 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 -~----------~----~----~----~------~----~------~--~---
