Hi Thomas, Sorry I've been slow in answering - I'm currently on the road.
You can download the patch here: http://pokercopilot.com/Made_the_Analyze_statement_give_progress_reports_via_DatabaseEventListener.patch I updated to the latest trunk source before creating this. BTW: Despite what the JavaDocs say, Database.getAllTablesAndViews(false) includes meta tables in the results. I've coded around this in the patch. In the process of working out how to do the progress reports, I did notice that ANALYZE is now automatic by default. Possibly this is indeed enough for my needs. Regards, Steve --------------------------------------------------- Steve McLeod Founder, Poker Copilot http://www.pokercopilot.com On Jul 15, 7:47 am, Thomas Mueller <[email protected]> wrote: > Hi, > > I thought about how to implement a progress bar for "analyze". There > are a few problems (it's relatively hard to estimate an accurate > progress number), but let's try. Do you already have a patch? > > By the way, I'm not sure if you know about the automatic analyze that > is now enabled by > default:http://h2database.com/javadoc/org/h2/constant/DbSettings.html#ANALYZE... > - possibly you no longer need to run it manually. > > Regards, > Thomas -- 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.
