[orientdb] Keep the database small?

2015-06-02 Thread scott molinari
I am not sure if it is because the person writing doesn't speak English as the native language, but this can't be right http://orientdb.com/docs/1.7.8/orientdb.wiki/Performance-Tuning.html#keep-the-database-small, as a performance tuning tip. *Keep the database small* The smaller the

[orientdb] Asynchronous Hooks and Server Functions

2015-06-02 Thread Chandima Jayawickrema
Hello, Is it possible to create an Asynchronous Hook for a particular class? My requirement is to invoke a function AFTER a new record is inserted without blocking the INSERT command. I tried the following code with some long operation inside HOOK_test function, but when i tried to insert

[orientdb] How to have Orientdb shard in distributed mode?

2015-06-02 Thread Darren Blaber
Hello, I have seen older references to sharding (https://groups.google.com/forum/#!searchin/orient-database/shard/orient-database/DqXQ9qPYo5w/EPP0y-y0H20J). Is it still possible to have orientdb (2.1) to automatically shard? In the documentation I am reading, it says cluster strategy is to

[orientdb] Re: Sources for orientdb community 2.0.10

2015-06-02 Thread Andrey Yesyev
Never mind, found them https://github.com/orientechnologies/orientdb/releases On Tuesday, June 2, 2015 at 4:19:36 PM UTC-4, Andrey Yesyev wrote: How to get sources for the latest stable release 2.0.10. I looked at git, there is no specific branch for 2.0.10, I ended up getting 2.0.x, which

[orientdb] Sources for orientdb community 2.0.10

2015-06-02 Thread Andrey Yesyev
How to get sources for the latest stable release 2.0.10. I looked at git, there is no specific branch for 2.0.10, I ended up getting 2.0.x, which doesn't fit to binaries from 2.0.10. -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To

[orientdb] Re: Complex query

2015-06-02 Thread Ziink A
Sorry, I don't have an answer but I'd explore one of the following options. 1. UNIONALL 2. both() for Vertex, bothE() for count, group by On Monday, June 1, 2015 at 3:10:15 PM UTC-7, Andrey Yesyev wrote: Hi there, I need help with a query. My schema is pretty simple. Vertices are connected

[orientdb] Re: possible to create a class extends from multiple classes?

2015-06-02 Thread Ziink A
Yes you can have multiple inheritance in the newer versions. create class C extends A, B; alter class C superclasses A, B; --Add A superclass alter class C superclass +A; --Remove B superclass alter class C superclass -B; Follow the link for more details.

[orientdb] Time Series Last Node Link

2015-06-02 Thread Thomas Kennedy
I have a time series modelled in the graph way year(linkmap)-month(linkmap)-day(linkmap)-hour(linkmap) I have two other vertices which are events and users I want to join events to the time series. Is this best achieved by using an edge or a linkset?

[orientdb] Edge Query Issue

2015-06-02 Thread Thomas Kennedy
I have a time series model where I create an edge between a hour vertex and an event vertex. The edge is called registered_event. I have tried the following query but it is not giving me results. Any ideas? select expand(month[12].day[3].hour[23]).out('registered_event') from Year where year =

Re: [orientdb] Trouble using In-memory DB and distributed mode ..

2015-06-02 Thread Luca Garulli
That post is pretty old. You can work with distributed databases only by using plocal. Unfortunately the support also for memory is 90% done, but not completed. Best Regards, Luca Garulli CEO at Orient Technologies LTD the Company behind OrientDB http://about.me/luca.garulli On 2 June 2015 at

[orientdb] Re: Edge Query Issue

2015-06-02 Thread Thomas Kennedy
Correction it gives me the below record but I want to expand the out('registered_events') relationship METADATAPROPERTIESOUT @rid @version @class hour registered_events #24:7 http://localhost:2480/studio/index.html#/database/test/browse/edit/24:741 Hour23 #27:0

[orientdb] OrientDB Eval

2015-06-02 Thread Fabio Ricci
Hi Luigi excellent! I am looking forward to get your answers. Meanwhile I will learn out of your daily valuable contributions in this mailing list Regards Fabio Am 29.5.15 um 12:21 schrieb Luigi Dell'Aquila: Hi Fabio, Thanks for reaching out, I'll take a look at your questions and I'll be

Re: [orientdb] Re: Keep the database small?

2015-06-02 Thread Luca Garulli
Hi guys, That piece of doc is old and... completely useless. Starting from 2.0 field names aren't stored in documents anymore if you define them in schema. I'm going to update that section. Any suggestions is welcome. Best Regards, Luca Garulli CEO at Orient Technologies LTD the Company behind

[orientdb] Re: Keep the database small?

2015-06-02 Thread Andrey Yesyev
I came across with this performance tip too. I was also very surprised. On Tuesday, June 2, 2015 at 3:37:21 AM UTC-4, scott molinari wrote: I am not sure if it is because the person writing doesn't speak English as the native language, but this can't be right

[orientdb] Re: What is the recommended way to manage OrientDB connections in Express.js or any web application

2015-06-02 Thread André Marques
I did some load tests using the connection pool and had some problems, I don't think the connections are threadsafe, or is not stable. Using one connection for all requests didn't work well, looks like the connection executes only one statement at time. Then I tested using one connection per

[orientdb] How do I run multiple queries in Studio?

2015-06-02 Thread isobretatel
2.0.10 -- --- 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 orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.

[orientdb] Re: What is the recommended way to manage OrientDB connections in Express.js or any web application

2015-06-02 Thread Samuel Goldenbaum
thanks Andre From what I undertand Oriento will open a new connection as needed when you try to access the db - at what point is this connection closed? Are the connections threadsafe? On Monday, June 1, 2015 at 4:38:55 PM UTC+2, André Marques wrote: Hi, You can also use the connection

Re: [orientdb] Re: Questions about ODB

2015-06-02 Thread Luca Garulli
Hi Scott, We use another Issue Tracker for clients that is synchronized with GitHub. Unfortunately GitHub issue tracker is quite limited. To ask question this is the best place. Best Regards, Luca Garulli CEO at Orient Technologies LTD the Company behind OrientDB http://about.me/luca.garulli

Re: [orientdb] Re: Keep the database small?

2015-06-02 Thread Andrey Yesyev
Hi Luca! The only suggestion I have - add more examples. I got back to OrientDB after more than a year break (it looks way better I have to admit) and I still see a lack of documentation. I'm struggling to build a query that returns edges' properties along with vertices' ones and I can't find any

Re: [orientdb] How do I run multiple queries in Studio?

2015-06-02 Thread Enrico Risa
Which version of OrientDB? 2015-06-01 21:04 GMT+02:00 isobretatel valery_tydy...@archibus.com: I have many CREATE queries. How do I run multiple queries in Studio? -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this

Re: [orientdb] Re: Keep the database small?

2015-06-02 Thread scott molinari
You now have my interest peaked. That is very interesting to know. Since we will be holding metadata (like the schema/ mapping) about our data anyway, this means we can take advantage of the schema option and not storing field names. Cool. Now to just get more understanding about ODB's

Re: [orientdb] Re: Questions about ODB

2015-06-02 Thread scott molinari
I've now read in the docs there is an option to do preallocation to basically pack on extra space for changing record sizes (through updates), in order to avoid movement of records. Is this still true? The documentation is a bit thin on explaining it. Scott -- --- You received this

[orientdb] Re: Complex query

2015-06-02 Thread Andrey Yesyev
Someone!? Please? On Monday, June 1, 2015 at 6:10:15 PM UTC-4, Andrey Yesyev wrote: Hi there, I need help with a query. My schema is pretty simple. Vertices are connected with Edges of type RELATED which have property count. 2 vertices can have connection in both ways at the same time.

[orientdb] Re: Using a very large number of databases

2015-06-02 Thread scott molinari
Considering that any database must store data somewhere and that somewhere is always in the file system of the server, then it might be safe to say, there is certainly a limit, usually fixed by ulimit in the OS (Linux). I am also interested in the answer though. Scott -- --- You received

Re: [orientdb] How fast should OrientGraph.query() be?

2015-06-02 Thread Nick DeYoung
Craig, I have tried that, it takes 11 ms. but that is not a Pipe - (g.getVertices()) our code base is leveraging another TinkerPop enabled graph databse and are researching the idea of switching it out. my research is trying to figure out how does orient perform on the generic Tinkerpop API. I

[orientdb] Re: OrientDB ETL tool

2015-06-02 Thread James Wang
Thanks, Luigi. More questions: is it possible to speed up OETL speed please? In remote mode, I can only import about 200 vertices per second Thanks a lot in advance On Friday, 29 May 2015 12:18:31 UTC+1, James Wang wrote: Hi All, I am new to OrientDB and trying to import data from a CSV

Re: [orientdb] How fast should OrientGraph.query() be?

2015-06-02 Thread W. Craig Trader
Nick ... (1) I don't work for OrientDB, (2) I am not familiar with the Tinkerpop APIs outside of OrientDB. OrientGraph.getVertices() returns an iterator, not a pipe. Gremlin adds a DSL method *_()* that will turn an iterator into a pipeline, from which you can do the normal Gremlin queries.

Re: [orientdb] How fast should OrientGraph.query() be?

2015-06-02 Thread Nick DeYoung
Blueprints is nice, but it is not a cross-graph-database panacea. there is much wisdom in this, that I think the graph community could use to hear from. On Tue, Jun 2, 2015 at 9:53 AM, W. Craig Trader craig.tra...@gmail.com wrote: Nick ... (1) I don't work for OrientDB, (2) I am not

[orientdb] Re: Questions about ODB

2015-06-02 Thread Nick DeYoung
we also read this in our office for the first time yesterday and had the same reaction :) How to win a race : cross the finish line first. thanks On Sunday, May 31, 2015 at 12:27:11 AM UTC-7, scott molinari wrote: Hi, We are still evaluating Databases. MongoDB was looking good, and now we

