Mark I tried creating a GEOMETRY_COLUMNS table as you had suggested. Unfortunately there is no performance gain from doing that. It uses that new table rather than the oracle user_sdo_geom_metadata table, but still does an open connection, query, then close connection for each layer. I was hoping it would query the table once for all the data, then use that for each layer. The gt_pk_metadata table I created is being used but is quicker (even though it does the same for each layer open connection, query, close connection) because it can get all of the view's keys in one query versus a query for each key's column name.
Bob -- Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html ------------------------------------------------------------------------------ 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 If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
