Hi, Maybe the fastest way is to use:
create table newTable as select ... from oldTable drop oldTable rename newTable ... Regards, Thomas On Thu, Jul 19, 2012 at 10:36 AM, Stefan <[email protected]> wrote: > 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. -- 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.
