Re: [orientdb] Re: Storage concirns

2015-04-21 Thread Andrey Lomakin
Hi Stefan. About your question. *.sbc* files are used to store relations (edges) between vertexes. In sbc files space is occupied by removed edges reused only if it occupies half of total space to make possible to put all edges related to single vertex in close to each other on the disk. Could

[orientdb] Re: Want understand the concept.

2015-04-21 Thread Mahesh Wabale
hey , Luigi i got solution very very thanks. -- --- 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,

Re: [orientdb] Re: How to create lucene index with Python Bulbs framework?

2015-04-21 Thread Kevin I
@kyle, Sorry to get back so late. I can't quite wrap my head around this. From what you've said and I understand from the docs and from fiddling with the console, this is what I've understood: 1. In orientdb, all classes are identified with the `@CLASS` property just like the classes in Bulbs

[orientdb] Server side functions

2015-04-21 Thread Diaa ElKott
Hello, everyone: I was wondering if someone could share with me a tutorial on how to create server-side functions in OrientDB. The lecture on this topic in the Getting Started OrientDB course assumes a pre-existing function *createPerson()* within the example databases, and builds on it.

Re: [orientdb] Re: How to create lucene index with Python Bulbs framework?

2015-04-21 Thread Kyle
You are right, select from MyV set element_name = myv should be update MyV set element_name = myv sorry. From within bulbs you can create a vertex of type MyV by doing In [9]: data = {@class:MyV,ovgid:test1, element_type:MyV} In [10]: v=g.vertices.create(data) On Tuesday, April 21,

Re: [orientdb] Max cache limit is reached (3000 vs. 3001), sync flush is performed.

2015-04-21 Thread Andrey Lomakin
Hi Vitor, It means that you filled up write cache during migration and ti is flushed synchronously to the disk , and you should wait a bit till the end of the flush before next write operation will be performed. On Tue, Apr 21, 2015 at 7:39 PM, Vitor Enes Duarte vitorenesdua...@gmail.com wrote:

Re: [orientdb] Advice about embedding/wrapping orientdb inside a RESTful server

2015-04-21 Thread chrismichaels84
Thank you Luigi. That is what my research suggested, I just wanted to make sure I was on the right track before digging into code and design testing. It is then possible to scale the embedded database across multiple servers, yes? On Tuesday, April 21, 2015 at 9:11:20 AM UTC-5, Luigi

Re: [orientdb] Re: Storage concirns

2015-04-21 Thread Luca Garulli
Hi guys, We have a typo and we really call it freee with 3 e! Fixing it in current SNAPSHOTS, so Stefan use sbtreebonsai.freeeSpaceReuseTrigger, but then remember to switch to: sbtreebonsai.freeSpaceReuseTrigger If you use 2.0.9-SNAPSHOT or 2.1-rc2 or later. Lvc@ On 21 April 2015 at 08:42,

Re: [orientdb] De-duplication is very slow?

2015-04-21 Thread Luigi Dell'Aquila
much *F*aster of course, not *m*aster... 2015-04-21 17:10 GMT+02:00 Luigi Dell'Aquila luigi.dellaqu...@gmail.com: Ok, I saw the remote only now. If you want to go much master you should use plocal (this avoids network overhead). If you need other clients to connect to the db in remote mode,

[orientdb] De-duplication is very slow?

2015-04-21 Thread Sven Hodapp
Hi together, for my project I want to import a lot of data into the database. But the data should be de-duplicated. First of all, without de-duplication the insertion takes about 500 ms (a minimal test set): docelem = graph.addVertex(class:DocElem, uri, uri, type, type, model, model);

Re: [orientdb] De-duplication is very slow?

2015-04-21 Thread Luigi Dell'Aquila
Hi Sven, how are you connected to the db (remote or plocal)? Could you post the details of your db schema, in terms of classes, properties and index definitions? Thanks Luigi 2015-04-21 17:03 GMT+02:00 Sven Hodapp sven.hod...@gmail.com: Hi together, for my project I want to import a lot

Re: [orientdb] How to speed up queries

2015-04-21 Thread cr0xfyre
Hi Luigi, I'm looking at the output in the studio itself. Below the result table it says something like: Query executed in 0.153 sec. Returned 20 record(s) Isn't this time correct? if not, how can I see the real query time? On Tuesday, 21 April 2015 13:22:22 UTC+1, Luigi Dell'Aquila wrote: Hi

Re: [orientdb] De-duplication is very slow?

2015-04-21 Thread Luigi Dell'Aquila
Ok, I saw the remote only now. If you want to go much master you should use plocal (this avoids network overhead). If you need other clients to connect to the db in remote mode, you can start the server as embedded, see http://orientdb.com/docs/last/Embedded-Server.html 2015-04-21 17:09 GMT+02:00

[orientdb] Advice about embedding/wrapping orientdb inside a RESTful server

