Hi Steve, queries like that are very common, I'd say all of our customers use them on millions (sometimes billions) of records. Here you can see the list of some of our customers http://orientdb.com/customers/ (not all, the biggest ones often have NDAs with us, so we cannot publish their logo).
Of course you will need an index on your properties to perform fast. OrientDB supports three types of indexes: - SBTree: a particular implementation of a balanced tree, a good trade off between read/write performance and flexibility - HashIndex: not based on a tree, but on a hash of indexed keys, it's faster on read operations but it does not support range queries - Lucene: the well known full-text indexing engine Also consider that if your numbers scale up (from hundred to hundred thousands or millions of users) you can scale horizontally with a multi-master replica configuration. Thanks Luigi 2015-06-18 19:54 GMT+02:00 Steve Hutchins <[email protected]>: > Hi, I'm looking at moving an SQL database of several million customer > records (name, addresses, purchases) to a graph DB. > > Can OrientDB (if configured correctly - classes/clusters/cluster etc) > perform fast enough to respond to several hundred users querying data > (mostly in read only mode)? > > Most queries will not involve generating graph data, but simple queries > such as: > 1) select * from Address where street = '' and city = '' and zip = '' > 2) select * from Name where firstname = '' and lastname = '' > 3) select * from Orders where customerid = ? > > Are there any examples of organizations who are doing this? > Thanks > Steve > > -- > > --- > 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. > -- --- 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.
