Archive for the ‘Technology’ Category

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.
(more…)

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?
(more…)

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. (more…)

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.

(more…)

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.
(more…)

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. (more…)

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

(more…)