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.
