Hi Justin, all,
By working on an alternate CatalogFacade implementation, found the
catalog being aggressively called for a workspace named "web".
Digging into it found that loading any wicket page results in a _lot_
of queries to the catalog. For example, loading the page
"/web/?wicket:bookmarkablePage=:org.geoserver.web.data.store.StorePage"
results in 288 calls to Catalog.getWorkspaceByName("web").
And if there's a workspace named "web", an extra 282 calls to
Catalog.getLayerByName("resources")
BTW, I know calling a workspace "web" is kind of hair pulled, but
possible. And it seems this affects any other "root" resource path
that's not /ows|wfs|wcs|wms.
The calls are made by OWSHandlerMapping in order to strip off local
workspace calls from the URL path.
It's not the end of the world, as the memory catalog facade needs just
to make a Map.containsKey or so for each call. But it does look like
unneeded overhead of a database backed catalog facade, as loading a
single web page leads to ~200 to ~400 database queries just to check
for a non existent workspace/layer.
So I wonder, and you would know better, if there's any easy way to avoid that.
I can think of a couple hacky ways (i.e. the killer one is the /web
url path, I don't think other "root" end points like /rest or /www
would get so many calls, so I could hack on the catalog facade
implementation to return null iif I know there's no such workspace,
etc). But I'm asking in case you can think of a non/less hacky one.
Only thing that crosses my mind is a catalog listener that keeps a set
of actually available workspace names so that OWSHandlerMapping
refrains from asking each time... But don't feel well at all with it.
By the other side, if OWSHandlerMapping had (or looks for) instead
what URL mappings are registered in the app context, that wouldn't
solve anything, since it is possible for a module to register the
/geosearch endpoint, but that doesn't prevent a workspace to be called
geosearch. So.... ideas?
TIA,
Gabriel
--
Gabriel Roldan
OpenGeo - http://opengeo.org
Expert service straight from the developers.
------------------------------------------------------------------------------
Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
infrastructure or vast IT resources to deliver seamless, secure access to
virtual desktops. With this all-in-one solution, easily deploy virtual
desktops for less than the cost of PCs and save 60% on VDI infrastructure
costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
