Tag Archives: database performance
Application Performance Series- Part 1- Where to start
This is part 1 of a multiple part series on web performance improvements. The Introductory blog can be found here. In introductory post we discussed importance of software development keeping performance performance at center. In this part we will discuss which part affect web application performance the most? Where we can start the performance improvement activity to get […]
Application Performance Series- Introduction
Developing software applications is not just writing code, but it is much than that. It’s both science and Art when combined together can produce great quality applications. It is an art of writing efficiently working, fast and secure code. This is especially true when we are working on web applications. Developing a fast, scalable and […]
Some SQL-Server Performance Enhancement Tips
Choose the Appropriate Data Types Use Triggers Cautiously Use views and stored procedures instead of heavy queries. It reduces network traffic, because client will send to server only stored procedure or view name (in certain cases heavy-duty queries might degrade performance up to 70%) instead of large heavy-duty queries text. This also facilitates permission management […]