Download C # Source CodeOnly a developer would know the absolute joy of moving a heavily database centric desktop application to a web environment. Can you smell the sarcasm? Aside from storing data in cache, session, or static objects there is no storage place in memory for us to put data for fast access and hold onto it until the user closes the application the same way a desktop application can. Thus, we end up having to run expensive queries to retrieve meta data (information stored in our database that helps describe our data ) Each Time The page load to itself. Welln't it be nice to store information somewhere so we don't have to run the Same Query Again on page post back? this nice to have feature HAS really become a bit of a necessity for a rather complex project our team has been working on that is a little bit out of the norm. Let me briefly summarize the requirements of our data entry pages. The entire data entry page is database drive n and in many cases this includes user specific settings for each data entry point. A typical page might have 40 or so dynamically generated data entry points. A wide variety of settings or meta data exists for each data entry point that range from display oriented settings Server Side Calculation Settings, RELATIONAL POINTS, AND Settings Determining How When To Save The Data. As You Can See, This Can Get Rather Complicated.Let '
s also review the application environment. A typical user analysis model would consist of around a 100 of these data entry pages. The Web site itself supports an unlimited number of analysis models. Thus, the database is quite large and the process of obtaining the meta .. data is quite complex Running more queries than absolutely necessary can be a real drag on performance Also keep in mind that a typical user will spend anywhere from 15 - 45 minutes on a single data entry page completing that section of the analysis model.Before trying to implement the ViewState solution described below, I looked into utilizing session, static objects, and the application cache. Each of these had their pros and cons as it applied to our specific situation. I opted for this solution but it is important to note That if Your Requirements Aren't Quite As Complex and Particular, The Meta Data IS Fairly Static, The Meta Data IS Fairly Static, Then I'd Look Towards Loading It Up in A Static Object Or Use The Cache. The Viewstat e solution I've come up with is strictly for those times when you need to attach additional properties to controls and maintain the state of the control and the state of the extended properties together. In other words, I've opted to show you that this can be done. It does not mean that you always should. The performance impact of having larger than normal ViewState and the process of managing ViewState is not necessarily prohibitive but if you are trying to squeeze out every once of performance, doing this WITHOUT IT Being Necessary Could Hurt Your Cause.new Message Board Posts
The Question of Full-Text Indexhow To Compare 2 Timings? DTS - Execute Sql Taskauthenticate Using Adsi And Give Access To FileSdisplay A Graph in A Tooltip
