performance

Know of any Java garbage collection log analysis tools?

I'm looking for a tool or a script that will take the console log from my web app, parse out the garbage collection information and display it in a meaningful way. I'm starting up on a Sun Java 1.4.2 JVM with the following flags: -verbose:gc -XX:+PrintGCTimeStamps -XX:+PrintGCDetails The log output looks like this: 54.736: [Full GC ...

What would be the best option, performance wise, between 1 10k rpm disk and 2 7k rpm disks in striped raid

I'm thinking of improving the performance of my development machine, and the next step is the IO subsystem, namely, the hard disks. Assuming consumer grade disks (which removes SCSI and SAS drives) and a reasonable bill (which removes the option of two or more 10k RPM disks), the two options I'm faced are: getting 1 VelociRaptor or equ...

What are the implications of having out of date table statistics on a Sybase/SQLServer database?

For example, for heavily used tables with volumes in the order of 10 million rows that grow by a million rows a month, if the stats are 6-8 months old how detrimental to the performance of the database is this going to be? How often should you be refreshing the stats? ...

Does visibility affect DOM manipulation performance?

IE7/Windows XP I have a third party component in my page that does a lot of DOM manipulation to adjust itself each time the browser window is resized. Unfortunately I have little control of what it does internally and I have optimized everything else (such as callbacks and event handlers) as much as I can. I can't take the component of...

What is the stored procedures performance compared to embedded SQL in various RDBMs?

From my experience with DB2 on Z/OS there is no difference between embedded SQL and stored procedures as both get compiled to native code. On the other hand I know that in Oracle there is a huge difference - is it true and how is it in other DBs? Please provide some links to support your claims. ...

Which is more efficient regular expression?

I'm parsing some big log files and have some very simple string matches for example if(m/Some String Pattern/o){ #Do something } It seems simple enough but in fact most of the matches I have could be against the start of the line, but the match would be "longer" for example if(m/^Initial static string that matches Some String Pat...

Joining tables in database vs webserver

Hi I had 2 tables in Cache in web server. The size of tables is considerable huge. Each time to retrieve data I have to do a join on these 2 tables. Other option I have is have nothing in cache and making a db call each time that will do a join on the db tables. So what I want to know is doing a join on webserver is it costlier than...

Biggest performance improvement you've had with the smallest change?

What's the biggest performance improvement you've had with the smallest change? For example, I once improved the performance of a certain page on a high-profile web app by a factor of 10, just by moving "where customerID = ?" to a different place inside a complicated SQL statement (before my change it had been selecting all customers in...

ASP.NET MVC performance has suddenly become very slow

I'm using Billy McCafferty's rather excellent S#arp Architecture. Everything was spiffing and running very quickly. I then updated to the the latest ASP.NET MVC RC. This meant I had to get the latest trunk of S#arp. Also, two weeks ago, I updated from XP to Vista (32 bit) My problem is that the performance has suddenly become woeful...

?: Operator Vs. If Statement Performance

I've been trying to optimize my code to make it a little more concise and readable and was hoping I wasn't causing poorer performance from doing it. I think my changes might have slowed down my application, but it might just be in my head. Is there any performance difference between: Command.Parameters["@EMAIL"].Value = email ?? Strin...

What is the best way to measure Client Side page load times?

I'm looking to monitor the end user experience of our website and link that with timing information already logged on the server side. My assumption is that this will require javascript to to capture time stamps at the start of request (window.onbeforeunload) and at the end of loading (window.onload). Basically this - "Measuring Web appl...

Querying a timestamp column from LINQ to SQL

My table has a timestamp column named "RowVer" which LINQ maps to type System.Data.Linq.Binary. This data type seems useless to me because (unless I'm missing something) I can't do things like this: // Select all records that changed since the last time we inserted/updated. IEnumerable<UserSession> rows = db.UserSessions.Where ( usr => ...

How much overhead does SSL impose?

I know there's no single hard-and-fast answer, but is there a generic order-of-magnitude estimate approximation for the encryption overhead of SSL versus unencrypted socket communication? I'm talking only about the comm processing and wire time, not counting application-level processing. Update There is a question about HTTPS versus HT...

Performance vs Quality of Code

Do you think it's worth trading off some performance for code-quality and maintainability? I remember a post by Jeff Atwood that stated that hardware is cheap, developers are not. I think I'd like to change that to "Hardware is cheap, time is not." I've noticed with an MVC project I've been working on lately that sometimes I lose DAYS...

Self-Profiling using Proxy class

Given an interface public interface IValueProvider { object GetValue(int index); } and a tree structure of instances of IValueProvider similar to a math expression tree. I want to measure the time that is spent in the GetValue method of each node at runtime without an external profiler. GetValue could do anything that i don't know ...

Why isn't pass struct by reference a common optimization?

Up until today, I had always thought that decent compilers automatically convert struct pass-by-value to pass-by-reference if the struct is large enough that the latter would be faster. To the best of my knowledge, this seems like a no-brainer optimization. However, to satisfy my curiosity as to whether this actually happens, I created...

SQL Performance - Better to Insert and Raise Exception or Check exists?

I'm considering an optimisation in a particularly heavy part of my code. It's task is to insert statistical data into a table. This data is being hit a fair amount by other programs. Otherwise I would consider using SQL Bulk inserts etc. So my question is... Is it ok to try and insert some data knowing that it might (not too often) ...

count VS select in LINQ - which is faster?

I'm using IQueryable<T> interfaces throughout my application and defer execution of SQL on the DB until methods like .ToList() I will need to find the Count of certain lists sometimes -without- needing to use the data in the list being counted. I know from my SQL experience that a SQL COUNT() is far less work for the DB than the equival...

What is taking IsNumeric() so long in .NET?

Was doing some benchmarking with IsNumeric today and compared it to the following function: Private Function IsNumeric(ByVal str As String) As Boolean If String.IsNullOrEmpty(Str) Then Return False Dim c As Char For i As Integer = 0 To Str.Length - 1 c = Str(i) If Not Char.IsNumber(c) Then Return False N...

Improving performance of C# code

How do I improve the performance of the following situation? I have an application that accepts multiple connections across a network. The application is written in C# and accepts Socket connections. Every five minutes, the application needs to perform a function call that updates the application and reports information back to the sock...