On Thu, Jul 18, 2013 at 5:26 PM, Roel De Nijs <roel.den...@aquafin.be>wrote:
>
> When I take another look at the executed queries I notice that for some
> reason the whole table (or view) is queried (before the query with the bbox
> filter is executed):
> SELECT "MI_Id","GeoNode".STAsBinary() as
>
> "GeoNode","node_type","owner","system_type","asset_id","MI_Style","uid","user_text_3"
> FROM "dbo"."ViewIPUT"
>
Have no idea there, haven't used sql server in months.
This would require some investigation inside the code, but I have no time
to do that right now
outside of working hours.
Cheers
Andrea
--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
See everything from the browser to the database with AppDynamics
Get end-to-end visibility with application monitoring from AppDynamics
Isolate bottlenecks and diagnose root cause in seconds.
Start your free trial of AppDynamics Pro today!
http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
