What is size of your database ? What is amount of RAM on PC which is used for testing ?
On Fri, Apr 11, 2014 at 4:06 PM, Andrey Lomakin <[email protected]>wrote: > 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 > > -- 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.
