.net - Code vs Database - Sequence of Steps, Call Database or Check Session Object? -


I have several web sequential pages that will modify a record and its child's record in the database will be called "project" .

There is some special information in a project, and it consists of one or more tasks, each of which has specific information.

Is it possible to be able to query the same project (and its functions) every time to hit the database (either, more efficiently or more easily) I ask once (either to save once or session for each page or all pages) and check the saved object instead of the database?

Note that I'm asking about checking the data, not saving it (I can still press the database every time I have to save something, obviously).

Enter the database ID in the session and rest the database. Is there a web server on the database and on the same server, if that is the database will cache those results and still return that data very fast?

I'm thinking of a simple site, if you talk about Twitter / Facebook Scale, you have got a lot to worry about, where to store your data is.

Two thoughts:

  1. As @RonaldWidh said, use Ajax. This will allow you to kill that database for your data, while you do not like it :)
  2. Check it out and try it out, press the database 1000 times for the details of the project, and your own Get stopwatch out.

Often such questions depend on such variables that it is difficult to answer directly. If you have a lot of data, a project with 10,000 projects, then it's a bad idea to store well in the session. If you are just asking about the database ID and the name of the project, then OK, I would say store it in session.


Comments

Popular posts from this blog

Eclipse CDT variable colors in editor -

AJAX doesn't send POST query -

wpf - Custom Message Box Advice -