Hi, first of all thanks for the reply. I am currently not in front of my work computer so I can't try that at the moment but I will do so next week.
Basically the statement looks like SELECT Field1, Field2, Field2, Field4, .... FROM tbl_dataset1 So it's simply an get every thing. Unluckily I would also like get the data sorted. So an get all query wold be nice to have (and probably even worser) - but I might be able to work around that. Regards, Lutz 2008/12/8 Thomas Mueller <[EMAIL PROTECTED]>: > > 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 -~----------~----~----~----~------~----~------~--~---
