H2: UUID vs INT

I need to decide when developing Orchid  if I should use UUID or INT for primary keys. If I use UUID I can generate ID's  on any node I want and it seriously  impacts  simplicity of algorithms. And simple is good! )

Most of the people I asked about performance impact of switching to UUID told me not to do that. I decided to benchmark.

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
Reading 'int': 6.844 sec

It looks like impact the is negligible. Sweet

First post

I am here

public class Main{
 public static void main(String[] args){
  System.out.println("hello world");
 }
}