I use Orientdb 2.2 I create a class:TabzIndex with coordinate geospatial
(Opoint)
create class TabzIndex extends V
create property TabzIndex.xy EMBEDDED Opoint
Create property [all other property]
+----+-------+---------+----+-----+-------+-----------------------+----+-------------------+--------+----+
|# |@RID |@CLASS |id |idTag|tagName|xy |z |date
|type |z2 |
+----+-------+---------+----+-----+-------+-----------------------+----+-------------------+--------+----+
|0 |#25:760|TabzIndex|3 |941 |tag941
|OPoint{coordinates:[2]}|16.0|2009-08-17 01:03:19|Personne|76.0|
I index xy to make the query faster
CREATE INDEX Ixy ON TabzIndex (xy) SPATIAL ENGINE LUCENE
I make a seconde class (*Tabz*) is the same *TabzIndex* with out Index on *xy*
but the same data inside
When I make a polygone query like
select count(*) as GeoReturn from TabzIndex where ST_WITHIN(xy,'POLYGON ((0 0,
0 40, 40 40,40 0, 0 0))') = true limit 1000000
+----+---------+
|# |GeoReturn|
+----+---------+
|0 |11552 |
+----+---------+
And (the same query for Tabz)
select count(*) as GeoReturn from Tabz where ST_WITHIN(xy,'POLYGON ((0 0, 0 40,
40 40,40 0, 0 0))') = true limit 1000000
+----+---------+
|# |GeoReturn|
+----+---------+
|0 |18410 |
+----+---------+
The result is different! Why do I loose some data when i use index? What I do
wrong?
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
