Re: Digest for geodb@googlegroups.com - 2 updates in 1 topic

[Coquelicot]

Rafael,

Justin is right, the H2 + GeoDB should not be used in production. I am using it in some tests that generate quite a heavy traffic to the DB. From what I observed, it would not work well with, among other things, multiple users. Your dataset is quite large (10 GB) which limits the 'productiveness'even further...

Lukasz

On Sat, Jul 5, 2014 at 9:20 PM, <ge...@googlegroups.com> wrote:

  Today's topic summary

Group: http://groups.google.com/group/geodb/topics

• Geodb in production environment [2 Updates]

 Geodb in production environment

Rafael Lopez <i62l...@gmail.com> Jul 04 12:26PM -0700  

Hello,
Is GeoDB a database designed for use in a production environment?
 
I am developing a gis project, which handles geographic data, about 6
million polygons, and I need to perform spatial operations between polygon, points,
lines, ...
I am testing the following configuration:
 
- geodeb 0.8 (data base file ~ 10GB)
- hibernate spatial
- h2 1.3.175
- hatbox 1.0-b9
- database shared by an average of 50 users ( configured server
mode=TRUE)
 
I need to use spatial index (standard SQL function not work i.e.
ST_INTERSECT), and i am using hatbox function.
 
I am preparing a test environment to see the issues that I can find.
 
It GeoDB ever used in a similar environment?
 
do you think that geodb is a good choice?
 
 
Thanks


 

Justin Deoliveira <jdeo...@boundlessgeo.com> Jul 04 02:58PM -0700  

Hi Rafael,
 
Hopefully some of the active users on this list can chime in with some more
real world experience but I can share what I have seen.
 
Mostly I've seen geodb (and h2 in general) used more in the development and
test environment rather than in production.
 
That said people do use h2 in production, if you consult the h2 site and
discussion forum you will find good material of people that can attest to
that. You'll also find some more formal benchmarks about what sort of load
and concurrency h2 can handle.
 
Hope that helps.
 
-Justin
 
 
 
 
--
*Justin Deoliveira*
Vice President, Engineering | Boundless
jdeo...@boundlessgeo.com
@j_deolive <https://twitter.com/j_deolive>


 

[Rafael Lopez]

Thank you very much for your answer. In the coming days I will try to do some tests, but it is clear that is not the database I need.

However, it is very very good system for other uses. Maybe H2Gis serve for production environments, but no support for hibernate yet.

Thank you very much again.