From: <ko...@gm...> - 2010-10-26 16:38:20
|
I traced it down to PostGISDialect.getGeometrySRID method. The execution of: SELECT SRID("position") FROM "public"."view_machine_harvest" LIMIT 1 took about 160 seconds. I had to reinstall postgres&&postgis to make this go away :) Thanks! -------- Original-Nachricht -------- > Datum: Tue, 26 Oct 2010 10:02:53 +0200 > Von: Andrea Aime <and...@ge...> > An: ko...@gm... > CC: geo...@li... > Betreff: Re: [Geotools-gt2-users] Postgres View Problem > On Tue, Oct 26, 2010 at 9:47 AM, <ko...@gm...> wrote: > > Hey, > > > > I'm using uDig and GeoTools (version 2.6.5). Recently, I created a view > that is showing 400.000 rows. During the start up, geotools takes about 90 > seconds to perform buildFeatureType() method of the type > org.geotools.jdbc.JDBCFeatureSource. > > > > ResultSet columns = metaData.getColumns(null, databaseSchema, tableName, > "%"); > > while (columns.next()) { > > //... > > } > > > > Apparently, this loop is performed 400.000 times. Right before, I'm > getting the message: > > That loop is performed 400.000 times only if you have 400.000 columns, not > rows. > Can you go through it with a step by step debugger and see exactly > what is going on? > > Cheers > Andrea > > ----------------------------------------------------- > Ing. Andrea Aime > Senior Software Engineer > > GeoSolutions S.A.S. > Via Poggio alle Viti 1187 > 55054 Massarosa (LU) > Italy > > phone: +39 0584962313 > fax: +39 0584962313 > > http://www.geo-solutions.it > http://geo-solutions.blogspot.com/ > http://www.linkedin.com/in/andreaaime > http://twitter.com/geowolf > > ----------------------------------------------------- -- GRATIS! Movie-FLAT mit über 300 Videos. Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome |