Top "Optimization" questions

Optimization is the act of improving a method or design.

Using index, using temporary, using filesort - how to fix this?

I'm working on a event tracking system which uses a handful of lookup tables as well as the primary logging …

mysql optimization select temporary filesort
How to find out why the status of a spid is suspended? What resources the spid is waiting for?

I run EXEC sp_who2 78 and I get the following results: How can I find why its status is suspended? …

sql sql-server optimization query-optimization sql-tuning
How to concatenate two integers in C

Stack Overflow has this question answered in many other languages, but not C. So I thought I'd ask, since I …

c math optimization mathematical-optimization
How to minify JS or CSS on the fly

How to minify JS and CSS on the fly / runtime, so that I can keep the original code structure in …

php javascript css optimization minify
Writing FizzBuzz

Reading the coding horror, I just came across the FizzBuzz another time. The original post is here: Coding Horror: Why …

c# optimization fizzbuzz
Fastest sort of fixed length 6 int array

Answering to another Stack Overflow question (this one) I stumbled upon an interesting sub-problem. What is the fastest way to …

algorithm sorting optimization gpgpu sorting-network
-static option for gcc?

I'm wondering what the -static option on gcc does. I need this option when compiling a certain application, however when …

optimization gcc compiler-construction static options
Does the <script> tag position in HTML affects performance of the webpage?

If the script tag is above or below the body in a HTML page, does it matter for the performance …

javascript html performance optimization
best way to clear contents of .NET's StringBuilder

I would like to ask what you think is the best way (lasts less / consumes less resources) to clear the …

c# .net optimization .net-3.5
Why to use StringBuffer in Java instead of the string concatenation operator

Someone told me it's more efficient to use StringBuffer to concatenate strings in Java than to use the + operator for …

java optimization string-concatenation