Hi Eugene, What OrientDB release are you using? How many records do you have in Order class? Is deal_price a link or embedded?
Lvc@ On 31 December 2014 at 05:51, Eugene Kamenev <[email protected]> wrote: > Hi, > > We want to migrate our data from RDBMS to OrientDB to test query speed and > other OrientDB features. But I can't understand how to migrate, what > structure I need to choose in different cases. > > The first try was to use links between documents, but when i queried > migrated data it was really slow. > > The structure I build was like: one Deal has many Deal_Prices. We made a > LINK from Deal to Deal_Prices, and a LINK from Deal_Price to Deal. > > Then, we have Order. Order has many Items. We made LINK from Order to > Items, and from Item to Order. Item is connected to Deal_Price. We create > LINK from Item to Deal_Price, but not the other way. > > We basically ran the same query we use in RDBMS, and OrientDB was quite > slow to be honest. > > select count(*) from Order where items contains(deal_price.price = 0). It > took OrientDB about 30 secs to execute, but MySQL ran it in 5 secs. > > Honestly, we feel like we don't fully understand OrientDB, and how to > approach our problem in OrientDB way. > > Any suggestions would be very helpful. > > 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. > -- --- 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.
