Re: ASP.Net Caching Questions

Tech-Archive recommends: Fix windows errors by optimizing your registry

On May 29, 9:20 am, KJ <n_o_s_p_a...@xxxxxxxx> wrote:
A serialization option (other than XML) you might consider is binary
serialization (saving an object as a stream of bytes to some medium,
such as a varbinary SQL Server column). Check out the topic "basic
serialization" in msdn.

As stated, the lookups have to be as fast as possible, so the idea is
to have all the information in memory so that the lookups are
instant. Loading the information from a file or sql column will not
perform nearly as well.

One thing I thought of: What if for some reason the aspnet or iis
process tanks and has to restart? What would happen to your
application (I imagine that such an application would require serious
ramp-up time to load all the data)?

Yes, there would be ramp up time. This is an expected and acceptable
condition, so long as the application performs well when it's running.

SQL Server is built to withstand
these kinds of events, and a properly designed and optimized SQL
database will perform comparably to using Cache.

With all due respect, what are you basing this on? Have you ever
tested this? Lookup up information in cache is many, many times
faster than querying a database for it.

I appreciate your taking the time to respond, but I need to find
answers to my specific questions before I start looking at alternate
solutions.


Thanks,

Phil

.

Relevant Pages

  • Re: Global Temp Table & Multiple Users
    ... design and I'm not sure if performance would be any better. ... about serialization is that it limits the dbms pounding that these reports ... what is happening is this a dynamic SQL ... > The inner proc generates a portion of the SQL, ...
    (microsoft.public.sqlserver.server)
  • Re: Advice on persistent storage in Java?
    ... >>I need some advice on persistent storage in Java. ... objects are meant to store user defined data (the user defines the ... the SQL would probably all be pretty basic. ... i'm thinking about using serialization for now ...
    (comp.lang.java.programmer)
  • Re: does a web developer need to worry about serialization?
    ... "any data I really needed to persist would be saved to sql server." ... Is not it a Serialization? ... to worry about this as a web developer? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: serialize to SQL Server Blob instead of XML serialize
    ... I've never used binary objects in SQL before. ... Dim ms As New MemoryStream ... > I've been experiencing problems on some computers with XML Serialization. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Big database: many SQL tables vs. object serialization
    ... Thus each page view requires many SQL queries and/or joins. ... Instead of the standard PHP serialization functions, ... Then you wouldn't have a PHP-specific database. ...
    (comp.lang.php)