Re: Is it possible to load the contents of Hsqldb .script files, etc into an all-in-memory Database?
Fred Toussi <[email protected]>
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <1373733469.28888.140661255261541.088A12D0@webmail.messagingengine.com> |
You use the SCRIPT 'filename' statement to create a full script. If there is any CACHED table, edit the script to remove the word CACHED from CREATE TABLE statements. You then open this script in your application with a file: url. The result is an in-memory database that persists all the changes. Fred On Fri, Jul 12, 2013, at 18:50, Tmo_hsqldb_q wrote: > > > Is it possible to load the contents of Hsqldb .script files,etc into an > all-in-memory Database? I'm trying to see if the all-in-memory database > gets a performance increase over an existing Server based solution. > > thanks, > Tony > > > > -- > View this message in context: > http://hsqldb.10974.n7.nabble.com/Is-it-possible-to-load-the-contents-of-Hsqldb-script-files-etc-into-an-all-in-memory-Database-tp3927.html > Sent from the HSQLDB - User mailing list archive at Nabble.com. > > ------------------------------------------------------------------------------ > See everything from the browser to the database with AppDynamics > Get end-to-end visibility with application monitoring from AppDynamics > Isolate bottlenecks and diagnose root cause in seconds. > Start your free trial of AppDynamics Pro today! > http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk > _______________________________________________ > Hsqldb-user mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/hsqldb-user ------------------------------------------------------------------------------ See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk