Hi Niels,
I wrote some code in geoserver for myself to conveniently export the jdbc
catalog back to the file system. I found a way to do this easily by firing
a bunch of catalog change events to the file system catalog. However, I am
not sure to make it easily available to end users at this point, I assume
that just giving you the code won't be very helpful for you. Perhaps we can
work something out if you are interested.
Copied in this conversation is my colleague Nicolas, and we are very much
interested in the JDBCConfig especially on the work to optimize how it
handles resource caching. This would be the best for our system if we can
make it perform faster.
In the mean time, however, we are more interested on how we can bring back
the JDBC Catalog to XML to make our PROD Environment faster as a
workaround. We'd appreciate getting the code you wrote for yourself and try
to do something with it. We'll probably add a few things here and there to
make it work for our scenarion and communicate that back to you.
Are you able to share the work you've done on Exporting JDBC Catalog back
to XML?
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
Kind regards,
Steve Omondi
On Tue, Nov 14, 2017 at 7:24 PM, Niels Charlier <ni...@scitus.be> wrote:
> Hello Steve,
>
> First I'd like to say I have been doing some work on considerable
> performance improvements for jdbcconfig. It happens to be the case that
> jdbcconfig doesn't take good use of its cache and repeatedly sends the same
> queries over and over again. It looks promising but I still need to do some
> improvements and write some tests and I had other work coming on top of it.
> But this is definitely coming.
>
> Also, I wrote some code in geoserver for myself to conveniently export the
> jdbc catalog back to the file system. I found a way to do this easily by
> firing a bunch of catalog change events to the file system catalog.
> However, I am not sure to make it easily available to end users at this
> point, I assume that just giving you the code won't be very helpful for
> you. Perhaps we can work something out if you are interested.
>
> Regards
>
> Niels
>
>
>
> On 09-11-17 11:02, Steve Omondi wrote:
>
> Hi guys,
>
> I have *JDBCConfig* enabled and connected to a Postgres DB. I have over
> 500 layers spread across different workspaces and layergroups.
>
> After running performance tests for GetMap requests against this
> configuration versus XML Catalog based geoserver I really need to revert my
> catalog back to XML in GEOSERVER DAT DIR and probably share it using NFS.
>
> *Is their a method to export the Database Catalog (based on JDBCConfig)
> back to XML Catalog?*
>
> Kind regards,
> Steve Omondi
>
>
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
> Virus-free.
> www.avast.com
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>
>
>
> _______________________________________________
> Geoserver-users mailing list
>
> Please make sure you read the following two resources before posting to this
> list:
> - Earning your support instead of buying it, but Ian Turton:
> http://www.ianturton.com/talks/foss4g.html#/
> - The GeoServer user list posting guidelines:
> http://geoserver.org/comm/userlist-guidelines.html
> Geoserver-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
