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.net
https://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