Hi,
I have 3 classes in the database: Publisher and Document extends V,
published_by extends E
Document has a link to Publisher.
Here is my Publisher data:
--------------------------------------------------
ODocument - Class: Document id: #12:12312 v.2
--------------------------------------------------
active : 1
channel : twitter
date : Mon Nov 11 18:23:42 ICT 2013
favorited : 0.0
lang : en
tag : [3626-21845373, 3505-2419]
text : Bad call $GS… #IndiaBubble #GlobalREBubble 'Interest
Rates Head Northwards!' via @BloombergTVInd http://t.co/boEa7Kk7co
timestamp : Mon Nov 11 18:23:42 ICT 2013
uri : http://twitter.com/CMCMFIN/status/399859976417853440
out_published_by : #11:1019
and my Publisher data:
--------------------------------------------------
ODocument - Class: Publisher id: #11:12312 v.19
--------------------------------------------------
in_published_by : [size=18]
twitterID : 993892195
countryISOCode : uk
cat3 : undefined
thumbnailUrl :
http://a0.twimg.com/profile_images/2941066306/b2f346f0770cffabff8dfb48a8b43aaf_mini.jpeg
group : financial market professionals
name : Nikki Spraggon
url :
photoUrl :
http://a0.twimg.com/profile_images/2941066306/b2f346f0770cffabff8dfb48a8b43aaf_normal.jpeg
cat1 : trader
cat2 : undefined
score : 0.0
type : p
documentCount : 0
screenName : NicolaSpraggon
mongo_id : 5285ded0112c60304fc85da7
Also, this is my indexes:
INDEXES:
----------------------------------------------+------------+-----------------------+----------------+------------+
NAME | TYPE | CLASS
| FIELDS | RECORDS |
----------------------------------------------+------------+-----------------------+----------------+------------+
dictionary | DICTIONARY |
| | 0 |
Document.out_published_by | NOTUNIQUE | Document
| out_pub... | 3918019 |
Document.uri | NOTUNIQUE | Document
| uri | 3918020 |
ORole.name | UNIQUE | ORole
| name | 3 |
OUser.name | UNIQUE | OUser
| name | 3 |
Publisher.@rid | UNIQUE | Publisher
| @rid | 0 |
Publisher.screenName | NOTUNIQUE | Publisher
| screenName | 29406 |
Publisher.twitterID | NOTUNIQUE | Publisher
| twitterID | 29406 |
----------------------------------------------+------------+-----------------------+----------------+------------+
TOTAL = 8
7894857 |
-----------------------------------------------------------------------------------------------------------------+
Also, I have disabled all cache (level 1 & 2), but the second time I
execute the same query, it is always better as if it has been cached. Could
you explain this for me?
Thank you in advance,
Hoan
--
---
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.
