Geodb in production environment

[Rafael Lopez]

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]

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

--
You received this message because you are subscribed to the Google Groups "geodb" group.
To unsubscribe from this group and stop receiving emails from it, send an email to geodb+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Justin Deoliveira
Vice President, Engineering | Boundless
jdeo...@boundlessgeo.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.