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.
