.NET Performance

  • Thread starter Thread starter news
  • Start date Start date
N

news

How can better .NET performance be found?

DETAILS

1. MS SQL, C#, .NET, Windows, dedicated server - 1GByte.
2. I run update jobs for word indexes using 200,000 database accesses, but
they take 4 hours to run.

I am looking for a CPU/memory guide for .NET or middleware software to boost
performance.
 
news said:
How can better .NET performance be found?

DETAILS

1. MS SQL, C#, .NET, Windows, dedicated server - 1GByte.
2. I run update jobs for word indexes using 200,000 database
accesses, but they take 4 hours to run.

I am looking for a CPU/memory guide for .NET or middleware software
to boost performance.
Click to expand...

see "Improving .NET Application Performance and Scalability"
http://msdn.microsoft.com/library/en-us/dnpag/html/scalenet.asp?frame=true


Hans Kesting
 
Aside from the few types of performance-enhancements that are unique to the
..Net platform, I believe you'll find your greatest performance boosting
comes from the same bucket as other programming platforms. That is,
efficient algorithms, use of memory, disk resources, and well-thought-out
architecture.

It sounds like you have a Full-Text Index situation here. There isn't much
you can do to optimize Full-Text indexing, other than reducing the size of
the text you are indexing, or not indexing as often. SQL Server has been
designed to run as optimally as possible on such types of jobs.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
I get paid good money to
solve puzzles for a living
 
Back
Top