Javascript optimization tips

Posted: February 8, 2015 in General, HTML, PHP, Technology
Tags: ,

1. Minify Script Files: – Compacting JavaScript code can save many bytes of data and speed up downloading, parsing, and execution time. There are many compression tools available in market. Even you can write own small script to minify java script, you just need to rename variable/remove extra space etc.

2. Use advantage of reference types: – JavaScript, much like other C-based languages, has both primitive and reference value types. Primitive types such as strings, Booleans and integers are copied whenever they are passed into a new function; however reference types such as arrays, objects and dates are passed only as a light-weight reference. You can use this to get the most performance out of recursive functions, such as by passing a DOM node reference recursively to minimize DOM traversal, or by passing a reference parameter into a function that executes within an iteration. Also, remember that comparing object references is far more efficient than comparing strings.
Read the rest of this entry »

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 »