I have cut the database down to just one day of logs, the logs are all stored against today (02/10/2015)
The database schema looks like... years -> months -> days -> hours -> minutes -> logs My use case is to first count and then (potentially) return all the logs for a given *month *for a given *device*. To do this I was hoping I could multithread a query like: select from (SELECT expand (log) FROM (TRAVERSE minute FROM (TRAVERSE hour FROM (select expand(month[9].day[29]) from year where label = '2015')))) where device = "VB7948" over each day of the month (via java API) and get a result fairly quickly. I am not expecting miracles (I realise there is a lot of data!) but to match my RDBMS I was thinking I might at least be able to get a count in under a minute.... -- --- 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.
