Hi, > DELETE FROM
Try using TRUNCATE TABLE. That's much faster. http://www.h2database.com/html/grammar.html#truncatetable For in-memory databases, maybe it's faster to close the old database and create a new one. > quickly bootstrapping an in-memory database with an existing schema Try RUNSCRIPT (and SCRIPT to create the schema). http://www.h2database.com/html/grammar.html#runscript http://www.h2database.com/html/grammar.html#script If you want to avoid using files, use: the RunScript tool: http://www.h2database.com/javadoc/org/h2/tools/RunScript.html#execute(Connection,Reader) 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 -~----------~----~----~----~------~----~------~--~---