2015-04-21 Thread chrismichaels84
I am creating a restful server that will more-less expose premade types of queries. For instance: GET /relationships/mutual-friends?a=11b=14. That is an incredibly simple example. The end server is providing relational data for deep learning models. The server itself needs to be able to handle

Re: [orientdb] How to speed up queries

2015-04-21 Thread Luigi Dell'Aquila
Hi cr0xfyre, how are you measuring these times? Are you reading the query EXPLAIN? I ask because this could be just the time Studio takes to render the results, a query like this should take a few tens milliseconds to execute. Luigi 2015-04-21 13:01 GMT+02:00 cr0xfyre achi...@gmail.com: Hi

Re: [orientdb] Using OrientDB Object database in Spring

2015-04-21 Thread Rohitdev Kulshrestha
Did this work i'm getting an error com.orientechnologies.orient.core.exception.ODatabaseException: Database instance is not set in current thread. Assure to set it with: ODatabaseRecordThreadLocal.INSTANCE.set(db); On Saturday, 22 June 2013 23:01:50 UTC+5:30, Adam Walczak wrote: Many thanks

Re: [orientdb] Advice about embedding/wrapping orientdb inside a RESTful server

2015-04-21 Thread Colin
The embedded OrientDB server may be used in distributed mode just fine, even with other non-embedded instances. -Colin On Tuesday, April 21, 2015 at 2:31:02 PM UTC-5, chrismi...@gmail.com wrote: Thank you Luigi. That is what my research suggested, I just wanted to make sure I was on the

[orientdb] creating lucene index, no keys found

2015-04-21 Thread sck2015
Hi all, has anyone seen this behavior before, I am creating a lucene index and I don't see a match even though the index appears to have been successfully created (I am using version 2.0.7) orientdb {db=newSmallDB} create index Personid on Person(personid) FULLTEXT ENGINE LUCENE Creating

[orientdb] Re: create link between clusters of same class

2015-04-21 Thread Colin
Hi Krishna, A link just points to the RID of another record. That record could exist in a separate cluster of the same class type. -Colin Orient Technologies The Company behind OrientDB On Tuesday, April 21, 2015 at 6:37:17 AM UTC-5, Krishna Kumar wrote: HI, is it possible to create

Re: [orientdb] creating lucene index, no keys found

2015-04-21 Thread Enrico Risa
If you do select count(*) from index:Personid ? 2015-04-21 23:20 GMT+02:00 sck2015 sonukhullar@gmail.com: Hi all, has anyone seen this behavior before, I am creating a lucene index and I don't see a match even though the index appears to have been successfully created (I am using

[orientdb] Distributed Orientdb database Replica: Async/Sync option at write time

