Got it :) I'm sure others have asked themselves the question about whether long is necessary too. It's good we tried to clarify it.
Just a final comment: sequence overflow in the db is not that frightening, it's the uniqueness that limits us. So if you regularly delete old data, you can still reuse ids. I'm sure you'll never run out of ids, even if they were ints, because 4 billion records * 4 bytes each = 16GB, only for the ids. A lot more than a 1GB tablespace. And now, since JBPM uses longs, you use twice as much space for the ids (8 bytes each). Also, ints are better and faster on 32-bit archs. If I go for ints, I may try to somehow modify the hibernate mappings. But let's leave this fruitless chat, anyway... Good luck with deployment! Cheers, Saviola View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3917878#3917878 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3917878 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
