Hi, I have similar problem when Iam inserting 1 million database it is taking 25 secs... The same database when iam retrieving it takes 100sec...
Please can you help me how to decrease the time while Retrieving. Thanks in advance .. On Saturday, July 2, 2011 9:47:44 AM UTC-7, Thomas Mueller wrote: > > Hi, > > The problem could be fragmentation in the database file. Could you try > SHUTDOWN DEFRAG? See also > http://h2database.com/html/grammar.html#shutdown > > Regards, > Thomas > > -- 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/-/PHl0_XcocwUJ. 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.
