Well before I do that, I have to question whether or not I made the best index.
The SQL Grammar page does not indicate whether or not I can specify whether the index as ascending or descending, yet down below on the same page, the information schema table shows that a particular index record has a ASC_OR_DESC field, which makes it sound like this option is configurable, yet I don't see that in the SQL grammar. I need my timestamps sorted asc, as this is chronological order, and if this is not the default, I would like to know how to change it. Julian On Oct 27, 1:58 pm, "Thomas Mueller" <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
