How to best avoid checking user data (payments, license status) on every action every single time?

asp.net-mvc entity-framework-6

Question

When a user logs in to our website, there are some things we wish to check:

  • Did they verify their e-mail address yet?
  • Do they currently have a license with us, or is their license expired and do they need to obtain a new one?
  • If they have a license, and it's a paid license, have they paid in time?
  • Did they accept the latest terms of service?
  • Are there things they still have to configure in their user account? (For example, first time configuration of the application to suit their needs.)

Now, currently, it's a rather dumb implementation. At first, all of this was checked on every page. Rather expensive, so now only on the critical pages. Multiple trips to the database, etc etc...

In profiling, I found that the most time is spent here. So I want to speed this up. So far, I see two options:

  1. Add a couple of columns to the user table, namely LastCheckedOpenTasksTimeStamp and LastOpenTask and ForceReCheck. Downside: Anytime anything happens in the application that is related to such a task (e.g. paying) we have to set ForceReCheck or some other invalidation mechanism. Seems prone to errors to me.

  2. Some kind of database view that computes what needs to be done. But this is very low level for something that is essentially business logic.

I'm sure there must be a better way that I'm not seeing. What may be better alternatives to do this?

1
0
2/13/2019 4:21:48 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Use a session.

Person logs in, you hit the DB one time and set:

Session["emailVerified"] = checkEmailVerified();
Session["licenseType"] = getLicenseType();
Session["expirationDate"] = getSubExpDate();
// etc.

Then when the person performs any action, you can reference the session instead of making more round trips to the database.

You can go back to the DB if any of the session variables don't evaluate the way you want them to.

I specifically would not use Cache because your data is tied to the user, for each person who is logging in. Fuller explanation here, but the most important bit is:

The first main difference between session and caching is: a session is per-user based but caching is not per-user based, So what does that mean? Session data is stored at the user level but caching data is stored at the application level and shared by all the users.

0
2/14/2019 9:50:14 PM

Popular Answer

You can use Cache for this kind of info. You retrieve it from database, and you invalidate that cache once you update any of their fields.

And the logic to retrive that will see if the cache variable is null, you recalculate it.

Here you can see several approaches, depending in what robust or extensible you want it to be: How to cache data in a MVC application

Romias

Related Questions

Entity Framework tracks every data update.

Thanks for pointing me in the right direction. However, in my case, I also need to set the context info when doing select statements, because I am querying views that use the context info to control row-level security by user....I found it easiest to attach to the StateChanged event of the connection and just watch for the change from not-open to ...
entity-framework logging
asked by Matt Johnson-Pint

Foreach loop through table seems to load every row and run out of memory

I haven't tested it, but try ...foreach (Quote L in context.Quotes.AsNoTracking()) {...}.... ....AsNoTracking()... should not put entities in cache so I assume they will be consumed by GC when they out of the scope....Alternative way would be to implement batch processing (select top N entities, process, select next top N). In this case make sure t...
entity-framework entity-framework-6 entity-framework-6.1
asked by Vadim K.

How do I refresh a partial view every 3 seconds in MVC 4?

I think you need to make some changes to your ajax call. Here is an example of how I do the call...$.ajax({ url: '@Url.Action("Action", "Controller")', type: 'post', cache: false, async: true, data: { id: "frmUser" }, success: function(result){ $('.divPartial').html(result); } }); ...on your controller I don't ...
asp.net-mvc-4 asp.net-mvc-partialview entity-framework-6 progress-bar timer
asked by Matt Bodily

Emit DbContext.OnModelCreating on every context creation

There is a built-in feature which may address your issue : `IDbModelCacheKey ; the implementation of which is to be registered in your configuration. The point is to generate a different key for your different contexts....I would go for something like :...First, the configuration...public class EntityFrameworkConfiguration: DbConfiguration { pu...
c# entity-framework entity-framework-6
asked by jbl

Entity framework very slow to load for first time after every compilation

With EF Core, you can cheat and load the model early after you call ...services.AddDbContext... (you can probably do something similar with EF6 too, but I haven't tested it)....services.AddDbContext<MyDbContext>(options => ...); var options = services.BuildServiceProvider() .GetRequiredService<DbContextOptions<MyDbContext>>();...
c# entity-framework sql-server
asked by Yepeekai

How to force fire OnModelCreating every DataContext initialized up

ta.speot.is is right that OnModelCreating fires only once because modelBuilder is cached. There are several cases when OnModelCreating is required to execute again. For example when multi-tenancy is implemented across sessions then one may require to fire OnModelCreating again. ...When modelBuilder is created first time, then EF caches it to incre...
.net-framework-version c# entity-framework-6 unit-of-work
asked by Manpreet Singh Dhillon

Entity Framework's auto generated class's code gets re generated every time model is updated

You are using the ...MetadataTypeAttribute... wrong. You should create a seperate class for the annotations....I do it with a private inner class for example:...[MetadataType(typeof(Table1MetaData))] public partial class Table1 { private class Table1MetaData { [MaxLength(20)] public string Foo { get; set; } } } ...Import...
asp.net-mvc c# entity-framework entity-framework-6 sql-server
asked by Christian Gollhardt

Should I create new table for every consistent data set or one systemCodes table?

I think For Status and Type - better you create StatusMaster and TypeMaster resp....StatusMaster (StatusID)0 - Available 1 - Busy 2- Unavailable and Use StatusID in Agent Table same you can create for TypeMaster. and for Gender you can directly use 'M' and 'F' or 'Male' and 'Female' as it is in Agent table....Hope this will help y...
asp.net-mvc entity-framework entity-framework-6 sql-server
asked by user10340688

Why does context.SaveChanges() update every row in the table?

As suggested in ...official EF6 GitHub...,...Removing the MapToStoredProcedure in my DbContext fixes the issue....I would tell you to try removing the "MapToStoredProcedures()" code and see if you get any different result.
.net c# entity-framework-6 mysql visual-studio
asked by Fabio M.

Does IQueryable re-query the database on every access of the object?

In situations like this, what would be the best approach? Using memory or multiple queries?...Use whichever approach results in the most readable code. If having multiple foreach loops makes your code more readable, replace ...IQueryable<SystemOrder> Orders = _ctx.SystemOrder .Where(x => x.ordStatus == 1 && x.rctStatus == 0) .OrderBy(x =...
.net c# entity-framework-6
asked by Brian

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow