Hi, One of my H2 DB table contains 100,000 records[Fixed number of records]. This table stores the online transactional data from building devices.
At every 20 secs, I need to update above said table with real time data from devices. To speed up the update process,Can I run multiple threads parallelly for the update operation? For example Thread 1 updates record from 0 to 10,000 Thread 2 updates record 10,001 to 20,000 and so on. As per the documentation, table level locking applies during update. Is it possible to have record level locking instead of table level locking during update?. Kindly advice. With Regs :Ansari S.H --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
