Re: increasing the RPS of any page




I think a good approach is to:

- always bear in mind that your pages may get called 100 times per
second
- create a quick and easy to use testing app (that can simulate high
traffic)
- performance test as you develop, getting ridding of slow or cpu
hungry code as you work
- study database locking and indexing till you are a pro
- create and use consistent database access strategy (generally
tablock/tablockx for all web stuff can
accelerate db access significantly as lock acquisition time for web
apps is often higher than lock hold time)
- never use connected recordsets for long winded update jobs
- make sure connection pooling is on!
- try and avoid approaches that don't work with data in small chunks
(ie: DataReader yes, DataSet avoid like plague)
- asp.net trace timing feature is cool, use this to drill down into
inefficient methods
- remember that http requests are serialized for each session context
(issue if using frames)
- remember that response.write(your html) is probably much more
efficient than using ms html and web controls (which suck)

also bear in mind the big difference between slow through waiting (low
cpu) and slow through processing (high cpu)

.

Relevant Pages

  • Re: Im thinkin about buying a new PC...
    ... ie gaming or general use. ... One thing to bear in mind when you buy OEM computer you only get a ... the CPU is about all that's required, you learn quite a lot this way ...
    (comp.sys.hp.hardware)
  • Re: mobo experiments outside the box?
    ... So you've tried the CPU in the other motherboard and it works and have also tried the RAM in the other board and that works too, bear in mind that some RAM will go as far as to POST in one machine but not in another, obviously it wouldn't therefore work 100% properly in normal operation but bear that in mind. ...
    (uk.comp.homebuilt)
  • RE: replacing carriage returns with HTML break tags
    ... based on the code that I'm working can I use the Replace method with Format ... Bear in mind that the MSDN .Net documentation is nothing but gibberish to me. ... >> I'm changing our order confimation from a plain text to HTML. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Technical issue with this site
    ... you're confused (or ignorant) of what you're posting to in the first ... You have to bear in mind that my first exposure to computers ... That hair would, for Tina, be a six-inch steel hawser. ...
    (rec.arts.sf.composition)
  • The Biggest Experiments in Science
    ... The ITER nuclear fusion project ... Laser Interferometer Wave Observatory ... Also bear in mind that I work in TV and too many equations tend to ...
    (sci.physics.research)