Hi,
I made a little benchmark of OrientDB with the following data:
1000 authors
10000 blogs
100000 blogposts
the data made for the bench was loaded in the documents database.
Here's the schema:
author: {
'@class':'Author'
login: string
sex: string // 'f' or 'm'
}
blog: {
'@class':'Blog'
id: string
title: string
}
blogpost: {
'@class':'BlogPost'
id: string
title: string
authorID: string
blogID: string
}
blogpost has a LINK to author and blog.
The query is simple:
'select author.login, count(*) from BlogPost where author.sex = "m"
group by author.login'
but it takes 3.782 seconds to complete on a MacBook air 2013 (SSD and 8Go
of RAM).
In comparison, the triplestore Virtuoso performs the same query in 34ms (!)
on the same machine.
I made some indexes in Author.login (unique) and Author.sex (not unique)
without luck...
Is there any hints to know to make OrientDB faster for aggregation ?
Thanks.
N.
--
---
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/groups/opt_out.
