Hi Guys, A recent update on this issue is, i got the job to do a very timely commit and it is fast, but after running it multiple times for testing and validation found something very interesting. The inserts were working really well until the table had 2147483647 (Integer.MAX_LIMIT) number of records, the inserts were happening at a very constant speed of 60,000,000 every 10 mins roughly with a commit size of 2 million. After the job inserts 2147483647 records into the table the job doesn't do anymore. I have ran the job more than 5 times and have noticed it gets to the same exact size every single time. I would like to know if h2 uses the Integer.MAX_SIZE for any of the row size calculation or something like that. Because I read on the limits and limitation of h2 that a single table could have 2^64 rows. So it would be helpful if someone could explain more on this issue.
Thanks a lot. regards Harish -- 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.
