If you want to improve your Web performance in your project, then you need to think/Answer on below points:
● How many database connections do I have in my code?
● How many request are going in my application?
● How much time does every select (db) statement spend?
● How many select statements do you have in your code?
● Are they inside loops?
● Do I really need them? Can I cache them?
● How many functions are there in my application? Can we replace with inbuilt functions?
Read the rest of this entry »

Tips for SQL Query Optimization

Posted: October 24, 2012 in General, SQL, Technology

1.    Use UNION ALL statement instead of UNION, wherever possible.

UNION ALL statement is quite faster than UNION, because UNION ALL statement does not check duplicate rows, while the UNION statement always check for duplicate rows, whether duplicate record is exists or not.

2.     Include SET NOCOUNT ON statement into your stored procedures

Usually T-SQL will show message regarding affected row but with the help of SET NOCOUNT ON statement we can stop these message. This can reduce network traffic, as your client will not receive the message indicating the number of rows affected by a T-SQL statement. Read the rest of this entry »

Why we use stored procedures in application

Applications that use stored procedures have the following advantages:

1.       Procedural Language Capability: – 

PL SQL consists of procedural language constructs such as conditional statements (if else statements) and loops like (FOR loops). Accept input parameters and return multiple values in the form of output parameters to the calling procedure or batch.

2.        Stored Procedures are pre-compiled:-

Once created, that can be used again and again without doing compilation. That will save compilation time and get result in less time.

Read the rest of this entry »

What is WSDL?

Posted: October 3, 2011 in PHP, Technology

WSDL stands for Web Services Description Language. It is an XML-based language for describing Web services and how to access them. It help to web service consumer to consume. In easy words we can say with the help of WSDL file only user can use web service. WSDL file is key of web service. Without this key web service is useless lock. It specifies the location of the service and the operations (or methods) the services provide.
Read the rest of this entry »

Check My Performance

Posted: September 20, 2011 in Motivational

A little boy went into a drug store, reached for a soda carton and pulled it over to the telephone.
He climbed onto the carton so that he could reach the buttons on the phone and proceeded to punch in seven digits.

The store-owner observed and listened to the conversation:

The boy asked,” Lady, Can you give me the job of cutting your lawn? Read the rest of this entry »

Speed Up Php

Posted: August 2, 2011 in PHP, Technology

There are some clear coding optimizations that would reduce load on the servers, and therefore remove the need for scaling out the infrastructure. It is common practice for developer which will help out to speed up php.

  • Avoid function tests in loop conditionals: - If you’re looping through an array, for example, count() it beforehand, store the value in a variable, and use that for your test. This way, you avoid needlessly firing the test function with every loop iteration. Read the rest of this entry »

Rate Your Level

Posted: July 19, 2011 in General, Technology

Rather than try and attach years of experience to this scale, I’m going to represent a list of major areas and skills, questions, or topics in some basic area. I’ve tried to capture whether I feel a skill is required to be a beginner, Intermediate or Advanced web developer.

I put this list together based on my own experience, some search on web and other people’s views.

Beginner: Knows some of the items on the list
Intermediate: Knows most intermediate items and some advanced
Advanced: Knows almost everything on the list

Read the rest of this entry »