Oral  Brekke

Oral Brekke

1615469280

MongoDB/Mongoose Schema Optimisation

In this article, I’m gonna go over three things to consider when creating Mongoose schemas to improve the performance of your app’s queries.

1. Embed vs Reference

Deciding the schema will have significant conquences on the app performance because it affects the queries we can make. Personally, coming from an SQL background I’m used to having relations between objects.

For example, a dog belongs to a human and we can establish this using a foreign key.

Mongoose offers something similar in the form of ‘references’. But, just because it’s there doesn’t mean it should be used and abused.

For example, let’s say you have an app that shows a user’s details. Here are two possible ways you can represent the schema:

Image for post

#javascript #mongoose #mongodb #nodejs

What is GEEK

Buddha Community

MongoDB/Mongoose Schema Optimisation
Brain  Crist

Brain Crist

1600347600

SCHEMAS in SQL Server -MS SQL Server – Zero to Hero Query Master

Introduction

This is part 3 of “MS SQL Server- Zero to Hero” and in this article, we will be discussing about the SCHEMAS in SQL SERVER. Before getting into this article, please consider to visit previous articles in this series from below,

A glimpse of previous articles
Part 1

In part one, we learned the basics of data, database, database management system, and types of DBMS and SQL.

Part 2
  • We learned to create a database and maintain it using SQL statements.
  • Best practice methods were also mentioned.

#sql server #benefits of schemas #create schema in sql #database schemas #how to create schema in sql server #schemas #schemas in sql server #sql server schemas #what is schema in sql server

Query of MongoDB | MongoDB Command | MongoDB | Asp.Net Core Mvc

https://youtu.be/FwUobnB5pv8

#mongodb tutorial #mongodb tutorial for beginners #mongodb database #mongodb with c# #mongodb with asp.net core #mongodb

Install MongoDB Database | MongoDB | Asp.Net Core Mvc

#MongoDB
#Aspdotnetexplorer

https://youtu.be/cnwNWzcw3NM

#mongodb #mongodb database #mongodb with c# #mongodb with asp.net core #mongodb tutorial for beginners #mongodb tutorial

Insert & Save method in MongoDB | Inserting Document | CRUD Operation in MongoDB

#MongoDB
#AspDotNetExplorer
https://youtu.be/CohnNdE_rjM

#mongodb #mongodb tutorial for beginners #mongodb tutorial #mongodb database #learn mongodb

Execute MongoDB Command | Create, Drop and Select Database | MongoDB | Asp.Net Core Mvc

https://youtu.be/SKpNG83X2Ig

#mongodb #mongodb with asp.net core #mongodb with c# #mongodb tutorial for beginners #mongodb tutorial #learn mognodb