Hi Aris,
About q1, you can have a class
{
@class: "ChatRoom",
id: 23,
participants: [
#23:34433,
#23:945954,
#23:80595,
]
}
If you index ChatRoom.participants (not unique - hash) you can execute:
SELECT FROM ChatRoom WHERE participants IN #23:945954
About embedding documents, usually doesn't scale with big numbers.
Lvc@
On 15 April 2015 at 09:44, Aris Alexis <[email protected]> wrote:
>
> OK I can answer
>
> q.2 because I did not realise that nested documents are LINKS and not
> actually the same file.correct?
>
> the q.3 I can do a select from the document to fetch the first 20 LINKs
> with an expand select correct?
>
> q.1?
>
>
> On Wednesday, April 15, 2015 at 12:29:03 AM UTC+2, Aris Alexis wrote:
>
>> Hi, I am reforming a previous question I had.
>>
>> If I have a chat between users as a document:
>>
>> can I have these:
>>
>> 1)index on a List<String> (without lucene just checking if a user is
>> participating in a chat)
>>
>> 2)nested messages (many probably in the thousands) as nested documents.
>> Are these going to cause fragmentation like in MongoDb where you need to
>> know upfront the approximate number of nested documents?
>>
>> 3)can I retrieve the chat document with a Limit clause on the number of
>> nested documents (messages)?
>>
>> thank you
>>
>> --
>
> ---
> 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 [email protected].
> For more options, visit https://groups.google.com/d/optout.
>
--
Best Regards,
Luca Garulli
CEO at Orient Technologies LTD
the Company behind OrientDB
http://about.me/luca.garulli
--
---
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
