On Wed, Feb 27, 2013 at 12:23 AM, <[email protected]> wrote:

> It seems that there is a bug in GeoServer SQL view creation which resulted
> in slow rendering of images and some image never appeared on the browser.
> The issue resolved by creating oracle views and publishing layer using that
> oracle view.
>

In order to allow the usage of whatever SQL expression in "SQL views"
GeoServer does the following:

select <fields selected from the OGC request>
from (<your sql view sql>) as gt_view
where <predicates coming from the OGC request>
<eventual limit/offset coming from the OGC reques>

The above is pretty standard SQL, if that is not fast but a "CREATE VIEW"
in the database is instead,
then the database query plan optimizer is to blame.

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

-------------------------------------------------------
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to