Re: Website Running Slow Please Help.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Caching is a very common way to improve performance, but it sounds
like you still have some underlying performance problems that really
should be fixed. Caching is great when the content you're generating
requires a ton of processing or is extremely database intensive, or in
extremely high volume sites where there are a number of concurrent
requests for the same data (think of situations where caching times in
seconds would be appropriate). Does that situation apply to your
application?

Also, generally it's better to expire items from the cache manually
when the underlying data changes. That's not always possible if the
cache is based on external data, but if the cache is data that your
application itself has control over, then the admin portions of the
application that write data to the database should know what items are
cached and can cause immediate expiration.

Another thing to look into is SQL Server 2005 Query Notifications.
These are a type of cache, but they automatically expire when the
underlying data changes without as much work from the developer. It's
still caching so is not a true solution, but it sounds like this would
be better than the time based caching you're doing now.

HTH,

Sam

------------------------------------------------------------
We're hiring! B-Line Medical is seeking .NET
Developers for exciting positions in medical product
development in MD/DC. Work with a variety of technologies
in a relaxed team environment. See ads on Dice.com.



On Wed, 30 Jan 2008 07:32:54 -0800 (PST), Tageldinho
<adamtageldin@xxxxxxxxx> wrote:


....
Also, they have recently implemented a new caching system on the
website so that everytime a user visits a page instead of the site
hitting the database everytime and storing the info in an object it
will load and place the object into the cash so that if someone else
visits that page it will look in the cache first and prevent it from
hitting the database (given the page has been loaded previously within
the last 20 minutes as this is the time the caching is set to expire).
After the 20 minutes is up it is automatically deleted from the
memory.

....

Adam

.

Relevant Pages

  • Re: Datasets fundamental
    ... loading from the Database into this "cache" and you want to update on a ... another option is using SQL 2005 Express and having it ... You then move from a custom "cache" solution to a normal replication type of ... engine is better at caching than you. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: VIOC: sizing and performance
    ... VIOC rather than XFC file caching. ... I see Read Hit Rates of 58% (database node, 512000 maxsize), ... Is it the read hit rate, ... "Sets size for closed file cache. ...
    (comp.os.vms)
  • [PATCH 1/2] Bcache: Version 7 - Writeback
    ... Bcache is a patch for caching arbitrary block devices with other block devices ... default sequential IO bypasses the cache. ... but the code should be fairly sane in design. ...
    (Linux-Kernel)
  • Re[2]: [PHP] dynamic -> static
    ... As I wrote already this issue is mainly because of search engines ... incompatibility with dynamic content sites (to be more exact - with ... You can cache your code using PHP Accelerator or Turck ... MM> implementing a caching layer between your application and your database. ...
    (php.general)
  • Re: [PHP] Aggressive PHP Smart Caching
    ... i have begun to experiment w/ your caching tool. ... it is also important that the script calling ob_end_flushhave access to ... the header method in the first bit of code in the cache tool. ...
    (php.general)