+1 for this, (Luca, you know why ;-) )
--
Da: Greg mccarv...@gmail.com
Inviato: 28/12/2013 18.11
A: orient-database@googlegroups.com
Oggetto: [orientdb] Is there a concept of calculated properties?
Is there such a concept in OrientDB as calculated properties? For
Hi all,
I thought about it for a long time, it's not a trivial problem.
For me calculated properties are just a little fragment of something
bigger: considering that we have classes, hierarchies and polymorphism, we
could implement methods on classes (not only getters/setters, but also
complex
Hi Thomas,
test[0] is actually an ODocument (a Java object).
Just try this:
test[0].field(name)
Luigi
2014-02-19 3:23 GMT+01:00 Thomas Kennedy tomais.kenn...@gmail.com:
Hi,
I am using the 1.7-rc1 version and have attempted to access an element on
JSON object that is returned and receive
enough in the documentation. Going
by the documentation I would of thought that the return type was a
Javascript JSON object.
Can you point me to any documentation on this?
Much appreciated
On Wednesday, 19 February 2014 08:12:56 UTC, Luigi Dell'Aquila wrote:
Hi Thomas,
test[0] is actually
;)
On 04/04/14 21:03, Luca Garulli wrote:
Hi all,
I'm glad to announce Luigi Dell'Aquila as new committer of OrientDB
Project. Maybe some of you already know Luigi as a OrientDB Academy Teacher.
Luigi's main contribution are about performance tuning and API
improvement.
Welcome aboard
Hi,
Thank you very much for your feedback, I'm in charge of this task and I'm
about to start it.
I'm not a parser expert, so I'm still studying all these frameworks (I did
something with JavaCC in the past, but nothing very complex).
My first impression is that JavaCC is very good for low level
working example.
Take care!
Fidel H Viegas
On Mon, Aug 11, 2014 at 10:24 AM, Luigi Dell'Aquila
luigi.dellaqu...@gmail.com wrote:
Hi,
Thank you very much for your feedback, I'm in charge of this task and I'm
about to start it.
I'm not a parser expert, so I'm still studying all
receiving emails from it, send an
email to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Luigi Dell'Aquila
Orient Technologies LTD
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group
receiving emails from it, send an
email to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Luigi Dell'Aquila
Orient Technologies LTD
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group
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.
--
Luigi Dell'Aquila
Orient Technologies LTD
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?
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 index usage:
https://github.com/orientechnologies
Hi Bojan
in general IMHO all this makes sense.
I guess edge creation speed can be improved with some tuning or code
tricks, but I should see your import code..
Anyway, if you decided to go with links and you need 1:n or n:n, you can
use LINKLIST or LINKSET properties instead.
About procedure
), BookAuthor);
edge.setProperty();
}
rs.close();
statement.close();
graph.commit();
I used both OrientGraph and OrientGraphNoTx but I didn't see a big
difference
On Wednesday, 22 October 2014 16:39:33 UTC+2, Luigi Dell'Aquila wrote
/optout.
--
Luigi Dell'Aquila
Orient Technologies LTD
--
---
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
Hi Santosh
I'll answer your questions below:
1. I was reading the documentation for distributed database on multiple
servers here
http://www.orientechnologies.com/docs/last/orientdb.wiki/Distributed-Configuration.html.
I see that we need to configure several files like
Hi Wouter,
I think it's an issue of Object database implementation, we can fix it
quickly just testing database type in OObjectLazySet.getDatabase() and
wrapping it in an OObjectDatabaseTx instance if it's a different type.
Could you please open an issue about this?
thanks
Luigi
2014-11-03
Hi,
this could be related to this
https://github.com/orientechnologies/orientdb/issues/2845
I'm working to fix it
Luigi
2014-11-03 13:37 GMT+01:00 MrFT frederik.til...@vsko.be:
I used the laest SNAPSHOT
orientdb-community-2.0-20141031.225603-341-distribution.zip
it though.
Am I missing something in the release 2 M2 version ?
Also, are you planning to have a backup to file system ( not snapshot) and
without blocking writes in a future release ?
Regards,
Santosh
On Wednesday, October 29, 2014 4:02:06 AM UTC-7, Luigi Dell'Aquila wrote:
Hi Santosh
Hi Frederik,
this kind of issues is related to some legacy code in current query parser
implementation. We are completely rewriting it, so it will be fixed in 2.1.
If you want you can open an issue about this, I'll take care of it.
About third query, I tried it in Studio with a fresh
Hi Stefan,
I think this can help you
http://www.orientechnologies.com/docs/last/orientdb.wiki/Graph-Database-Tinkerpop.html#ordered-edges
Luigi
2014-11-05 10:35 GMT+01:00 ste...@activitystream.com:
bump ... again
On Tuesday, 4 November 2014 08:10:37 UTC, ste...@activitystream.com wrote:
Hi Kristoffer,
Invoking server side functions from inside other functions should be
straightforward.
Could you post some of your code? Maybe we can help you better that way.
Luigi
2014-11-06 13:06 GMT+01:00 BojanV bboojja...@gmail.com:
Did you try with sql batch?
:10 UTC+1 torsdag 6. november 2014 skrev Luigi Dell'Aquila
følgende:
Hi Kristoffer,
Of course you can use this approach, this is not bad practice in general,
but sometimes you can find easier solutions to do that.
Here are a couple of examples, they all work fine for me.
I hope you can find
Hi Mark,
one or two years ago I tested OrientDB on Raspberry PI and it worked fine
(of course the performance was not the same as on my laptop, but it was
more than acceptable). At that time I used Java8 alpha for ARM and that
gave me very good results.
If what you are interested in is a time
Hi,
the best thing to do this should be something like this:
update myClass set columnB = columnA.split(,)
but unfortunately it's NOT supported at this time.
As a work around, you can define your own split() function like this
- two parameters: inputString and separator
- this function body:
Hi Jan,
in this use case you will not have big advantage from typical NoSQL
features like index free adjacency (that means fast traversal) or dynamic
schema management. You are actually using OrientDB as a relational db.
Anyway performance you are having is definitely too slow!
I suggest you to
ah, for cases where you know that you don't need range queries I suggest
you to use OClass.INDEX_TYPE.NOTUNIQUE_HASH_INDEX, it's much much faster!
Luigi
2014-11-14 10:04 GMT+01:00 Luigi Dell'Aquila luigi.dellaqu...@gmail.com:
Hi Jan,
in this use case you will not have big advantage from
Hi Charles,
at this moment there is no built-in procedure to encrypt root password,
anyway IMHO this problem can be bypassed with some simple modifications.
The real problem is another one: the DB files are not encrypted in any way,
so if your customer copies the orient/databases/ directory on
Hi Luca,
this is clearly a bug, could you please report it in OrientDB issue
tracker?
https://github.com/orientechnologies/orientdb/issues
We will fix it ASAP
thanks
Luigi
2014-11-24 18:32 GMT+01:00 l...@emaxsrl.com:
Hello,
I'm using OrientDB version : 2.0-M3.
I created a test function
Hi Simon,
you can do something like this
select set($comments[0], $comments[1], $comments[2]) from SOME_POST_ID let
$comments = sort(out('PostHasComment'))
or
but edges are not guaranteed to be sorted, so you have to write your own
sort() function.
If you are using M3 or earlier, function
Thanks a lot
Luigi
2014-11-25 8:25 GMT+01:00 l...@emaxsrl.com:
Done!
https://github.com/orientechnologies/orientdb/issues/3094
Il giorno lunedì 24 novembre 2014 18:52:05 UTC+1, Luigi Dell'Aquila ha
scritto:
Hi Luca,
this is clearly a bug, could you please report it in OrientDB issue
,percentile,median,variance,difference,first]`
On Tuesday, November 25, 2014 3:26:46 AM UTC-5, Luigi Dell'Aquila wrote:
Hi Simon,
you can do something like this
select set($comments[0], $comments[1], $comments[2]) from SOME_POST_ID
let $comments = sort(out('PostHasComment'))
or
but edges
, Luigi Dell'Aquila wrote:
Hi Simon,
my mistake, I was not clear at all, the sort() function is not a built-in
function, my proposal was to implement your own function called sort() in
javascript and use it in the query
Luigi
2014-11-25 16:55 GMT+01:00 Simon L si...@pumpup.co:
Thanks
Hi Stefan,
try to remove parentheses from your query, like this:
insert into GermanyClient from select from Client where country = 'Germany'
current SQL parser implementation sometimes is not so friendly, we are
completely rewriting it and the new one will be released in 2.1
About the fromMap,
Hi Riccardo,
what TinkerPop calls labels is represented by OrientDB classes.
You can create a lightweight edge of a particular class with this syntax:
CREATE EDGE MyLabel FROM #14:1 TO #14:0
Of course the class MyLabel has to exist and has to extend E
If you use the SET labelName = value, the
Hi Stéphane,
I suggest you to wait a few hours, as OrientDB RC1 will be released shortly
Luigi
2014-12-15 17:01 GMT+01:00 Stéphane Schild stephane.sch...@gmail.com:
Hello,
You're right, I should not have supposed that this version was stable.
However, I need to evaluate OrientDB for my
+01:00 Ankit Jain foran...@gmail.com:
we can find out that from jar file..can u tell in which jar it is??
On Monday, 15 December 2014 19:58:44 UTC+5:30, Luigi Dell'Aquila wrote:
Hi,
OServetAdmin is in package com.orientechnologies.orient.client.remote
Apparently all the client package
...?
On Wed, Dec 17, 2014 at 12:25 PM, Ankit Jain foranki...@gmail.com wrote:
ok..
On Wed, Dec 17, 2014 at 12:22 PM, Ankit Jain foranki...@gmail.com
wrote:
ok.
On Wed, Dec 17, 2014 at 12:21 PM, Luigi Dell'Aquila
luigi.dellaqu...@gmail.com wrote:
Hi,
sorry, I saw this email only now
Hi Stéphane,
content is a reserved word in OrientDB SQL syntax, current parser
implementation does not complain about it (while it should), but final
result is unpredictable, like this.
The new parser implementation is more strict and will report an error at
parse time.
Strict query syntax
Hi Sajal,
lightweight edges are still available and the alter database command is
the right way to enable them, so if you are not able to create one maybe
there is an error in your code or an issue in the release.
Could you provide a snippet of code (or better, a test case) to replicate
the
Hi Andrei,
In OrientDB you can use the if() function to do what you need. I just added
it to the documentation, please check this wiki page.
https://github.com/orientechnologies/orientdb/wiki/SQL-Functions
Soon it will also be in the official Docs page
Luigi
2014-12-19 8:51 GMT+01:00 Andrei
to that ? Because from what I can
see, I've done nothing different from Rc1 and RC2 to final1.
On Monday, January 26, 2015 at 12:05:27 PM UTC, Luigi Dell'Aquila wrote:
Hi,
this must be because of disabled lightweight vertices. In Graph Studio
tab only fetched records and their neighbors
Hi Arinath,
if it's just a one-shot batch insert, you can write a simple Java program
and use OGraphBatchInsertBasic class, that is specifically designed for
this simple use case.
Otherwise you could think about using OrientDB ETL and define a simple
importer from CSV, see
Hi,
current implementation of schema manipulation is not so strict, and
especially is not related to already existing data, but only to new
operations. We know this is an issue and we are addressing it, you will
find important changes about this in next releases
Luigi
2015-02-03 18:28
Hi Artem,
have you tried with UPSERT?
Here you can find all the references:
http://www.orientechnologies.com/docs/last/orientdb.wiki/SQL-Update.html
Regards
Luigi
2015-02-04 13:25 GMT+01:00 Artem Shoobovych shybovy...@gmail.com:
Hi there!
Lately, I've been playing with OrientDB of 1.7.10
Hi Andy,
This is a known issue, you can find all the details here:
https://github.com/orientechnologies/orientdb/issues/3203
Luigi
2015-02-05 16:58 GMT+01:00 dakota.pric...@gmail.com:
Hello,
I am unable to create an in MEMORY distributed database due to the
following exception:
Hi Shivanandan,
the easy way to go faster is using plocal instead of remote, but I don't
know if in your case it's possible (other instances OrientDB have to be
shut down for the time ETL works...)
Luigi
2015-02-19 7:19 GMT+01:00 Shivanandan Gupta shivnandangu...@gmail.com:
Hi All,
I tried
, I tried doing a plocal (create a DB as plocal
? ) can you please help me how to go with it? I am a newbei to orientdb.
We are trying to have a data model as DWH like facts and dimensions in
orientdb.
Thanks,
Shivanandan Gupta
On Thursday, 19 February 2015 13:26:58 UTC+5:30, Luigi
2015 14:40:04 UTC+5:30, Luigi Dell'Aquila wrote:
Hi Shivanandan,
you can just replace this
loader: {
orientdb: {
dbURL: remote:localhost/databases/indb,
dbUser: root,
dbPassword: root,
dbAutoCreate: true,
tx: false,
batchCommit: 1,
dbType: graph
Hi Stefan,
there is no explicit support to this (you can open a feature request on the
issue tracker if you want), but there is a work-around to obtain this
information:
OrientVertex v = ...
ODocument doc = v.getRecord();
String fieldNames = doc.fieldNames();
ListString edgeClassNames = new
Hi George,
link traversal is O(1) operation because the RID is like a physical pointer
to data. Using UUID would mean relying on an index to find the RID
corresponding to the UUID.
SBTree index you will give you O(logN) performance.
HashIndex will give you a near O(1) performance in the average
Hi Georg,
in current implementation it's not possible. Anyway Dijkstra and
ShortestPath functions are quite simple (links to the source code below),
you could just implement your own version starting from them and (why not?)
send a pull request and become OrientDB contributor.
by Luca,
http://stackoverflow.com/questions/22606111/orientdb-problems-with-clusters-concept.
I thought I might be missing out something.
On Wednesday, February 11, 2015 at 5:42:27 PM UTC+8, Luigi Dell'Aquila
wrote:
Hi Goh,
That post is really misleading...
In OrientDB you can define multiple
Hi Renzo,
the first query should be something like
select expand(inE('owner')[color ='red'].outV()) from car where name =
'Ferrari'
The second one is just
select out.name as ownerName, color, in.name as carName from owner
Luigi
2015-02-10 22:08 GMT+01:00 Renzo Ludeña
Hi Goh,
That post is really misleading...
In OrientDB you can define multiple clusters per class, and all the
sharding architecture is based on that. To have a better idea of this I
suggest you to check the following links
the first path ? It seems like
a bit of a hack, don't you think ? :(
I'm using OrientDB 2.0.1 BTW.
Thanks !
On Tuesday, February 10, 2015 at 8:53:58 AM UTC+1, Luigi Dell'Aquila wrote:
Hi Georg,
in current implementation it's not possible. Anyway Dijkstra and
ShortestPath functions
TO MAKE IT PERFECT!!!
Thanks
Luigi
--
Luigi Dell'Aquila
Orient Technologies LTD
--
---
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
Hi,
with current version (as Keith said) schema-defined fields are more compact
in terms of disk space. In next releases you will also have additional
advantages in terms of query speed.
But the most significant difference is that defining properties you can
- enforce constraints on fields (min,
V and E? Are there special powers associated with V
and E that I would lose in such a case?
Thanks very much!
Patrick
On Tuesday, March 17, 2015 at 9:50:35 AM UTC-6, Luigi Dell'Aquila wrote:
Hi Rob,
if your class extends ORestricted, the owner is tracked in one of the
following fields
to implement hierarchical access to data so that field has more
than just the owner. It has the owner and all of the owner's parents so
not an easy way to determine which in fact is the owner of the data. Any
other way I can get the owner?
On Tuesday, March 17, 2015 at 8:50:35 AM UTC-7, Luigi
Hi Vadim,
I don't know how many items you expect in your db, but I think your data
representation could take you to very expensive queries...
I suggest you to take a look at this, maybe you can pick some ideas
http://www.slideshare.net/LuigiDellAquila/orientdb-time-representation
Luigi
Hi Rob,
if your class extends ORestricted, the owner is tracked in one of the
following fields:
_allow
_allowRead
_allowUpdate
_allowDelete
2015-03-17 16:39 GMT+01:00 Rob Gratz gratz@gmail.com:
Is there a way to obtain which user created or owns a record?
--
---
You received this
Hi Alexander,
AFAIK you cannot create a full distribution from maven repositories.
If you want a particular Git branch or tag, I suggest you to clone it
locally (see https://github.com/orientechnologies/orientdb ) and then
launch
ant clean install
you will have a full distribution in
Hi Jeffrey,
I think you looked at this:
http://www.orientechnologies.com/docs/last/orientdb.wiki/Lightweight-Edges.html
In terms of performance lightweight edges are better, but they are harder
to manage because:
- you cannot refer a lightweight edge by its RID (a lightweight edge is not
a
Hi Joao,
it depends on how your source data are represented. If you have sequential
integer/long keys for vertexes, you can use OGraphBatchInsert class
Luigi
2015-03-13 10:30 GMT+01:00 Vitor Enes Duarte vitorenesdua...@gmail.com:
graph.declareIntent(new OIntentMassiveInsert());
// inserts
Exactly
2015-03-12 18:03 GMT+01:00 Jeffrey Auguste mrjaugu...@gmail.com:
Ah, so I can create an edge class extended from E and it will still be
lightweight, Its when/if I add link properties to it, that it will then
become an edge document.
On Thu, Mar 12, 2015 at 12:57 PM, Luigi
Yes, it's right, you can turn lightweight edges on in any moment.
Actually to create a regular edge (instead of lightweight), defining a
class for it is not enough, you just have to explicitly add a property to
that.
Luigi
2015-03-12 17:55 GMT+01:00 Jeffrey Auguste mrjaugu...@gmail.com:
So it
Hi Aaron,
TinkerPop Blueprints considers id as a reserved property name, so you
cannot use it, unless you disable standard constraints (exactly what you
did!)
Luigi
2015-03-12 21:45 GMT+01:00 Aaron Gooch eodgo...@gmail.com:
I was able to get around this issue by setting
Hi guys,
we have an open issue about this
https://github.com/orientechnologies/orientdb/issues/2081
A work-around is to do a massive update on V class immediately after edge
rename, eg.
update V set out_NewEdgeClassName = out_OldEdgeClassName
update V remove out_OldEdgeClassName
update V set
is a
class exists (using SQL)?
Thanks,
Patrick
On Monday, March 23, 2015 at 1:31:49 AM UTC-6, Luigi Dell'Aquila wrote:
Hi
Upsert is just a keyword in the UPDATE statement, eg.
update V set id = '12', name = 'foo' upsert where id = '12'
you can find all the docs here http
Hi Fabio,
OrientDB Studio is open source, you can find source code here:
https://github.com/orientechnologies/orientdb-studio
It would be great if you could improve the standard behavior and become an
OrientDB contributor!
Regards
Luigi
2015-03-25 14:34 GMT+01:00 Fábio Costa
at 11:52:32 AM UTC-4, Luigi Dell'Aquila wrote:
Hi Fabio,
OrientDB Studio is open source, you can find source code here:
https://github.com/orientechnologies/orientdb-studio
It would be great if you could improve the standard behavior and become
an OrientDB contributor!
Regards
Luigi
2015
Hi
in OrientDB you can obtain schema information with
select expand(classes) from metadata:schema
or from java API with db.getMetadata().getSchema() and this will give you
all the information about classes, properties and indexes
You can also add custom metadata to classes and properties using
Hi Stefan,
could you give us additional information about this machine? eg operating
system, JVM version
Thanks
Luigi
2015-03-20 22:36 GMT+01:00 ste...@activitystream.com:
Hi,
We are seeing the strangest thing here.
We have an embedded orentdb (2.0.5 / plocal) that create a new database
should have been an RTFM question :)
On Wednesday, April 1, 2015 at 7:52:10 AM UTC-4, Luigi Dell'Aquila wrote:
Hi Cameron
Studio at this time does not have an internal structure for plugins and
there are no plans for that, but you know, many decisions come from
community needs, so if it's
Hi Raffaela,
at this time the only section about security is chapter 5. We are enriching
the documentation every day, with a continuous and iterative work, so if
you have any suggestions about what you want to see covered, we will be
happy to take them into consideration
Thanks
Luigi
in
github for this?
Thanks,
Jamie
On Monday, March 2, 2015 at 4:55:51 PM UTC, Luigi Dell'Aquila wrote:
Hi Jamie,
this is a known issue, we are working hard on the new query parser and
executor and one of the main goals of all this is query optimization.
Thanks
Luigi
2015-03-02 17:11
Hi Jamie,
this is a known issue, we are working hard on the new query parser and
executor and one of the main goals of all this is query optimization.
Thanks
Luigi
2015-03-02 17:11 GMT+01:00 Jamie Blair jamie.bl...@gmail.com:
The following query returns a set of `@rid` and completes in
Hi Mate,
there are no limitations in the number of properties that can be indexed,
so there must be a bug somewhere.
Could you provide a test case to reproduce it?
Thanks
Luigi
2015-03-04 22:25 GMT+01:00 Máté Gábri gabrim...@gmail.com:
Hi,
I'm trying to get familiar with OrientDB's
Hi Kiheung,
answers below:
2015-03-02 23:39 GMT+01:00 Kiheung Park kihpar...@gmail.com:
Hi Colin,
Question 1:
You'll just embed another document (or vertex) in the contact property.
Are you trying to do this from the Java API?
-- Yes or no. I was trying to modeling through studio. If Java
Hi,
you can use CONTAINS instead of = (because in_* and out_* are collections)
I also suggest you to use in() and out() functions, eg.
select in(Owns).userID from items
Luigi
2015-02-25 8:18 GMT+01:00 Dlpnet dlp...@gmail.com:
Hello
I have a simple DB:
users -- Owns -- items
when I
15:55 GMT+01:00 Luigi Dell'Aquila luigi.dellaqu...@gmail.com:
Hi Julian,
first of all let's make your query work, this is the right one:
select from FOrder where user IN (select @rid from FUser where userId =
642255)
Please note that I used IN operator instead of = because a query returns
for testing, or
some test data with the query and index I'm using?
Best regards,
Mate
On Thursday, March 5, 2015 at 10:51:26 AM UTC+1, Luigi Dell'Aquila wrote:
Hi Mate,
there are no limitations in the number of properties that can be indexed,
so there must be a bug somewhere.
Could you
Hi Kun,
the answer to your question is no, in a single cluster you will find only
instances of a single class (that are also instances of its superclasses of
course).
Luigi
2015-03-25 22:35 GMT+01:00 Kun Liu liukunofc...@gmail.com:
Hi All,
I am new to OrientDB and learning it now. I wonder
Hi David,
you can just let V and E extend OTriggered, or define your hooks in Java if
you want to avoid it.
Regards
Luigi
2015-03-26 0:40 GMT+01:00 David Carr dcarr...@gmail.com:
After a bit of trial and error, I have been able to get hooks working on
custom classes extended from the
IMHO it's merely a bug, edge creation should check that both ends are
vertices
Luigi
2015-03-26 13:12 GMT+01:00 MrFT frederik.til...@vsko.be:
http://stackoverflow.com/questions/28781749/am-i-supposed-to-be-able-to-create-edges-between-two-edges-and-or-an-edge-and-a
Am I supposed to be
; }
public double Height { get; set; }
public DateTime DateOfBirth { get; set; }
public decimal Salary { get; set; }
}
On Friday, January 30, 2015 at 5:31:29 PM UTC+8, Luigi Dell'Aquila wrote:
Hi Siang,
all hash indexes do not support range queries (they are based on hash
Hi Oleg,
do you mean that you are adding properties to the schema or that you are
adding property values to existing vertexes?
What I suggest you is:
- create schema with properties before the insert operations (this will
save space on the disk because property names are not stored in the record
have any suggestion?
Thanks.
On Friday, January 30, 2015 at 4:43:25 PM UTC+8, Luigi Dell'Aquila wrote:
Hi Siang,
which kind of index did you define? Not all types of index support range
queries
Luigi
2015-01-30 9:05 GMT+01:00 Siang Hwee Goh gohsia...@gmail.com:
I am evaluating
Of course I meant use plocal instead of remoTe
Just a typo ;-)
Luigi
2015-01-30 11:29 GMT+01:00 Luigi Dell'Aquila luigi.dellaqu...@gmail.com:
Hi Oleg,
do you mean that you are adding properties to the schema or that you are
adding property values to existing vertexes?
What I suggest you
Hi Florin,
null is a valid value for a property, so setting it to null just leaves it
there, in the document.
If you want to completely remove a property you have to use this statement:
update MyClass remote myPropertyName where...
regards
Luigi
2015-01-30 1:09 GMT+01:00 florin
Hi Siang,
which kind of index did you define? Not all types of index support range
queries
Luigi
2015-01-30 9:05 GMT+01:00 Siang Hwee Goh gohsiangh...@gmail.com:
I am evaluating OrientDB right now and I tried to inserts 1.2 million
simple records inside one of the database. It is an
oh, sorry, I saw only now that I wrote remote instead of remove ;-)
anyway you got the point :)
Luigi
2015-01-30 12:49 GMT+01:00 florin flo...@wisemart.com:
Thanks!
On Friday, January 30, 2015 at 2:29:21 AM UTC-5, Luigi Dell'Aquila wrote:
Hi Florin,
null is a valid value for a property
Hi Oleg,
it seems to be ok, the throughput depends a lot on the size of single
documents, on the number and type of indexes you use (I can say that Lucene
indexes demonstrated to have the best performance in insert) and on the
type of connection you are using (plocal or remote).
1M per minute
Hi,
I already answered in your previous email ;-)
2015-03-22 0:44 GMT+01:00 pumplerod pumple...@gmail.com:
I'm sorry, I thought I was in the pyorient group. Though perhaps someone
here can answer the question.
On Saturday, March 21, 2015 at 6:43:21 PM UTC-5, pumplerod wrote:
is there
for command request:
sql.upsert
On Wednesday, February 4, 2015 at 9:08:04 AM UTC-6, Luigi Dell'Aquila
wrote:
Hi Artem,
have you tried with UPSERT?
Here you can find all the references:
http://www.orientechnologies.com/docs/last/orientdb.wiki/SQL-Update.html
Regards
Luigi
2015-02-04 13
Hi Stas,
you could implement a hook for this. You can do this in Java or Javascript
(see http://www.orientechnologies.com/docs/last/Hook.html ), just ensure to
* bind your application logic on the following events: onBeforeCreate,
onBeforeUpdate
* let your hook functions return RECORD_CHANGED
Hi Valeri,
composed indexes in some cases can be used also in basic queries, eg. if
you have an index defined on properties A, B and C, the following will use
the index too:
select from Foo where A = 1
It is only true if the fields in the query are a prefix of the index
itself (eg. properties
Hi Caleb,
which API are you using?
You can get this result just with a SELECT FROM a FETCHPLAN *:-1
2015-04-19 12:07 GMT+02:00 cloveret...@gmail.com:
Hi all,
Suppose that I have a tree like this:
- d
|
- b
||
a--- - e
|
- c - f
Hi Mahesh,
I will give you two examples, one with documents and links and the other
with vertices and edges.
Ex1:
You have a class Person with a link property father that points to
another person
you can do
traverse father from (select from Person where name = 'Bill') while $depth
3
you will
1 - 100 of 618 matches
Mail list logo