performance-tuning

How do you test the performance of a website?

Are there specific tools to perform the following job or there is a suite of tools that help me do the following: How can I check page load times? How can I track down a page that hogs memory? How can I track a page that consumes a lot of CPU cycles? I just want to glean from the experience of this forum and come across a holistic v...

Considerations for updating a 'SiteVisit' row many times over a session

SQL Server 2005: I have a SiteVisit row which contains information about a users visit, for instance HttpRefer, whether or not they placed an order, browser, etc. Currently for reporting I am joining this table with SiteEvent which contains information about each 'section' visited. This then produces a view which shows statistics about...

Performance Tuning WCF Service

What is the single most important performance tuning area for a WCF Web service? ASP.net Thread settings? WCF throttling? ...

Is there a more efficient way to do this SQL Select?

I have this SQL query: SELECT * FROM IMAGES WHERE IMAGENAME in ('IMG1', 'IMG2', 'IMG3', 'IMG4', 'IMG5', 'IMG6') ORDER BY CASE IMAGENAME WHEN 'IMG1' THEN 1 WHEN 'IMG2' THEN 2 WHEN 'IMG3' THEN 3 WHEN 'IMG4' THEN 4 WHEN 'IMG5' THEN 5 WHEN 'IMG6' THEN 6 ELSE 7 END I cannot guarantee that the list of IMAGENAMEs will be in alp...

How can I speed up a joined update in SQL? My statement seems to run indefinitely.

I have two tables: a source table and a target table. The target table will have a subset of the columns of the source table. I need to update a single column in the target table by joining with the source table based on another column. The update statement is as follows: UPDATE target_table tt SET special_id = ( SELECT source_specia...

Tricks to speed up Eclipse

Which tricks do you know to make the experience with Eclipse faster? For instance: I disable the all the plugins I don't need (Mylyn, Subclipse, ). Instead of using a plugin for Mercurial I configure TortoiseHG as an external tool. ...

Any guides on learning how to interpret a SQL query's Execution Plan in SQL Server 2005?

Is there any good article, tutorial or similar references on interpreting the Execution Plan of a query in SQL Server 2005? ...

Single User: Turn off locking for Microsoft SQL Server

I'm running an upgrade script against a database hosted in Microsoft SQL Server. It's taking a while. Some of the queries are not worth optimising any further, for various reasons. I'm the only person using this database: Is there a way that I can tell SQL Server to not bother with transactions/locking? For instance, on a DELETE ... WH...

Delphi Profiling tools

Hi I am having some performance problems with my Delphi 2006 app. Can you Suggest any profiling tools that will help me find the bottle neck i.e. A tool like turbo Profiler ...

Techniques to monitor/improve performance in Linq to Sql queries

I have a webpage that is taking way too long and need to optimize it. Because uninformed optimizing is the devil, I need to know what exactly is holding me down. A quick glance showed me that it is probably an sql2linq query that is most likely causing the trouble. What are techniques of pinning the performance problem in this case? Are...

C# - Do method names get compiled into the EXE?

Do class, method and variable names get included in the MSIL after compiling a Windows App project into an EXE? For obfuscation - less names, harder to reverse engineer. And for performance - shorter names, faster access. e.g. So if methods ARE called via name: Keep names short, better performance for named-lookup. Keep names crypt...

C# - Array that can be resized fast

I'm looking for a kind of array data-type that can easily have items added, without a performance hit. System.Array - Redim Preserve copies entire RAM from old to new, as slow as amount of existing elements System.Collections.ArrayList - good enough? System.Collections.IList - good enough? ...

How do you maximize server performance?

I have been trying to get my head around to understanding performance and scalability and would like to know what developers/sysadmins are doing to juice their systems. To standardize the answers, it would help if you could take your best shot at responding to any of the following: Profile - Magazine publication on Joomla; Jobs board o...

SQL Server 2000 - What really is the "Actual Number of Rows" ?

Hello, I have an SQL Server 2000 query which performs an clustered index scan and displays a very high number of rows. For a table where I have 260.000 records, the actual number of rows displayed in the plan execution is ... 34.000.000. Does this makes sense? What am I misunderstanding? Thanks. ...

Will conditionals that are always false be removed by compiler in C#

Say I have the following code snippet in c# static const bool DO_PERFORMANCE_CODE = false; if (DO_PERFORMANCE_CODE) { // performance monitoring code goes here } Will that code get removed by the compiler? This is the functionality I'd like. Basically I want to mimic the conditional compilation stuff in C#, but I want more configur...

Thoughts on index creation for SQL Server for missing indexes

I'm working on performance tuning my SQL Server 2008 database and am using the output from various DMVs to identify missing indexes, indexes that aren't being used, etc. I am mainly using these 3 scripts (from SQLServerCentral.com) that rely on DMV data that SQL Server provides: The Ultimate Missing Index Finder The Ultimate Duplicate...

Adding ORDER BY clause to MySQL query makes it return in ~30 seconds, up from ~0.5

So I have this query that is relatively fast at ~0.5 seconds but when I add an ORDER BY clause it jumps up to nearly 30 seconds. Original query: (returns in ~0.5 seconds) SELECT table1.*,table2.* FROM table1 LEFT OUTER JOIN table2 ON table1.column2=table2.column3 WHERE table1.column1='value' LIMIT 4 Query with ORDER BY: (returns in ~...

What Process is using all of my disk IO

If I use "top" I can see what CPU is busy and what process is using all of my CPU. If I use "iostat -x" I can see what drive is busy. But how do I see what process is using all of the drive's throughput? ...

Are stored procedures required for large data sets?

I've just started my first development job for a reasonably sized company that has to manage a lot of data. An average database is 6gb (from what I've seen so far). One of the jobs is reporting. How it's done currently is - Data is replicated and transferred onto a data warehouse. From there, all the data required for a particular repo...

Is Virtual Memory still relevant in today's world of inexpensive RAM?

Virtual memory was introduced to help run more programs with limited memory. But in todays environment of inexpensive RAM, is it still relevant? Since there will be no disk access if it is disabled and all the programs will be memory resident, will it not improve the performance and program response times? Is there any essential requi...