>
> Hi,
>>
>>
>>  About crazy talks, what our hardcore Oracle developers do first when
>> they face problems with efficiency is to start writing some PL/SQL
>> procedures which they then tune until they are satisfied (of when we say
>> that we have paid enough). Unfortunately Geoserver can't utilize those
>> fancy creatures at the moment. It feels to me that they belong logically to
>> the same category than the stored queries in WFS 2.0 so perhaps Geoserver
>> could support them someday.
>>
>
> I'm confused... sql views should be working also with stored procedures,
> provided that they are returning a set of records?
>

Really?  Wouldn't this trigger the "no index found" error when the WMS bbox
filter query is wrapped around the SQLView query?

But if this works then that solves our problem (apart from being a bit of a
pain to write a PL/SQL proc...)

I will try this as soon as I can.
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to