Re: [orientdb] Re: OrientDB very slow on inserting edges (relations)

2014-10-21 Thread Bojan Vukotić
1. I use plocal 2. How to do this? Manually commit every 500-1000 rows or there is more sophisticated way? On Wednesday, 22 October 2014 08:41:01 UTC+2, Andrey Lomakin wrote: > > Hi, > >1. What type of storage do you use ? >2. Could you limit tx size let say by 500-1000 rows (this limi

Re: [orientdb] Re: OrientDB very slow on inserting edges (relations)

2014-10-21 Thread Andrey Lomakin
Hi, 1. What type of storage do you use ? 2. Could you limit tx size let say by 500-1000 rows (this limit will be not needed in 2.1 or 2.1.1)? On Wed, Oct 22, 2014 at 9:21 AM, Bojan Vukotić wrote: > I see this topic is very old, but I am still facing this problem. I > downloaded Orient

Re: [orientdb] Re: OrientDB very slow on inserting edges (relations)

2014-10-21 Thread Bojan Vukotić
I see this topic is very old, but I am still facing this problem. I downloaded OrientDB 1.7.8, I played with it programmatically, I wanted to migrate my rdbms to OriendDB, I did it programmatically, I already posted my code here https://groups.google.com/forum/#!searchin/orient-database/etl$20R

Re: [orientdb] SQL query performance with OR in the WHERE clause

2014-10-21 Thread Luigi Dell'Aquila
Hi, no, M2 is not the latest snapshot. You can find it here https://oss.sonatype.org/content/repositories/snapshots/com/orientechnologies/orientdb-community/2.0-SNAPSHOT/ Luigi 2014-10-21 21:15 GMT+02:00 Kanak Agarwal : > Hi > > Thanks for the response. I am seeing the issue in the OrientDB

[orientdb] lucene spatial - import 1.7.4 db to 1.7.9 throws error

2014-10-21 Thread Jonathan Rosen
Here is an error that is thrown when I try to import the 1.7.4 db that has a spatial index to 1.7.9: - Index 'stores.latlong'...Error on database import happened just before line 0, column 1582755 com.orientechnologies.orient.core.index.OIndexException: Index type: SPATIAL is not supported. Typ

[orientdb] Lucene in Neo4j has some misbehaviours in terms of reliable search querys - compared to OrientDB

2014-10-21 Thread 'Curtis Mosters' via OrientDB
I'm still in the evaluation of *Neo4j *vs. *OrientDB*. Most importantly I need Lucene as full-text index engine. So I created on both databases the same schema with the same data (300Mio lines). I'm also experienced with querying different things in both systems. I used the Standard Analyzer on

Re: [orientdb] SQL query performance with OR in the WHERE clause

2014-10-21 Thread Kanak Agarwal
Hi Thanks for the response. I am seeing the issue in the OrientDB 2.0-M2 community edition. Is this the latest SNAPSHOT? On Tuesday, October 21, 2014 2:23:04 AM UTC-5, Luigi Dell'Aquila wrote: > > Hi, > > what version of OrientDB are you using? We had two issues related to OR > operators and

[orientdb] OCommandExecutorNotFoundException creating OrientDB database via jar file

2014-10-21 Thread 'Curtis Mosters' via OrientDB
We want to import data on a Linux system. So we have 2 Java files for the import. One (*OrientDBMain.java*) is for creating an object that is doing all the work. The other (*OrientDB.java*) contains all the database functions like setting an index and so on. The second files starts with: pu

Re: [orientdb] Multiple vertex objects referring to the same database record are not in sync

2014-10-21 Thread Emanuele Milani
Thank you very much for you quick replies! I will try in the next few hours and let you know right away! On Tuesday, October 21, 2014 1:03:08 PM UTC+2, Andrey Lomakin wrote: > > Hi > I got reason of your issue, could you try 2.0-SNAPSHOT. > Problem should be fixed there. > > > On Tue, Oct 21, 20

Re: [orientdb] Multiple vertex objects referring to the same database record are not in sync

2014-10-21 Thread Andrey Lomakin
Hi I got reason of your issue, could you try 2.0-SNAPSHOT. Problem should be fixed there. On Tue, Oct 21, 2014 at 1:59 PM, Andrey Lomakin wrote: > Hi, > Do you have local cache enabled ? > It explicitly created to avoid such problems. > > On Tue, Oct 21, 2014 at 12:48 PM, Emanuele Milani < > m

Re: [orientdb] Multiple vertex objects referring to the same database record are not in sync

2014-10-21 Thread Andrey Lomakin
Hi, Do you have local cache enabled ? It explicitly created to avoid such problems. On Tue, Oct 21, 2014 at 12:48 PM, Emanuele Milani < milani.emanuele...@gmail.com> wrote: > Hi all! > > I am in the process of debugging an application based on OrientDB (2.0M2). > The problem I am facing are some

[orientdb] Multiple vertex objects referring to the same database record are not in sync

2014-10-21 Thread Emanuele Milani
Hi all! I am in the process of debugging an application based on OrientDB (2.0M2). The problem I am facing are some OConcurrentModificationException. The issue appears with both the "memory" and the "plocal" storage engines (I did not try "remote"). It looks they are caused by the fact that mul

Re: [orientdb] Re: Repairing security structures ?

2014-10-21 Thread stefan
I will. Thank you On Monday, 20 October 2014 08:08:07 UTC, Andrey Lomakin wrote: > > Hi Stefan, > It is fixed in 2.0-SNAPSHOT could you try ? > > On Sat, Oct 18, 2014 at 11:42 PM, > > wrote: > >> >> btw. this is 2.M2 and embedded server becomes unresponsive. >> >> Currently I have no option to re

Re: [orientdb] SQL query performance with OR in the WHERE clause

2014-10-21 Thread Luigi Dell'Aquila
Hi, what version of OrientDB are you using? We had two issues related to OR operators and index usage: https://github.com/orientechnologies/orientdb/issues/2898 https://github.com/orientechnologies/orientdb/issues/2893 and we fixed them some days ago. Could you try again on latest SNAPSHOT? tha

Re: [orientdb] Inserting a large file into OrientDB

2014-10-21 Thread NewUser
Hey Andrey just sent you the code I am posting it again since it only got sent privately it seems public class Test { static Sail sail; public void testAll(File f) throws Exception { KeyIndexableGraph og = new OrientGraphNoTx("plocal:server7/test", "admin", "admin"); Sail sail

Re: [orientdb] ETL for professional import to OrientDB

2014-10-21 Thread Bojan Vukotić
I tried to use ETL as described here http://www.orientechnologies.com/docs/last/orientdb-etl.wiki/Import-from-DBMS.html I used slightly modified approach (I don't know is it a correct one). I tried to import BookAuthor as vertex first (went fast and with no problems), than I tried to import B