Re: [orientdb] Query Collection (LINKSET, LINKLIST, RIDBAG) Elements from Parent RID

2015-09-17 Thread Luigi Dell'Aquila
Hi Bryan, probably the problems arises because the system has to expand all these big collections in memory. I'd suggest you to change your model a bit, adding a reverse link from log_event to log (or even better, an edge), so that you can refactor your query like following: select from log_event

[orientdb] Query Collection (LINKSET, LINKLIST, RIDBAG) Elements from Parent RID

2015-09-16 Thread Bryan
OrientDB 2.1.2 plocal connection ODocument API Hi all, Evaluating OrientDB, I'm trying to optimize a query that is running out of memory and pretty slow. I'm sure I must be doing something wrong. Say I have a simple schema like the following: log + name (String) + events (RIDBAG of log_eve