Hi Andrea, I was thinking that could be in the Oracle driver itself given its an Oracle specific thing. But don't know how it'd interface with GeoServer proper. I'll add a Jira suggestion that the documentation for Oracle reflect it with a nice big scary warning. But something in the GeoServer itself seems necessary given it can literally lock up GeoServer for hours for a sufficiently large dataset.
Davide: Interesting. Nice to see Oracle are being as consistent as ever. But at least they've kept the useful function. Jonathan On 9 January 2013 10:43, Andrea Aime <[email protected]> wrote: > On Wed, Jan 9, 2013 at 11:28 AM, Jonathan Moules < > [email protected]> wrote: > >> >> Given all of this, would it be worth including a "select count(*) from >> Table_name" when a user clicks "calculate bounds" on Oracle and warning the >> user if the feature count is > 100,000 that they should figure their bounds >> out another way? At least if its using AGGR_MBR. Otherwise courtesy of >> not-thread-safe, GeoServer admin will be locked up for literally hours if >> there are millions of features. >> > > Eh, the code there has to be database independent (the code there does not > really know what data source it is playing against), > and for PostGIS getting the "estimated bbox" is instant on tables of any > size, whilst count(*) can take a lot of time on > large tables (tens of seconds), same goes for SDE, cascaded WFS, SQL > Server, MySQL and so on. > > So the answer is... not going to happen :-) > > 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 Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery and much more. Keep your Java skills current with LearnJavaNow - 200+ hours of step-by-step video tutorials by Java experts. SALE $49.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122612
_______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
