> Maybe someone could add another test to that page You can found some results here : http://fodomust.u-strasbg.fr/~derivaux/chart20090105.png using jdbc and an embedded server.
data : create table fact (clientId int, productId int, dateId int, qty int, price float, primary key (dateId, productId, clientId)) 10.000.000 rows some dimensions tables (small) queries: insert => insert 200.000 rows scan => select * from fact sum => select sum(qty*unitPrice) from fact f join product p on f.productId = p.id joinsum => select c.country, c.city, sum(qty) from fact f join client c on f.clientId = c.id group by country, city join2 => select d.yeard, c.country, c.city, sum(qty) from fact f join client c on f.clientId = c.id join dated d on f.dateId = d.id group by yeard, country, city H2 seems CPU bound. It does a table scan on dated instead of fact (which is in my opinion more clever as it doesn't fit in memory). --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
