Re: [orientdb] Re: Indexes not used in OR query?

2014-10-10 Thread Luca Garulli
Hi Keith, We improved SQL engine to use index also with mixed OR conditions in 2.0-SNAPSHOT. Could you try it? Lvc@ ᐧ On 10 October 2014 23:30, Keith Freeman <8fo...@gmail.com> wrote: > Bump. Anybody know if this is a bug or just a design limitation? > > On Tuesday, October 7, 2014 8:59:58 AM

[orientdb] OrientDB ODirectMemoryViolationException

2014-10-10 Thread Jing Chen
Hi, We got this error from our application. Did anybody see this before? What does this exception mean? Looks like we can't write anything to the db now. We are using 1.7.9 plocal connection pool in our application. The OS is CentOS. com.orientechnologies.orient.core.exception.OStorageExceptio

[orientdb] Re: Indexes not used in OR query?

2014-10-10 Thread Keith Freeman
Bump. Anybody know if this is a bug or just a design limitation? On Tuesday, October 7, 2014 8:59:58 AM UTC-6, Keith Freeman wrote: > > I created two indexes on the same class (which has about 100k records): > >1. create index Widget.a on Widget (a) notunique >2. create index Widget.b on

[orientdb] 2.0 M2 - uuid(), binary, console

2014-10-10 Thread Devon Miller
I know that uuid is not a storage type and you can use binary for it, but how do you stick a uuid value into a node from the console? I tried creating a property to binary then the setting the value using uuid() but that did not work. Also, "select uuid()" returns null. The only way that I cou

Re: [orientdb] Re: Production concerns

2014-10-10 Thread odbuser
Ok, it is embedded. But the host is shared as well so what are the typical memory sizes that you suggest? I mean what if the host has 128GB of RAM... are you suggesting that the cache be set at over 100GB? More realistically what if I just use 1GB of ram? What will happen when 1GB is reached

Re: [orientdb] Re: Paging and the distinct function

2014-10-10 Thread Hung Tran Dinh
hi Chris, I guess they scan Item cluster by insertion order to create the result set, I think that makes sense. Cheers, Hung Tran On Fri, Oct 10, 2014 at 9:00 PM, Chris Wilper wrote: > > The second record encountered (offset 1) in the pre-distinct > > result set is Item B, because the cluster

Re: [orientdb] Re: Paging and the distinct function

2014-10-10 Thread Chris Wilper
> The second record encountered (offset 1) in the pre-distinct > result set is Item B, because the cluster is being scanned in order. To be clear, I meant to say that when the cluster is scanned in order, the second record encountered in my case is Item B, which references Bag 1. In your case, it'

Re: [orientdb] Re: Paging and the distinct function

2014-10-10 Thread Chris Wilper
Interesting. I just tried in Studio and got the wrong result again: http://i.imgur.com/M76IeWP.png But looking closer, I noticed that your screenshot indicates that you inserted Item B *after* you inserted Items C and D. (the @rid of Item B is #59:3 whereas the others are #59:1 and #59:2) I didn

[orientdb] OrientGraphFactory pool quickly explodes server memory on 2.0-M2?

2014-10-10 Thread Keith Freeman
Running this code with 2.0-M2 causes my server to throw "2014-10-10 13:38:16:009 INFO Created database 'petshop' of type 'plocal' [ONetworkProtocolBinary]java.lang.OutOfMemoryError: Java heap space", even if I only have my pool set to (1,1) instances: public class O2GraphPool { public stati