On 2015-01-09 12:50, Frans Knibbe | Geodan wrote:
On 2015-01-07 3:55, Hugh Williams wrote:
Hi Frans,
This is a known issue reported with other geospatial queries and to
be looked into by development.
One further thing I have just noticed: Queries that ran OK in a previous
build (I can't recall which exactly) get the stack overflow error in
build 7.10.3211.
Maybe this bit of information is helpful...
Regards,
Frans
For your query can you please provide query profiles for both queries
ie the one that works and the one that does not, when run from isql
using the “set profile on” command as detailed at:
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksAanalyzingSPARQLQuery
OK! I will send the execution plans to you personally.
Regards,
Frans
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
On 6 Jan 2015, at 12:41, Frans Knibbe | Geodan
<frans.kni...@geodan.nl <mailto:frans.kni...@geodan.nl>> wrote:
Hello,
I know support for geographical functions in Virtuoso is a work in
progress, but I want to report the following issue anyway. Perhaps
developers are unaware of the issue, or perhaps there is a fix
available in the current version of Virtuoso (I use 7.10.3211).
I notice that when I try to use st_within
<http://docs.openlinksw.com/virtuoso/fn_st_within.html> with a
search radius I get the error "Virtuoso 42000 Error SQ200: Stack
Overflow in cost model" when the radius (/prec/ parameter) gets
below a certain threshold. This query runs well (on SPARQL endpoint
http://lod.geodan.nl/sparql) :
prefix bag:<http://lod.geodan.nl/vocab/bag#>
select count(*)
from<http://lod.geodan.nl/basisreg/bag/pand/>
from<http://lod.geodan.nl/basisreg/bag/verblijfsobject/>
where {
?pandmutatie a bag:Pandmutatie .
?pandmutatie bag:geometrie ?geom .
?pandmutatie bag:pand ?pand .
?verblijfsobjectmutatie a bag:Verblijfsobjectmutatie .
?verblijfsobjectmutatie bag:pand ?pand .
filter (bif:st_within(?geom, bif:st_point (4.91, 52.38), 0.002))
}
But when the radius is changed to 0.001 the query returns the "Stack
Overflow in cost model" error.
Regards,
Frans
------------------------------------------------------------------------
Frans Knibbe
Geodan
President Kennedylaan 1
1079 MB Amsterdam (NL)
T +31 (0)20 - 5711 347
E frans.kni...@geodan.nl
www.geodan.nl <http://www.geodan.nl/> | disclaimer
<http://www.geodan.nl/disclaimer>
------------------------------------------------------------------------
------------------------------------------------------------------------------
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_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
<mailto:Virtuoso-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------
Frans Knibbe
Geodan
President Kennedylaan 1
1079 MB Amsterdam (NL)
T +31 (0)20 - 5711 347
E frans.kni...@geodan.nl
www.geodan.nl <http://www.geodan.nl> | disclaimer
<http://www.geodan.nl/disclaimer>
------------------------------------------------------------------------
------------------------------------------------------------------------------
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
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------
Frans Knibbe
Geodan
President Kennedylaan 1
1079 MB Amsterdam (NL)
T +31 (0)20 - 5711 347
E frans.kni...@geodan.nl
www.geodan.nl <http://www.geodan.nl> | disclaimer
<http://www.geodan.nl/disclaimer>
------------------------------------------------------------------------
------------------------------------------------------------------------------
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
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
