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 -------------------------------------------------------
------------------------------------------------------------------------------ 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
