Hello Andrea, Andrea Aime wrote: > 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.
It does provide a metadata table where the bbox may be found (and also, may be wrongly set). You're right, udig assumes quick bbox calculations (and gets slow). But I've got that code commented out, so the troubkle is somewhere else in udig. BTW, am I right to assume that passing a schema to my data store factory will only list my tables, whereas passing no schema will allow me to look up every table in the db? (Again, I specifically mean the Oracle DS.) Thanks for answering. Ugo > (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 > ------------------------------------------------------------------------------ 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
