I am thinking of switching from INT to UUID as a primary key. Well in fact I will use PRIMARY KEY from two columns, one is UUID and another is INT. It used to be INT and INT. How should it impact my performance and in what cases?
I have written a benchmark. It produces the following results Inserts count:500000 Read count:100000 Putting 'uuid': 79.893 sec Putting 'int': 70.266 sec Reading 'uuid': 4.085 sec Reading 'int': 2.734 sec Reading 'uuid': 3.06 sec Reading 'int': 2.687 sec Reading 'uuid': 2.859 sec Reading 'int': 9.188 sec Reading 'uuid': 7.87 sec Reading 'int': 6.901 sec Reading 'uuid': 7.094 sec It looks like they are the same. The difference is relatively small. I am not sure if it is representative enough, because I don't know the internals of H2. When should I expect large drop in performance? Thanks -- 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.
