Hi, I just started working with h2 database.
and i want to know how to* insert and retrieve huge database* that is *some (million) database* - what is the procedure to insert and retrieve - how can we decrease time while inserting or retrieving million database - and how to use the queries...in it.to know how much time it is taking to insert 1 million records it may be simple *queries or procedures * please help me if any one know the answer On Fri, Jul 27, 2012 at 3:59 AM, Thomas Mueller < [email protected]> wrote: > 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. > > -- 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.
