Hi, I am evaluating OrientDB for use in our product to see if our specific requirements fit the performance of OrientDB.
In general we have tables with potential quite a lot record with per row possibly a few relations to other records in another class, which can have relations to another class etc. Simply put a classical SQL style table, but customizable by our users, so we cannot exactly predict how the structure will be, be we have some ideas. For now I have created a class ARTICLE, SUPP and COUNTRY. Goal is to find articles with a supplier from a specific country. The query I used was very fast (nice!): select * from ARTICLE where out_ARTICLE_SUPP_NR.out_SUPP_COUNTRY._id = 'GB' ... 20 item(s) found. Query executed in 0.14 sec(s). But when I want the total count (which I need to calculated the number of pages for this query), the count is very slow: select count(*) from article where out_ARTICLE_SUPP_NR.out_SUPP_COUNTRY._id = 'GB' ... 1 item(s) found. Query executed in 4.084 sec(s). Our article table has approx 90000 records, suppliers have 528 and countries has 9. I have not yet created any indexes. Is there a way to speed up the count query? Regards, Wouter -- --- 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.
