Hi Andrea: > The H2 version has two significant downsides thought: > - untested, thought I've heard Jody tested it against uDig
This is true; the transition was fine (although the database size issue; and delay in creating the first time caused some trouble). Performance seems fine. > - the H2 version of the database uses almost 40MB instead > of the 9-10 of the HSQL version. This is a known issue > with H2, the author is working on a more compact storage > engine, but the work is incomplete > > So if we want to upgrade we're going to live with > both of the above issues, and we're already in RC, that's > why I'm publicly asking on the list. I am not too worried about disk use once we are running (it is the delay that was tough). The actual script is like 800k which is the same as for HSQL. > - as the HSQL version, if you kill the process while it's > creating the database on disk you'll get a ruined database > that will prevent GS from working at all. Subsequent restarts > will just fail, and the only way out if to locate and wipe out > the directory containing the EPSG database (which is in the > current "temp", a different place depending on the OS and > user configs) I thought I saw a "table check" and if that failed it would try creating the database again? > Before proposing a switch to H2 I also wanted to also solve > the first two above issues. > > Long story short, it's not the kind of upgrade I would take lightly. > I'm hesitant to do the upgrade now, but I'm not opposed > either. If we could solve the two critical database > creation issues above at least we'd have reward enough to > make the risk acceptable The reward for udig was killing the hsql dependency; what about your idea of unzipping a copy of the database (rather then running the script; or executing out of a jar). Jody ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Geoserver-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-devel
