These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: increment versus uid.hex
PostPosted: Mon May 30, 2005 11:12 am 
Beginner
Beginner

Joined: Thu Sep 16, 2004 4:36 am
Posts: 22
Hey all,


I did a test with my classes. I created a class and a subclass and inserted 10000 off them in my database.
The class uses as generator uid.hex.
this takes 59 seconds (average) so i'm very happy, thats very fast.

but now i want the code to use a long, so i change the field in the java object to long and change the mapping to use a long and as generator increment.

The same 10000 objects take an average off 343 seconds?

I changed the config so i would see the sql and changed the amount off objets to 10.
The queries are the same number, i mean there are as many sqlqueries to the db in the test with uid.hex as with the long.

Is this known, do i need to tweak something? Did i forget something (like don't use long, but Long)

Och yeah, my database is pgsql.

greetings


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.