performance

removing row bottleneck for aggregated data for oltp database

In addition to inserting a new row into a table for each item of work being processed, an additional update is done to a separate row in a different table that contains some kind of summary data (e.g. totals) relating to a portion of the rows being inserted into the first table. This single row however can therefore become a bottleneck ...

What is the most appropriate performance counter type for measuring operation time?

Say I have a method Foo() and I want to measure the time in milliseconds it took to execute which type of Windows Performance Counter should I be using? var stopwatch = new Stopwatch(); stopwatch.Start(); Foo(); stopwatch.Stop(); counter.RawValue = stopwatch.TotalMilliseonds; Currently I'm using NumberOfItems64 but that persists the l...

CreateFileMapping, MapViewOfFile, how to avoid holding up the system memory

Hi. I'm developing an application targeted for desktop systems which may have as little as 256MB RAM (Windows 2000 and up). In my application I have this large file (>256MB) which contains fixed records of about 160 bytes/each. This application has a rather lengthy process in which, over time, it will be randomly accessing about 90% of t...

what is the use of Long.reverse(long ) method?

I found one method in Long class public static long reverse(long i) {..} What is the use of this method? ...

Which is the BEST way to optimize a web site for faster download and SEO?

Which is the BEST way to optimize a web site for faster download without affecting my ranking? How do I optimize my CSS file and images? ...

Tomcat vs Websphere's web container performance

Anybody knows about a performance comparison for Tomcat vs Websphere app server's web container? www.webperformanceinc.com provides such a comparison but it's very outdated, somebody knows if there is a newer one, say with Websphere v6.1 or v7? ...

SSIS Lookup Component Performance Sorting Lookup Query

I'm attempting to use the SSIS 2008 lookup component in full cached mode with a T-SQL Query. Is there any benefit to using a ORDER BY clause in the T-sql. Here is a example: SELECT FooFK ,FooValue FROM dbo.Foo ORDER BY Foo; In this case, I'm using FooValue to lookup the value of FooFk. Also will multiple Lookups component run in pa...

SQL Join vs Separate Query in Code without Join - Performance

I would like to know if there's a really performance gain between those two options : Option 1 : I do a SQL Query with a join to select all User and their Ranks. Option 2 : I do one SQL Query to select all User I fetch all user and do another SQL Query to get the Ranks of this User. In code, option two is easier to realize for...

Does Functional programming allow better runtime compiler optimizations?

NOTE: Already made this a Wiki. I don't care what this question is tagged as, as long as there is a good discussion. I've heard that since in pure functional programs, there are no side effects and values dont mutate, it makes it easier for the compiler to make more runtime optimizations. To what extent is this true? If this is true, m...

Performance Impact of loading WPF resource files

In my application I am loading all my shared resources into the app.xaml. The problem is that the vs2008 designer can't see styles in a different assembly so I lose designer support unless I use dynamic resources which comes with a whole other set of problems. My question is can I directly load the same resources directly onto a page wi...

Which is optimal ?

Is declaring a variable inside a loop is good or declaring on the fly optimal in Java.Also is there any performance cost involved while declaring inside the loop? eg. Option 1: Outside the Loop List list = new ArrayList(); int value; //populate list for(int i = 0 ; i < list.size(); i++) { value = list.get(i); System.out.println(“...

Performance concerns on sanitizing all user input using PHP array_map

Hi, I'm running this function to sanitize all user input through out my site, but it worries me that it may be very performance intensive... // function for cleaning arrays, recursively for arrays held inside arrays function array_clean($array) { // if its an array, walk each element recursively if(is_array($ar...

Are there applications that can crunch numbers directly?

Applications that would boot straight from boot media like a bios. WOuld this lead to better performance, leaving the OS behind? Or would there be no difference, basically replacing system calls with function calls? edit: I am after lists of applications similar to memtest86 but for number crunching as examples ...

Is Javascript parsed/interpreted on load? (IE)

I Know, for instance, that when Chrome downloads a Javascript file, it is interpreted and JITed. My question is, when IE6,7,8, first download a Javascript file, is the entire thing parsed and interpreted? My understanding was that only top level function signatures and anything executed in the global scope was parsed on load. And then ...

performance loading js files

Hi I was wondering what would be best. I have different JS functions, for instance I have the accordion plugin, a script for the contact page. But I only use each script on one page e.g. 'the faq page'uses the accordion JS but not the contact JS obviously. This along with many other examples (my js dir is 460kb big in total, seperated ...

Visual studio 2008 stops responding frequently during edit and save

Hi, slow performance is the most annoying issue for me when using visual studio 2008 and happens very frequently. when I start writing the code and saving it, suddenly the visual studio becomes unresponsive and takes a while to come back. the time taken is lot more if I am editing an aspx mark-up page. I am not sure what processing is...

Variable number of arguments without boxing the value-types?

public void DoSomething(params object[] args) { // ... } The problem with the above signature is that every value-type that will be passed to that method will be boxed implicitly, and this is serious performance issue for me. Is there a way to declear a method that accepts variable number of arguments without boxing the value-type...

Unresponsive ASP.NET site in IIS7

Where I work we recently had a site which was incredibly unresponsive (1 minute or more for a simple request. When I tested it I tried a page as simple as: <%@ Page Language="C# %> <html><body><h1>Hello World</h1></body></html> (PS: Lack of code-behind declaration is intentional - that's all it was. No actual code) And it still took ...

Web.py on shared hosting

Hi, I just built a small app with the very cool and minimalistic web.py. I am using a cheap shared hosting package (at WebFaction) and have installed web.py via virtualenv. I cannot use the system python since I need additional packages which I'm not allowed to install into the system python. So now I start my app with /home/me/my...

ASP.NET: Monitor application performance

Hi Geeks, I have an ASP.NET application which will be running in a web server (Windows Server 2003) for serving my intranet users. Now i would like to monitor the performance of the application: like memory management, unclosed db connection, etc... The ultimate aim is to make the application work optimized. What are the things i should...