Hi, I am currently having a huge in memory table (<10 Million records). I frequently need to perform an update on the whole table using complex formulae available in java. Rather than updating the results via an update table set value= newvalue where rowid=0 etc I am looking for a way to iterate all rows, calculate the value and then update a single row and fetch the next.
I couldn't find an example or way to do this via a stored procedure. But maybe an update via a fetch logic is also possible. What is the fastest to implement such a complex update? Thanks, Stefan -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/xuRgPixACEEJ. 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.
