performance

Tracking down slow managed DLL loading

I am faced with the following issue and at this point I feel like I'm severely lacking some sort of tool, I just don't know what that tool is, or what exactly it should be doing. Here is the setup: I have a 3rd party DLL that has to be registered in GAC. This all works fine and good on pretty much every machine our software was deployed...

HTTP Basic Auth, reading password file and performance

hi, I'm curious to know what are the performance impacts of using HTTP Basic Auth on a webserver like Apache or lighttpd or nginx. I imagine the bottleneck is the actual reading of the file by the server to authenticate a user. It also seems to me that the cost of reading the file to authenticate a user is proportional to the number of ...

CSS Hover & onmouseover/out causing 15-20% CPU Usage in Internet Explorer

Hello, is there any reason why Internet Explorer (IE7 in my case) gets sluggish and eats up lots of CPU time when using the CSS :hover command or using onmouseover/onmouseout? I'm really not doing anything complex, nor is my page particularly large. When I move my mouse anywhere else on the page (where nothing is changing) iexplore.ex...

Does the order of columns on a covered index in Sybase affect select performance?

We have a large table, with several indices (say, I1-I5). The usage pattern is as follows: Application A: all select queries 100% use indices I1-I4 (assume that they are designed well enough that they will never use I5). Application B: has only one select query (fairly frequently run), which contains 6 fields and for which a fifth ind...

Does having several indices all starting with the same columns negatively affect Sybase optimizer speed or accuracy?

We have a table with, say, 5 indices (one clustered). Question: will it somehow negatively affect optimizer performance - either speed or accuracy of index picks - if all 5 indices start with the same exact field? (all other things being equal). It was suggested by someone at the company that it may have detrimental effect on performa...

Sybase: Does the column order in a non-clustered index affect insert performance?

To be more specific (since the general answer to the subject is likely "yes"): We have a table with lots of data in Sybase. One of the columns is "date of insertion" (DATE, datetime type). The clustered index on the table starts with the "DATE". Question: For another, non-clustered index, does the order of columns (more specifically...

Java Runtime.maxMemory incorrect?

I ran the following method Runtime.getRuntime().maxMemory() and gave 85196800. However, I then ran top from the command line and it showed PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 8672 root 20 0 ...

How to decrease the perceived loading time of Java Swing forms?

In my Swing application I have the problem that when creating a new instance of a Swing form for the first time, it takes several hundreds of milliseconds. That's not really long but the subjective impression of getting slowed down is really annoying. It happens with all forms, even a JOptionPane message or other trivial forms. (Of cou...

Using GetCurrentMethod in (supposedly) high-performance code

For logging purposes, some methods in our application include the following line: Dim Log As ILog = GetLog(Reflection.MethodBase.GetCurrentMethod().DeclaringType) I have what might be described as an irrational fear of reflection, which I try to keep in check. However, calls like this in methods that are executed potentially a hundred...

Are Oracle Analytic Functions costly?

Has anyone encountered slow performance when using oracle analytic functions? The lead() oracle analytic function was used to generate a new field in the table. Basically, it would allow the previous row's field value to be used as the value of the current row's new field. The explain plan indicates a full table scan is performed on t...

ASP.NET: High CPU usage under no load

Hi everyone, I´m facing a huge problem since a couple weeks. I´ve an asp.net application hosted under IIS7 (W2008 SP1), and every a couple hours it starts consuming near 50% of the CPU when maybe there're no users connected. It´s understandable since we are using Quartz.net to make some application recicling, but we could not reproduce t...

Is there a remote profiler for Java? (that uses JMX preferably)

I am trying to pin down a memory leak problem for my standalone Java program that runs on unix. I have the port and params setup such that I can connect to it using JMX with JConsole or VisualVM already. Those help a little but unfortunately it doesn't tell you where the memory has gone, it only tells you how much memory is used. I'm l...

Making DiveIntoPython3 work in IE8 (fixing a Javascript performance issue)

I am trying to fix the performance problem with Dive Into Python 3 on IE8. Visit this page in IE8 and, after a few moments, you will see the following popup: I traced down the culprit down to this line in j/dip3.js ... find("tr:nth-child(" + (i+1) + ") td:nth-child(2)"); If I disable it (and return from the function immediately), th...

Selecting optimal server without using ping?

I'm looking for the best approach for selecting the "optimal" network server. Use case: A user at home needs to access a network through any one of the geographically dispersed servers, and we want our desktop app to automatically select one in under a second. The servers block ICMP packets so ping won't work. We're thinking of sending H...

LINQ To SQL - Poor Sql Performance

Hey all, I have a WPF at a customer site that makes calls to a remote SQL 2005 server using Linq To Sql. Almost everyday the customer experiences aweful slow downs, and I am not sure what to do. The quick fix is to restart the mssql service and that seems to do the job, but that is not a solution. Tonight I used the SQL profiler and ...

Problem taming MySQL query performance with OR statement

[Warning: long post ahead!] I've banging my head at this for quite some time now but can't get on a common denominator what is going on. I've found a solution to workaround, see at the end, but my inner Zen is not satisfied yet. I've a main table with forum messages (it's from Phorum), simplified looks like this (ignore the anon_user_i...

PHP: performance of static methods vs functions

In PHP, (unlike what i originally thought) there an overhead of calling static methods vs simple functions. On a very simple bench, this overhead is over 30% of the calling time (the method just returns the parameter): // bench static method $starttime = microtime(true); for ($i = 0; $i< 10*1000*1000; $i++) SomeClass::doTest($i); ech...

optimizing branching by re-ordering

I have this sort of C function -- that is being called a zillion times: void foo () { if (/*condition*/) { } else if(/*another_condition*/) { } else if (/*another_condition_2*/) { } /*And so on, I have 4 of them, but we can generalize it*/ else { } } I have a good test-ca...

Performance of concurrency in Django (apache2 prefork/mod_wsgi), what am I doing wrong?

First of all I am not in any way unhappy with the performance of my Django powered site, its not getting massive traffic, a bit over 1000 visits per day so far. I was curious how well it would cope with heavy traffic peaks so I used the ab-tool to do some benchmarking. I noticed that the performance when the concurrency is larger than ...

Performance and diagnostics tools for Silverlight

WPF 3.5 has PresentationTraceSources for diagnostics and WPFPerf for performance and data binding diagnostics. Are there equivalent tools / libraries for Silverlight? ...