That's works if we need to insert records in single table, but if we want to records in different table (like the case I have described in my post).
How can we do that in single query?? On Monday, March 10, 2014 8:28:57 AM UTC+5:30, Lvc@ wrote: > > Hi Gaurav, > you could group inserts in one call like this: > > insert into xxx (x,y) values (1,2) (2,3) (3,4) > > This will insert 3 records. > > Lvc@ > > > > On 10 March 2014 01:32, Gaurav Dhiman <[email protected] > <javascript:>>wrote: > >> Andray, can you suggest how to do multiple inserts / updates in single >> SQL, considering the case of document DB that Mitul Golakiya presented. >> It will help me and other members on community to best utilize the power >> of OrientDB. >> >> Regards, >> Gaurav >> >> >> >> On Friday, March 7, 2014 9:28:01 PM UTC+5:30, Mitul Golakiya wrote: >>> >>> We are using Document Type database. >>> >>> I had sent one mail with my current schema of MongoDB and OrientDB to >>> your external gmail email address which I got from Github. >>> >>> Please check and can you suggest how can I do that ?? >>> >>> On Friday, March 7, 2014 5:24:18 PM UTC+5:30, Andrey Lomakin wrote: >>>> >>>> Hi, >>>> You do not need to insert them as separate insertions. >>>> Just create all objects at once and store root document everything will >>>> be stored and links will be updated automatically. >>>> >>>> Also with what kind of database do you work graph of document ? >>>> if you use document database usage of LINKSET is OK. >>>> >>>> If you work with graph database you should connect vertexes through >>>> edges. >>>> Also you should do it in single tx to avoid data consistency problems >>>> in case if you will have errors during insertions. >>>> >>>> Our users report that insertion speed is at least 1500 rec/s (2/3 ms >>>> for single record) so insertion of 5 records for a second (it should be >>>> about 5 ms for such small amount of data) is indication that something is >>>> really wrong. >>>> Could you send me example of database and code which you use to import >>>> data ? >>>> >>>> -- >>>> Best regards, >>>> Andrey Lomakin. >>>> >>>> Orient Technologies >>>> the Company behind OrientDB >>>> >>>> -- >> >> --- >> 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] <javascript:>. >> 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.
