Hello list,
The jdbcconfig module seriously slows down the response time of
requests. I discovered that it sends dozens of SQL queries to the db per
request, even though jdbcconfig uses a cache.
Turns out that the cache is only by id, but most queries to the catalog
are actually by name. For each ows request, the layer,
workspace,namespace, resource, etc... are all queried from the catalog
multiple times by name, resulting in many (duplicated) SQL queries.
So my suggestion would be to store catalog objects in the cache not only
by ID, but also by CATALOGINFOTYPE::NAME or something like that. Then we
can use the cache in all of the get[CATALOGINFOTYPE]ByName methods.
Are there any objections and/or suggestions to this proposal?
Regards
Niels
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
