Archive for the ‘General’ 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.


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?

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…)

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


Lately, I’ve been wondering what it really takes to become a popular blogger. Is it a fair luck game or is it that only people who can push in lots of capital can become famous. I’ve been searching for answers for almost two years now. Here are some of the quickest and most adorable answers I found. The ideas are taken up from a lot of blogs around the web and I am indebted to those blogs for being there. They have changed my life forever. Follow these 101 tips and you’ll master the art of creating popular blogs. The techniques are around and have evolved all these years. This is the right time to learn the real meaning of blogging and how to stand out as a blogger. I’ve also listed some of the most wonderful blogs that I read everyday. Visit them and learn for yourself that techniques described in 101 lists are actually put into practice by these blogs. Philosophies First

1. Keep patience with blogging – nothing happens instantly

2. Do your best every time – no matter what time it takes

3. Don’t quit – If you quit, you’ll never know how far you could have reached

4. If you don’t know something, learn it.

5. Keep changing from time to time – adopt with latest things around the web. (more…)

As we close the book on 2009, I want to remind you that at the beginning of each year, you have an opportunity. An opportunity to step your game up to the next level. An opportunity to branch out from the same, hum-drum development you’ve been doing for the last 5 years. This article is a list of possible New Year’s resolutions for you, as a developer, to consider. I’m not suggesting you try to achieve all of these, rather I want you to pick one, and commit to it for 365 days. Write it down and stick it your monitor. Keep it in your wallet. Most importantly, keep it on your mind. (more…)