SQL x Java performance

[Lucas Lira Gomes]

Hi all,

is there any substantial difference in speed between the Java API and the SQL API? If so, which one is faster?

Regards, Lucas Lira Gomes.

[nagaraja sosale ramaswamy]

if working in plocal mode, java API is faster, but in remote mode, SQL API is faster due to less object serialization overhead.

note that this is not from personal experience.

[W. Craig Trader]

The SQL API is written on top of the Java document API. The Graph API is also written on top of the Java document API. Thus, in general, using the document API should be faster, if you're using it optimally, but that may involve a lot more coding.

Depending on what you're doing, it may be easier to use one of the other APIs to achieve your goals.

In particular, it is almost always easier to define your schema using the SQL DDL commands, particularly when defining indexes.

- Craig -

--

---
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-databa...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Lucas Lira Gomes]

Hi all,

thank you for your input. Currently, I'm using both APIs, even though I'm running OrientDB on embedded mode. For generating the schema, the Java API was my default choice as I haven't found it to be difficult to use. In fact, I prefer to use the Java API, since IntellJ's help with type checking and code completion is a huge plus. For tasks that required sorting and filtering, however, I found it was way easier to just use the SQL API.

Regards, Lucas Lira Gomes.

Hi,

Regards, Lucas Lira Gomes.

----------------------------------------------------------------------------------

Lucas Lira Gomes (x8lucas8x)

Linux User #533002
Tel.: +55 (81) 99596-7816

http://www.x8lucas8x.com/

--

---
You received this message because you are subscribed to a topic in the Google Groups "OrientDB" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/orient-database/qIMH6WQ7K-g/unsubscribe.
To unsubscribe from this group and all its topics, send an email to orient-databa...@googlegroups.com.