Thanks for this information. I'm guessing "Thread-safe" is on the todo list
somewhere, certainly with BBOX creation being this slow (Oracle's fault of
course) it would be very useful.
For the most part our Oracle metadata is up to date and correct. Because we
use FME we have to add that stuff at creation time, and if it isn't
correct, it simply won't work properly when you try and view it via ArcSDE
and the like (such a picky piece of software!)
I'm Afraid I'm not in a position to offer patches. My skills are better
used at issue/bug spotting. ;-)
Cheers,
Jonathan
On 27 December 2012 12:06, Andrea Aime <[email protected]> wrote:
> On Thu, Dec 27, 2012 at 12:32 PM, Jonathan Moules <
> [email protected]> wrote:
>
>> Definitely have a Spatial Index. I'd know it if I didn't. ;-) (but have
>> just double checked - its there).
>>
>> This issue seems to be a little more nuanced than I previously thought.
>>
>> Now when I click "Compute from data" Geoserver web interface doesn't
>> appear to respond at all. Not even the error. I get a little flower-loading
>> icon in the top right and that's it. After a minute or two the new bounding
>> co-ordinates are loaded, but for all intents and purposes it actually
>> appears that GeoServer has crashed during that period.
>>
>
> This is because the inner configuration of GeoServer is not yet thread
> safe, the system is old and was created when only
> one admin could operate on it at a time.
> Unfortunately for long bbox computations the net result is that no other
> configuratione page can be opened... but the
> OGC services are still operating.
>
>
>>
>>
>> I ran the same query in Oracle SQL Developer and it took 2 minutes!
>> That's a very long time to get an MBR for just 50,000 features. I dread to
>> think what'll happen when I point it at my ~15million feature table!
>>
>> I think GeoServer should use the MDSYS.USER_SDO_GEOM_METADATA entry by
>> default - that's what its there for after all.
>>
>
> Of all the spatial databases Oracle has the worst situation when it comes
> to proper configuration for spatial tables, I have
> yet to see in person a single installation that has all the metadata in
> order, be either bbox, or declaring the target geometry
> type in spatial indexes, that's probably why no one bothered to implement
> the code to read from the metadata in
> the last hum... six or seven years.
>
> I believe it once existed, but it caused so much trouble due to
> mis-configured instances being the norm that when the
> JDBC stores got rewritten a few years ago we did not bother to put it back.
>
> That code could be brought back of course, and could be activated with a
> flag (not by default by any means though,
> only by those few ones knowing their instance is properly setup).
> The Java class to be modified is this one:
>
> https://github.com/geotools/geotools/blob/master/modules/plugin/jdbc/jdbc-oracle/src/main/java/org/geotools/data/oracle/OracleDialect.java
>
> It should be similar to PostGIS "estimated extent" machinery here:
>
> https://github.com/geotools/geotools/blob/master/modules/plugin/jdbc/jdbc-postgis/src/main/java/org/geotools/data/postgis/PostGISDialect.java#L251
>
> Only, in this case, the flag to activate that behavior should probably be
> called "declared extents".
>
> Patches welcomed :-)
>
> Cheers
> Andrea
>
>
> --
> ==
> Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
> information.
> ==
>
> Ing. Andrea Aime
> @geowolf
> Technical Lead
>
> GeoSolutions S.A.S.
> Via Poggio alle Viti 1187
> 55054 Massarosa (LU)
> Italy
> phone: +39 0584 962313
> fax: +39 0584 1660272
> mob: +39 339 8844549
>
> http://www.geo-solutions.it
> http://twitter.com/geosolutions_it
>
> -------------------------------------------------------
>
This transmission is intended for the named addressee(s) only and may contain
sensitive or protectively marked material up to RESTRICTED and should be
handled accordingly. Unless you are the named addressee (or authorised to
receive it for the addressee) you may not copy or use it, or disclose it to
anyone else. If you have received this transmission in error please notify the
sender immediately. All email traffic sent to or from us, including without
limitation all GCSX traffic, may be subject to recording and/or monitoring in
accordance with relevant legislation.
------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122712
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
