Hi Pablo, Sorry but your issue lack a lot of information:
- OrientDB Version - Are you measuring with studio? If yes, please consider the rendering time. In case use EXPLAIN <YOUR-QUERY> to have the real execution time - How many UserTrace instances? And how many linked instances? - What kind of HW/SW configuration are you using? Best Regards, Luca Garulli Founder & CEO OrientDB <http://orientdb.com/> On 8 June 2016 at 22:10, pabloa <[email protected]> wrote: > Hello > > I have a class *UserTrace* with a property *trace* of type *LinkedList*. > Property *trace* is a list of other classes. > I have several thousand documents stored in that class on a remote server. > > When we send from Java a query like: > > > *select from UserTrace fetchplan *:-1* > > We get the list back but performance is bad (around 1000 documents by > second). > > I added *fetchplan *:-1* so the answer is a list of all documents with > all the properties and subdocuments fetched all together. And still we get > results at 1000 docs/second > > Is it possible to improve performance? > > It seems to us that each element of *userTrace*.*trace* list is *being > recovered again from the database*. Is that possible? Should "fetchplan > *:-1" return each entry in trace list fully exploded? > > This is the content of 1 document in *UserTrace* table. > > > <https://lh3.googleusercontent.com/-cxiIv0LkOcY/V09rJHdZh1I/AAAAAAAAEaM/bpYAbktpVScpHj4f2WhnEYS6em073wfBACLcB/s1600/Screenshot%2Bfrom%2B2016-06-01%2B16%253A06%253A18.png> > > > Any help will be welcome. > > Pablo > > -- > > --- > 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. > -- --- 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.
