Hi, > At the moment I'm doing more > thorough benchmarks that I've created.
If you are running benchmarks, could you benchmark them please? To do that use java -Xrunhprof:cpu=samples,depth=8 ... - and then upload/post the file java.hprof.txt If the benchmark application is not a self contained application, another way is to generate 'full thread dumps' (maybe 30 or so) while running the benchmark, and upload them? To get a full thread dump, you can use "kill -QUIT <pid>", or (Windows) press Ctrl+Pause, or (Java 1.6) use jps -l to get the <pid>, and then use jstack <pid>. > My records/rows contain a timestamp attribute, and they will be > inserted into the database in chronological order. The queries will > have a time range component to searches, so it would be best for > reading if my records were sorted by time. My understanding is that a > clustered index also benefits because there are fewer page faults > since the index is "in" the database since the rows are sorted by on > that timestamp (key) attribute. Yes, it is possible that your application would benefit from clustered indexes. However there are other ways to improve performance, and maybe the bottleneck is not the 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 -~----------~----~----~----~------~----~------~--~---
