Ugo Taddei ha scritto: > Hello, > > we're putting the oracle ng to work with udig. It finds the DB all > right, and almost lists the feature types ok. But I'm running into > warnings like > > WARNING: No primary key or unique index found for MY_TABLE. > 10-Sep-2009 10:10:14 org.geotools.jdbc.JDBCDataStore getPrimaryKey > INFO: No primary key found for SOME_OTHER_TABLE > > and seeing that udig is blocked. > > Are the infos and warnings such as above OK? > > One of the tables has around 20 M records. Apparently udig (or > geotools?) is taking to long to count something. I've seen it iterating > over features to calculate a bbox, but this time I'm not sure it's the > new datastore. Has the oracle ng been tested with large tables? Does > anyone have a hint where to start looking? > > Mind you, I've been told the tables have indices and a basic test class > (using the oracle ng) lists me my tables without any performance problem.
GeoServer + Oracle NG has been tested over tables with 50 million polygons with no issues. Well, besides the time it takes to compute the bbox if you initiate such a computation (took various minutes), but in GeoServer that is something manual. If uDig is assuming computing the bbox is quick and easy, well, sorry, wrong assumption, it should let the user input a bbox manually as well. Oracle simply does not provide any way to compute the bbox quickly. (and to be fair, try to stick 20M records in postgis without enabling the fast bbox computation and you'll be staring at a locked UI for a while there too) Cheers Andrea -- Andrea Aime OpenGeo - http://opengeo.org Expert service straight from the developers. ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Geotools-gt2-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
