Comments on Adriaan de Jonge: OrientDB: Connecting, writing and reading data

It's a pretty example for OrientDB usage. Mayb...

2012-01-24T19:25:48.450+01:00

It's a pretty example for OrientDB usage. Maybe can You add a sample for a sequence of query ?

Hi Luca, If you allow me a few days, I will send ...

2011-08-17T06:49:29.256+02:00

Hi Luca,

If you allow me a few days, I will send you a representative data set to reproduce this without sending things I am not allowed to send.

I just sent you a LinkedIn invitation in order to exchange contact information.

Adriaan.

Hi Adriaan, sounds strange. Can you share the CSV ...

2011-08-17T00:45:58.617+02:00

Hi Adriaan,
sounds strange. Can you share the CSV file to execute it locally?

Hi Luca, Thank you for your suggestion. I hate to...

2011-08-12T17:44:17.954+02:00

Hi Luca,

Thank you for your suggestion. I hate to say this, but must be honest, it turns out that this code takes longer in my test setup. Roughly 6200ms.

Should I upgrade OrientDB for this to work?

Adriaan.

It would be interesting to compare MongoDB and Cou...

2011-08-12T02:38:21.755+02:00

It would be interesting to compare MongoDB and CouchDB performance with OrientDB using this enhanced source (+3 lines of code):

public static void main(String[] args) {
try {
long start = System.currentTimeMillis();

File file = new File("E:/Development/uitjes.csv");

FileReader reader = new FileReader(file);
BufferedReader bufferedReader = new BufferedReader(reader);

String firstLine = bufferedReader.readLine() + "";
String[] columns = firstLine.split(";");
int length = columns.length;
for (int i = 0; i < length; i++) {
columns[i] = columns[i].replaceAll("w3s_", "");
columns[i] = columns[i].substring(0, 1).toLowerCase() + columns[i].substring(1);
}

ODatabaseDocumentTx db = new ODatabaseDocumentTx("local:/tmp/demo").create();
db.declareIntent(new OIntentMassiveInsert());

int cnt = 0;
String line;

ODocument uitje = new ODocument(db, "uitje");

while ((line = bufferedReader.readLine()) != null) {
cnt++;
if (cnt % 100 == 0)
System.out.println("cnt=" + cnt);

uitje.reset();
uitje.setClassName("uitje");

String[] values = line.split(";");

for (int i = 0; i < length; i++) {
if (i < values.length)
uitje.field(columns[i], values[i]);
}
uitje.save();
}
db.close();
System.out.println("DONE in " + (System.currentTimeMillis() - start) + "ms");

} catch (Exception e) {
e.printStackTrace();
}
}

It is possible that we use OrientDB with jsp,servl...

2011-07-19T12:07:42.538+02:00

It is possible that we use OrientDB with jsp,servlet to access data just like other database MySQL.....
then how? ( Example or idea of that)

Thank you ! Adriaan de Jonge i got way to run my ...

2011-07-16T06:10:45.959+02:00

Thank you ! Adriaan de Jonge i got way to run my database on OrientDB studio by making remote while connecting the server and right now i use the studio for insert , update , delete record select record without join just like other database server!!!
and its very easssy by using SQL query............

@Luca: thanks! That is even a better mechanism to ...

2011-07-15T20:11:58.881+02:00

@Luca: thanks! That is even a better mechanism to import lots of data. This code was actually only written for a simple performance test to compare with CouchDB and MongoDB. I'll experiment with OrientDB some more. There are still a lot more features to try.

@vinod: I must admit that I do not completely understand your question. If these exceptions occur while running the code, you should check if all the right JAR files are on the class path. It seems like these exceptions occur at some other point. I think you get better help posting this to an OrientDB forum. For example http://groups.google.com/group/orient-database

Sorry I could not be of better help. I myself am still only experimenting with OrientDB and do not yet know the product enough right now.

Hi, nice post! By the way if you want to go faster...

2011-07-11T12:23:50.243+02:00

Hi,
nice post! By the way if you want to go faster on massive insertion just follow these simple 2 suggestions:

http://code.google.com/p/orient/wiki/PerformanceTuningDocument#Massive_Insertion

2011-07-11T07:47:42.472+02:00

This comment has been removed by the author.