tuning (705)


How big can a MySQL database get before performance starts to degrade

How big can a MySQL database get before performance starts to degrade

At what point does a MySQL database start to lose performance? Does physical database size matter? Do number of records matter? Is any performance degradation linear or exponential? I have what I beli…


Identifying SQL Server Performance Problems

We're having sporadic, random query timeouts on our SQL Server 2005 cluster. I own a few apps that use it, so I'm helping out in the investigation. When watching the % CPU time in regular ol' Perfmon…


sql - Favourite performance tuning tricks

When you have a query or stored procedure that needs performance tuning, what are some of the first things you try?…


Tactics for using PHP in a high-load site

Before you answer this I have never developed anything popular enough to attain high server loads. Treat me as(sigh) an alien that has just landed on the planet, albeit one that knows PHP and a few op…


What generic techniques can be applied to optimize SQL queries?

What techniques can be applied effectively to improve the performance of SQL queries? Are there any general rules that apply?…


Java object allocation overhead

I am writing an immutable DOM tree in Java, to simplify access from multiple threads.* However, it does need to support inserts and updates as fast as possible. And since it is immutable, if I make a…


Find out where your PHP code is slowing down(Performance Issue)

Here's my first question at SO. I have a internal application for my company which I've been recently ask to maintain. The applications is built in PHP and its fairly well coded(OO, DB Abstraction,…


ColdFusion Template Request count optimization

In ColdFusion, under Request Tuning in the administrator, how do I determine what is an optimal number(or at least a good guess) for the Maximum Number of Simultaneous Template Requests? Environment…


asp.net - What is the most accurate method of estimating peak bandwidth requirement for a web application?

I am working on a client proposal and they will need to upgrade their network infrastructure to support hosting an ASP.NET application. Essentially, I need to estimate peak usage for a system with a…


What are the best SQL Server performance optimization techniques?

I've always taken the approach of first deploying the database with a minimal set of indexes and then adding/changing indexes as performance dictates. This approach works reasonably well. However, it…





performance how java query example optimization slow server improve collection