1
Well, I have a question. I am developing a web application that will suit more than one user, however each user has different data recorded in the database, and this volume will be great, since the system is for sales management.
I wonder how it would be for me to make the application bank, put a idUsuario on each item of the bank and do searches filtering through it, or has some form that brings more performance to the application?
Thank you!
1
If most queries performed within the system will involve the user parameter, yes, you will need to parameterize all tables with the Id user, because it is a design requirement of the Entity Framework that is this way.
To help parameterize queries without you having to fill in the user every time, you can use the Nuget package EntityFramework.DynamicFilters.
I can imagine, but I thought a lot about the question that as my user quantity increases, a table of products or sales, which will be the largest in the system, the amount of data in this table, when it comes to bringing only those of a user, won’t slow down the search? I was looking for some way to increase.
One of the forms would be to place additional indexes and to study the plan of the most recurrent consultations. This is done according to the chosen database technology.
Browser other questions tagged c# sql asp.net-mvc database entity-framework
You are not signed in. Login or sign up in order to post.
Is it Entity Framework? MVC is ASP.NET MVC?
– Leonel Sanches da Silva
What I would like to know is more at bank level, but the answer is yes, for the two questions.
– Jonathan Barcela