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.
> 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. How do those statements look like? > 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. I usually don't read the complete table using a query. Instead, I usually execute a query that returns just the rows I want (queries with a low number of results). Can you use simple queries that return one row, or a low number of rows? H2 does support large result sets, but they are slower than small result sets (sometimes much slower). Example: SELECT ... FROM ... WHERE ID=? Where ID is the primary key or a unique index. Regards, Thomas --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
