[orientdb] Dijkstra with dynamic weight

2015-02-06 Thread Georg Göttlich
Hello everyone. I have another newbie question regarding the graph model. Is it somehow possible to have the result of a custom function being the weight parameter in dijkstra()? Cheers Georg -- --- You received this message because you are subscribed to the Google Groups OrientDB group.

[orientdb] phpOrient and DATE

2015-02-06 Thread Dlpnet
Hello, I have a vertex with 2 DATE properties. When I use phporient to get the data from the vertex the resulting dates are not correct. If I do the same request using Studio the answer is correct. Is there anyway to convert the result from phporient to a proper value ? I tried converting from a

Re: [orientdb] UnsupportedOperationException When Creating in Memory Distributed Database

2015-02-06 Thread Luigi Dell'Aquila
Hi Andy, This is a known issue, you can find all the details here: https://github.com/orientechnologies/orientdb/issues/3203 Luigi 2015-02-05 16:58 GMT+01:00 dakota.pric...@gmail.com: Hello, I am unable to create an in MEMORY distributed database due to the following exception:

[orientdb] Re: sql update with query - will eventually hang

2015-02-06 Thread syshex
Hi Alexander Do you need to Expand ? select expand(in('Manages')) from asset where guid = '19da4856-57c0-4b39-8f4b-53fc47f86dcf') Returns a result set of the complete records, which you don't seem to need, just the rid. select in('Manages') from asset where guid =

[orientdb] sql update with query - will eventually hang

2015-02-06 Thread alexander anguiano
orientdb version 2.0.1 java 7 windows and linux i'm making alot of these calls and eventually they begin to hang update Agent set lastCommunicationTime=date() where @rid in (select @rid from (select expand(in('Manages')) from asset where guid = '19da4856-57c0-4b39-8f4b-53fc47f86dcf'))

[orientdb] Re: sql update with query - will eventually hang

2015-02-06 Thread alexander anguiano
yes it is faster, but it gets in a weird state. If i remove the inner select and just run this update Agent set lastCommunicationTime=date() where @rid = #13:3 it's taking 2 seconds. On Friday, February 6, 2015 at 9:42:19 AM UTC-6, syshex wrote: Hi, Without the expand it should be faster

Re: [orientdb] Robustness Problem

2015-02-06 Thread Luca Garulli
Hi Chanras, When you killed the process, OrientDB was flushing pages on disk. During this operation you could have portion of your database lost. In this case OrientDB read the WAL (Journal) and rollback any non committed transactions. This is to *apply the ACIDity of transactions*. About indexes

[orientdb] Select using Index fires warning: result set with more than 10000 records

2015-02-06 Thread syshex
Using a Query like so : select expand(rid) from index:Papers.publicationDate skip 10 limit 50 order by key DESC makes orientdb fire a warning : 2015-02-06 12:16:33:718 INFO {db=testdb} [TIP] Query 'select expand(rid) from index:Papers.publicationDate skip 10 limit 30 order by key DESC'

[orientdb] Re: Select using Index fires warning: result set with more than 10000 records

2015-02-06 Thread syshex
Also skip 10 limit 50 order by key DESC in this query gives different results than order by key DESC skip 10 limit 50 on the same query, which was unexpected to me On Friday, February 6, 2015 at 12:21:14 PM UTC, syshex wrote: Using a Query like so : select expand(rid) from

[orientdb] Re: sql update with query - will eventually hang

2015-02-06 Thread alexander anguiano
Ok, i see what happened if i run this in the sql analyzer it i don't see a rid select in('Manages').@rid from asset where guid = '19da4856-57c0-4b39-8f4b-53fc47f86dcf' but if i run this new update Agent set lastCommunicationTime=date() where @rid in (select in('Manages').@rid from asset

[orientdb] Re: sql update with query - will eventually hang

2015-02-06 Thread syshex
Hi, Without the expand it should be faster now. The hanging bit, are you saying that after running update commands like that , after a bit the server starts hanging and/or the queries taking longer to execute ? Anything being printed on the logs ? On Friday, February 6, 2015 at 3:25:26 PM

Re: [orientdb] Re: sql update with query - will eventually hang

2015-02-06 Thread Luca Garulli
Try this: update (select expand(in('Manages')) from asset where guid = '817ea932-4a4a-49a4-8454-37c5098703a2') set lastCommunicationTime=date() With expand the collection becomes the resultset. Lvc@ On 6 February 2015 at 17:40, alexander anguiano jobl...@gmail.com wrote: I didn't realize

Re: [orientdb] Re: sql update with query - will eventually hang

2015-02-06 Thread Emanuel
Have you thought to do change in this way: update #13:3 set lastCommunicationTime=date() bye Emanuel On 06/02/15 15:59, syshex wrote: update Agent set lastCommunicationTime=date() where @rid = #13:3 -- --- You received this message because you are subscribed to the Google Groups

Re: [orientdb] newbie traverse confusion

2015-02-06 Thread Georg Göttlich
Hi Riccardo. Thank you very much for your offer to help and please excuse the somewhat incomprehensible post late at night. Here is what I'm trying to do. Consider the following setup. create class NodeTypeA extends V create property NodeTypeA.name string create vertex NodeTypeA set name =