2015-04-21 Thread Darren Blaber
If one had a distributed Orientdb setup for the purpose of replicas, is it possible when saving the object to have the option to block/non block dynamically? What I was thinking of was something like this: ODocument testDoc = new ODocument(); testDoc.field(someone, somewhere); db.save(testDoc,

Re: [orientdb] Max cache limit is reached (3000 vs. 3001), sync flush is performed.

2015-04-21 Thread Vitor Enes Duarte
Hi Andrey, Thank you for your time. There's anything I can do to prevent this situation? Commit more often will help? Vitor, terça-feira, 21 de Abril de 2015 às 20:16:42 UTC+1, Andrey Lomakin escreveu: Hi Vitor, It means that you filled up write cache during migration and ti is flushed

Re: [orientdb] creating lucene index, no keys found

2015-04-21 Thread sck2015
Hi Enrico, this is what I see: orientdb {db=newSmallDB} select count(*) from index:Personid +--+- # |@CLASS|count +--+- 0 |null |1000 +--+- 1 item(s) found. Query executed in 0.0 sec(s). so definitely it is creating the index but I

Re: [orientdb] Re: How to create lucene index with Python Bulbs framework?

2015-04-21 Thread Kevin I
Ok! I tried `@CLASS` instead of `@class` and it didn't show up any error. But even now, the new vertices do not have the value `MyV` but `V`. I mean, I did `@CLASS = MyV` but after creation, if I see the vertices via rexster, all those records have `@CLASS = V`. I even tried `_type = myv` and

Re: [orientdb] Re: How to create lucene index with Python Bulbs framework?

2015-04-21 Thread Kevin I
Thanks kyle! Unfortunately, when I try to create the property `@class` like this : `data = {@class:MyV,ovgid:test1, element_type:MyV}`, I get the following error: ` SystemError: ({'status': '500', 'transfer-encoding': 'chunked', 'server': 'grizzly/2.2.16', 'connection': 'close', 'date': 'Wed,

Re: [orientdb] Re: How to create lucene index with Python Bulbs framework?

2015-04-21 Thread Kyle
Errors happen when you change the schema after starting rexster and connecting in bulbs. If you restart rexster that specific error will probably stop. I haven't figured out this problem completely, I think it has something to do with bulbs creating a transaction when you connect?? If you make

[orientdb] Re: How to 'group by' on only DATE (without the time)

2015-04-21 Thread Colin
What happens if you simplify the format as an experiment? select timestamp.format('-MM-dd) as dt from FILE group by dt On Tuesday, April 21, 2015 at 11:05:11 PM UTC-5, Kishy Kumar wrote: I tried the SQL you suggested and it didnt return any record. orientdb {db=baasbox} select

[orientdb] Re: How to 'group by' on only DATE (without the time)

2015-04-21 Thread Kishy Kumar
I tried the SQL you suggested and it didnt return any record. orientdb {db=baasbox} select timestamp.format('-MM-dd'T'HH:mm:ss.SSS'Z) as dt from FILE group by dt 0 item(s) found. Query executed in 0.021 sec(s). Thanks, Kishy On Tuesday, April 21, 2015 at 9:58:34 AM UTC-7, Colin wrote:

[orientdb] How can I query by @RID using the Gremlin Shell?

2015-04-21 Thread William Marshall
I am attempting to use Gremlin (in this case I'm actually using the gremlin.bat file included with OrientDB 2.0.7) to return the values of Vertex #12:615. Unfortunately, the syntax shown in the Gremlin API section of the documentation

[orientdb] super-newbie question about orientDB js

2015-04-21 Thread 3dukltd
I want to create a custom json that is output by OrientDB. Rather than adapting my client application to consume the default JSON output I want to conform the database output to what my client app needs to consume. I'm trying to get the Name and percentage values from these results which the

[orientdb] Re: How can I query by @RID using the Gremlin Shell?

2015-04-21 Thread Kyle
g.v['12:615'] should be g.v('12:615') note the lower case v and the () instead of [] In g.V['12:615'] the g.V is getting all vertices in g, then getting the property '12:615' from them, since this does not exist you get nulls. I would beware using g.V since it will return

[orientdb] How to speed up queries

2015-04-21 Thread cr0xfyre
Hi everyone, I'm very new to orient (and DBs in general) and I know very little about optimizing query speeds. My problem right now is that a simple query like select * from Leaf is taking the following times, with different limits: - *limit *= *time of query* - 500 = ~0.7s - 2450

[orientdb] create link between clusters of same class

2015-04-21 Thread Krishna Kumar
HI, is it possible to create link/linkset between two clusters of same classes? if possible proevide me SQL command two create link between two classes -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and stop

[orientdb] Re: How to 'group by' on only DATE (without the time)

2015-04-21 Thread Colin
Hi Kishy, Try something like this: select timestamp.format('-MM-dd'T'HH:mm:ss.SSS'Z'') as dt from FILE group by dt Also, notice the double-quotes in the call to format since you have single quotes embedded in there. Let us know if that works better for you. -Colin Orient Technologies

[orientdb] Error during usage of orient-spring-tx with ODB(2.x) in embedded mode in an spring application.

2015-04-21 Thread Rohitdev Kulshrestha
I'm trying to use @Transaction annonotaoin interceptpr via Spring(4.x) using the transaction manager provided by https://ops4j1.jira.com/wiki/display/ORIENT/Spring+Transaction+Manager+Usage I've used the similar configuration technique as described in the URl above. I get the following stack

Re: [orientdb] Advice about embedding/wrapping orientdb inside a RESTful server

2015-04-21 Thread chrismichaels84
Thank you both. You have confirmed what I needed to dig in. I'm excited to be working with orientdb. On Tuesday, April 21, 2015 at 3:54:37 PM UTC-5, Colin wrote: The embedded OrientDB server may be used in distributed mode just fine, even with other non-embedded instances. -Colin On

[orientdb] Asynchronous setup settings

2015-04-21 Thread Tobie Morgan Hitchcock
Hi, I was wondering what the difference is between the following settings in the default-distributed-db-config.json file: { executionMode: undefined, readQuorum: 1, writeQuorum: 1, } or { executionMode: asynchronous, readQuorum: 1, writeQuorum: 2, } Obviously they

[orientdb] Re: How to 'group by' on only DATE (without the time)

2015-04-21 Thread Kishy Kumar
Thanks for the suggestion. I try using date but it's not working. orientdb {db=baasbox} select timestamp from FILE +-+ # |@RID |timestamp +-+ 0 |#-2:1|2015-03-28T00:20:27.027-0700 1

[orientdb] Max cache limit is reached (3000 vs. 3001), sync flush is performed.

2015-04-21 Thread Vitor Enes Duarte
Hi, I'm working on a process to import from a MySQL database (I'm aware of OrientDB ETL but some data as to be pre processed before being inserted in OrientDB). At some point I'm getting this logs: Max cache limit is reached (3000 vs. 3001), sync flush is performed. Max cache limit is reached