Last post Jul 25, 2016 02:53 AM by Lannie
Jul 23, 2016 05:23 PM|softech.employee|LINK
I am developing an application in mvc and mongodb.
I want to make joins now.
If there are some sale orders and each sale order have some products then how can i see the statistics of all my issuance of some product in mongodb ?
Jul 23, 2016 11:07 PM|Lannie|LINK
Jul 24, 2016 08:48 AM|softech.employee|LINK
thanks . can you guide about performance.?
and how 'll i get the most issued product ?
will i have to loop through it or can be get from join ?
If join then will it slower down or not ?
Jul 25, 2016 02:53 AM|Lannie|LINK
generally if the parent table has primary key that is indexed and the child table has primary key that is indexed and the foreign key that is indexed, performance should be the best the database system (hardware, software) can provide.
I am not familiar with MongoDB and its ability to optimize query performance like Oracle and MSSQL do for you in the background.
The join avoids the need to loop as the join becomes like a single virtual table that you extract into your display environment.
Joins are faster than looping through the child table programmatically looking for matches.