On May 16, 2012, at 2:16 PM, Andrea Aime wrote: >> Hi Andrea >> >> the dataset is no very large. It contains aprox. tuples. > > Aprox how many? :-) If using the dataset bolzano with an isochrone of 15 minutes I obtain 100 tuples.
I also tried now to do recreate the index in oracle after the computation and update the Bounding box in Geoserver, but I still have very slow response times > >> The dataset is generated dynamically use REST. >> >> The bounding box is NOT close to 100%. Because this is something that has to >> be computed after the termination of the calculation. >> Maybe this causes the error: because initially, when loading the layer I do >> not set a MBR that is respectively larger > > Hum. no, the thing is, the query plan generated by Oracle for prepared > statements assumes often assumes using the spatial index is efficient, > but in case you're asking for the whole dataset a sequential scan > is (a lot) faster. I agree, especially for small tables like mine. In order to see the WFS request, you have to click on the bus stops where a popup will appear. But the time between the click in the map and displaying the popup is extremely long. And whenever I make such a request, than geoserver logs this warning message, that i listed in the first post. any idea? > >> >> You can see the example on my url: >> >> http://www.isochrones.inf.unibz.it/minex/ > > Tried a bit, there is a long wait while the system computes the isocrones > (there is a sort of white popup in the middle, with no text or images, which > I guess should be a "wait/computing" message), once that is removed > the tiles are coming back fast (tried up to 60 minutes isocrones). > Yes, that should be a progress bar. It's a little bit weird. > Cheers > Andrea > > -- > Ing. Andrea Aime > GeoSolutions S.A.S. > Tech lead > > Via Poggio alle Viti 1187 > 55054 Massarosa (LU) > Italy > > phone: +39 0584 962313 > fax: +39 0584 962313 > mob: +39 339 8844549 > > http://www.geo-solutions.it > http://geo-solutions.blogspot.com/ > http://www.youtube.com/user/GeoSolutionsIT > http://www.linkedin.com/in/andreaaime > http://twitter.com/geowolf ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