[orientdb] Re: What is the recommended way to manage OrientDB connections in Express.js or any web application

2015-06-02 Thread Samuel Goldenbaum
hmm, concerning On Tuesday, June 2, 2015 at 4:33:25 PM UTC+2, André Marques wrote: I did some load tests using the connection pool and had some problems, I don't think the connections are threadsafe, or is not stable. Using one connection for all requests didn't work well, looks like the

[orientdb] Re: Exception Cluster with id 5 already belongs to class OUser

2015-06-02 Thread Andrey Yesyev
Version orientdb-community 2.0.10. Connection remote. -- --- 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 orient-database+unsubscr...@googlegroups.com. For more

Re: [orientdb] Trouble using In-memory DB and distributed mode ..

2015-06-02 Thread Mahesh Wabale
On Monday, October 13, 2014 at 7:58:02 PM UTC+5:30, Lvc@ wrote: Hi, In-Memory database + Distributed works only in 2.0. Please could you try with 2.0-SNAPSHOT? Lvc@ ᐧ Hi luca , Are you talking about plocal database with cache . Is it correct ? I am confuse in in-memory

Re: [orientdb] How fast should OrientGraph.query() be?

2015-06-02 Thread W. Craig Trader
Nick ... Much like you told the SQL engine to use an index (select * from INDEX:V.testProperty ...), you need to explicitly use indexes from the graph API, as follows: *Java:* OrientVertex result = g.getVertices( V.testProperty, cbc6b219-9df3-44c5-90b2-ab7a6bd9bf7e ).iterator().next();