Hi, What do you mean better could you provide me more information ?
On Fri, Apr 11, 2014 at 1:02 PM, Hoan Nguyen <[email protected]>wrote: > 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. > -- Best regards, Andrey Lomakin. Orient Technologies the Company behind OrientDB -- --- 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.
