[orientdb] Re: Good query for for edges regarding start and end vertex.

Hi, did you tried it using indexes? Il giorno mercoledì 30 novembre 2016 15:19:24 UTC+1, Ray Neiheiser ha scritto: > > I have some performance problems with reading edges depending on their > start and end nodes. Is there a better way than checking every edges end > vertex of every start

Re: [orientdb] Traversal Response Times

Hi Eric, In a schemaless/mixed schema it's hard to make assumptions, but something can be optimized of course. Probably the big part of the difference is due to the number of traversed edges (N at the first level, NxN at the second, probably), but part of that can also be due to internal

[orientdb] Re: Can't select data from connected document

One more question, What is the way to get account @rid from this field "in('Employs')[0] as account"? I can get all fields, but not the @rid. On Monday, November 28, 2016 at 2:42:13 PM UTC-8, Ivan Mainetti wrote: > > Hi, > > in('Employs') returns a list, if you know that it can be only one

[orientdb] Re: It is possible to find a field in an array without knowing the path

could you add examples of query you tried? Il giorno mercoledì 30 novembre 2016 12:50:43 UTC+1, Academia Learning Centro de inglés y de formación ha scritto: > > I need to retrieve all Compositions that have the temperature field but do > not get their path since they are inside nested arrays

[orientdb] Re: Good query for for edges regarding start and end vertex.

please help me understand, you need to search edges knowing start and end vertices? Il giorno mercoledì 30 novembre 2016 15:19:24 UTC+1, Ray Neiheiser ha scritto: > > I have some performance problems with reading edges depending on their > start and end nodes. Is there a better way than

[orientdb] Re: [HELP] Order by date not working

This says the console: OrientDB console v.2.2.12-SNAPSHOT (build 2.2.x@r2a76ee1efc4487d9dc5f43e1ddc2fba 1c5a0167c; 2016-10-20 13:55:08+) www.orientdb.com Type 'help' to display all the supported commands. Installing extensions for GREMLIN language v.2.6.0 El martes, 29 de noviembre de

Re: [orientdb] Re: Mass insertion of vertices very slow, is it necessary Performance Tuning?

How can I consult that? Is installed on my local hard drive, this has a capacity of 15.5GB free El miércoles, 30 de noviembre de 2016, 7:59:10 (UTC+1), Andrey Lomakin escribió: > > Hi, > I also need to know the size of your database on disk. > > On Tue, Nov 29, 2016 at 3:18 PM Aceitunas y

Re: [orientdb] Re: Mass insertion of vertices very slow, is it necessary Performance Tuning?

How can I consult that? Is installed on my local hard drive, this has a capacity of 15.5GB free El miércoles, 30 de noviembre de 2016, 7:59:10 (UTC+1), Andrey Lomakin escribió: > > Hi, > I also need to know the size of your database on disk. > > On Tue, Nov 29, 2016 at 3:18 PM Aceitunas y

[orientdb] Re: [HELP] Order by date not working

Thanks, this works El martes, 29 de noviembre de 2016, 23:05:48 (UTC+1), Ivan Mainetti escribió: > > please try with > > select value.uid.value as id, value.context.start_time.value as date from > CompositionVersions order by date desc limit 5 > > > > >> -- --- You received this message

[orientdb] It is possible to find a field in an array without knowing the path

I need to retrieve all Compositions that have the temperature field but do not get their path since they are inside nested arrays -- --- You

Re: [orientdb] Re: Mass insertion of vertices very slow, is it necessary Performance Tuning?

Once you will have slowdown during insertion of data, just measure size of the database directory. On Wed, Nov 30, 2016 at 10:11 AM Academia Learning Centro de inglés y de formación wrote: > How can I consult that? Is installed on my local hard drive, this has a >

Re: [orientdb] Re: Mass insertion of vertices very slow, is it necessary Performance Tuning?

I need to know all this information to suggest you way to improve system speed )) On Wed, Nov 30, 2016 at 2:39 PM Academia Learning Centro de inglés y de formación wrote: > ok but I need to know if there is any way to improve performance > > > El miércoles, 30 de

Re: [orientdb] Re: Mass insertion of vertices very slow, is it necessary Performance Tuning?

Ah ok, I'll do the test. really do not see performance decline, it just takes more than 24 hours to insert Vertex type A: 1000 Vertex type B: 100,000 Enges A to B: 100 > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from

Re: [orientdb] Re: Mass insertion of vertices very slow, is it necessary Performance Tuning?

ok but I need to know if there is any way to improve performance El miércoles, 30 de noviembre de 2016, 12:59:59 (UTC+1), Andrey Lomakin escribió: > > Once you will have slowdown during insertion of data, just measure size of > the database directory. > > > On Wed, Nov 30, 2016 at 10:11 AM

[orientdb] Re: It is possible to find a field in an array without knowing the path

I have tried with any() but not working El miércoles, 30 de noviembre de 2016, 12:50:43 (UTC+1), Academia Learning Centro de inglés y de formación escribió: > > I need to retrieve all Compositions that have the temperature field but do > not get their path since they are inside nested arrays >

[orientdb] Re: Can't select data from connected document

using getProperty, like in my example code, you can do System.out.println("3 " + d.getProperty("account.@rid")); I don't know if it works even with *field()* method Il giorno mercoledì 30 novembre 2016 23:28:26 UTC+1, Borov ha scritto: > > One more question, > > What is the way to get account

Re: [orientdb] Re: Mass insertion of vertices very slow, is it necessary Performance Tuning?

Hello, you are finished inserting: Inserted 1000 EHRs, 10 compositions in 58062579 ms. The size of the database is 940mb -- --- 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,

[orientdb] Re: It is possible to find a field in an array without knowing the path

Yes, select from CompositionsVersions where any() like '%temperature%' But as the field is inside a value json does not find it, I have tried with fields / properties that are not in a json value and if it works El miércoles, 30 de noviembre de 2016, 23:02:47 (UTC+1), Ivan Mainetti

Re: [orientdb] Traversal Response Times

@Luigi-- Hmmm. If the difference between traverse out('MyEdge') and out('MyEdge').out('MyEdge') is 100X, that sounds like an opportunity for an internal optimization. Unless there are dozens of other edges beyond the first level in this schema, it seems that the query optimizer could figure

[orientdb] Good query for for edges regarding start and end vertex.

I have some performance problems with reading edges depending on their start and end nodes. Is there a better way than checking every edges end vertex of every start vertex? Iterable startNodes = getVertexList(relationshipStorage.getStartNode(), graph); Iterable endNodes =