Heads up regarding H2 1.2.120

[Hudson-2]

Just a heads-up that the new release uses the new "Page Store" format by
default,  and you have to specify ;PAGE_STORE=FALSE if you want to
continue using your existing data.

I did some benchmarks for GWC and it appears to be about 30% faster for
singlethreaded applications, no real performance difference over its
predecessor with 4 threads.

Also looks like he is publishing artifacts to the main maven repo again,
so we can just depend on those ( change groupId from org.h2database to
com.h2database )

-Arne

--
Arne Kepp
OpenGeo - http://opengeo.org
Expert service straight from the developers


------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Geotools-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geotools-devel

[aaime]

Arne Kepp ha scritto:
> Just a heads-up that the new release uses the new "Page Store" format by
> default,  and you have to specify ;PAGE_STORE=FALSE if you want to
> continue using your existing data.

Mind, 1.2.120 is still marked as beta

Cheers
Andrea

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Geotools-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geotools-devel

[Justin Deoliveira]

What do y'all think? Should we upgrade trunk? Or should we wait until it
is out of beta?

Andrea Aime wrote:

> Arne Kepp ha scritto:
>> Just a heads-up that the new release uses the new "Page Store" format
>> by default,  and you have to specify ;PAGE_STORE=FALSE if you want to
>> continue using your existing data.
>
> Mind, 1.2.120 is still marked as beta
>
> Cheers
> Andrea
>

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.

------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Geotools-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geotools-devel

[Jody Garnett-2]

No real difference to me either way; not quite sure what page store  
format is.

Jody

On 06/10/2009, at 11:11 PM, Justin Deoliveira wrote:

> What do y'all think? Should we upgrade trunk? Or should we wait  
> until it
> is out of beta?
>
> Andrea Aime wrote:
>> Arne Kepp ha scritto:
>>> Just a heads-up that the new release uses the new "Page Store"  
>>> format
>>> by default,  and you have to specify ;PAGE_STORE=FALSE if you want  
>>> to
>>> continue using your existing data.
>>
>> Mind, 1.2.120 is still marked as beta
>>
>> Cheers
>> Andrea
>>
>
> --
> Justin Deoliveira
> OpenGeo - http://opengeo.org
> Enterprise support for open source geospatial.
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry® Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart  
> your
> developing skills, take BlackBerry mobile applications to market and  
> stay
> ahead of the curve. Join us from November 9-12, 2009. Register  
> now!
> http://p.sf.net/sfu/devconf
> _______________________________________________
> Geotools-devel mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/geotools-devel

------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Geotools-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geotools-devel

[aaime]

Justin Deoliveira ha scritto:
> What do y'all think? Should we upgrade trunk? Or should we wait until it
> is out of beta?

Ha, good question. I guess this is just bad timing, it may be released
as stable next month, but there is no guarantee (what if Thomas is busy
with something else and the release gets delayed?).

As soon as page store is stable I would like to use it for the
H2 database, as the db, in unpacked version, is quite a bit smaller
than the current format.

Wondering, what are we using H2 for now? Only H2 epsg and H2 database?
I guess the call is upon uDig, that is actually using H2 epsg in v 1.2.

GeoServer wise we used for superoverlay and GWC, I guess that for those
we may want to wait, or at least to provide a smooth upgrade path?
What happens to existing data directories? If we want to use page store
for the new stuff, how to recognize the new from the old and use
pagestore just for the new?

Cheers
Andrea


--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Geotools-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geotools-devel

[aaime]

Jody Garnett ha scritto:
> No real difference to me either way; not quite sure what page store
> format is.

Pagestore is a new storage format for H2. It uses a paged approach,
requires less space, I think it can keep blobs in as opposed to external
files (or maybe it can up to a certain size), and as Arne noticed, it's
faster for the single user case.

Downside: it's new and not as well tested as the old storage format
(thus 1.2.120 being considered a beta after a long series of stable
ones)

Cheers
Andrea


--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Geotools-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geotools-devel

[Hudson-2]

Sorry, I didn't really mean to push for an upgrade, just wanted to
mention it because it's "hidden" in the release notes and I had some
performance numbers to share.

For GWC I will not upgrade right now, though the improved packing that
Andrea mentions is the reason I am looking forward to the new release.

If the final version does not provide a good way of detecting the format
change I will probably place an extra file whenever I create a 1.2
database and assume 1.1 if the database exists and the file is not present.

-Arne


Andrea Aime wrote:

> Justin Deoliveira ha scritto:
>> What do y'all think? Should we upgrade trunk? Or should we wait until
>> it is out of beta?
>
> Ha, good question. I guess this is just bad timing, it may be released
> as stable next month, but there is no guarantee (what if Thomas is busy
> with something else and the release gets delayed?).
>
> As soon as page store is stable I would like to use it for the
> H2 database, as the db, in unpacked version, is quite a bit smaller
> than the current format.
>
> Wondering, what are we using H2 for now? Only H2 epsg and H2 database?
> I guess the call is upon uDig, that is actually using H2 epsg in v 1.2.
>
> GeoServer wise we used for superoverlay and GWC, I guess that for those
> we may want to wait, or at least to provide a smooth upgrade path?
> What happens to existing data directories? If we want to use page store
> for the new stuff, how to recognize the new from the old and use
> pagestore just for the new?
>
> Cheers
> Andrea
>
>

------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Geotools-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geotools-devel