> Hi Andrea > > the dataset is no very large. It contains aprox. tuples.
Aprox how many? :-) > 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. > > 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). 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
