.NET Performance

[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.

[Hans Kesting]

news wrote:

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.

see "Improving .NET Application Performance and Scalability"
http://msdn.microsoft.com/library/en...asp?frame=true
Hans Kesting

[Kevin Spencer]

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

"news" <sa***@logicians.com> wrote in message
news:Fo***************@text.news.blueyonder.co.uk. ..

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.