Sushant Danekar's Technical Stuff

How slow your website is Check with this tool Yahoo! YSlow

Sushant Danekar — Tue, 21 Sep 2010 11:34:31 +0000

Yahoo! YSlow

YSlow analyzes web pages and suggests ways to improve their performance based on a set of
rules for high performance web pages. YSlow is a
Firefox add-on integrated with the
Firebug web
development tool. YSlow grades web page based on one of three predefined
ruleset or a user-defined ruleset. It offers suggestions for improving
the page’s performance, summarizes the page’s components, displays
statistics about the page, and provides tools for performance analysis,
including Smush.it™ and JSLint

My Simple Rules for Speeding Up Websites.

Sushant Danekar — Mon, 23 Aug 2010 14:59:38 +0000

Now a days website users are Impatients. Users can hit close button or refresh button if your website loading take more than a half minute.

I have my own set of rules for speeding up the thjings.
Have a look below for the list.

Images.

I noticed how many people don’t optimize their images properly, which results in extremely slow loading time. When you intend to publish your images online, you have to comprimise the quality — just face the fact you cannot use a 100KB image on a website layout. It’s not fair to your visitors.

Adding too many images in the design of webpages is just a making the site heavy.
Use less number of images and optimise the images for website. Adobe PhotoShop and Microsoft Picture Editor can be helpful for Resizing images to web-safe environment. Use Photoshop’s Save for web… option.

Also there is one myth about changing the image format. Just changing the image filename extension is not the really the format changin procedure. So use softwares to resize and reformat images.

Images are of different format See this link to know more about image formats its compression and quality.
(link);

Place Css should be at the TOP

1) All your css should be called very first. This means put your link tags at the top in the head section. If css gets loaded first, its easy for browser to render the page with styles defined in css. So its a cool logic. Its like giving a bluprint to designer very first before explaining.

Use Simple Layouts. Use uncomplicated tags. Avoid complex table structures.

Webmaster tries to make website look extraordinary and effective design. If design is cool and its code is complex browser actually takes time for drawing your design.
Making designs in only in DIV tags allow great speed to browsers.

Use Simple web colors OR use single rollover image.

Try to use web colors or small sized images. Most of the time only one image is loaded and same is used with different cordinate and dimensions. Have a look here
http://www.vision.to/images/articles/buttons_tabs2.png or read this article

Seperate files for Java Script and CSS.
This is very traditional method. But if developer is impatient he tries to find out the shortcut. So just create .js and .css files.
Inlined script and css are getting downloaded everytime..where as .Js and .css files are cached by browser.

These are some basic things. More detailed article can be viewed here
From Yahoo.com

A content delivery network CDN

Sushant Danekar — Fri, 30 Jul 2010 13:47:24 +0000

A content delivery network (CDN) is a collection of web servers distributed across multiple locations to deliver content more efficiently to users. The server selected for delivering content to a specific user is typically based on a measure of network proximity. For example, the server with the fewest network hops or the server with the quickest response time is chosen.

Altarnate Row Colors In HTML with CSS 3

Sushant Danekar — Tue, 27 Jul 2010 13:46:50 +0000

All Developers all Designer already know about this concept.

Reading the HTML Table become easy when rows are colored alternately.

You may be wondering how this article have something new and different about coloring table odd and even table rows with css3.

CSS3 do the magic and it will allow designer to define the color for odd numbered element and even numbered element.

Look at the following code and its output

<!DOCTYPE HTML PUBLIC “-//W3C//DTD HTML 4.0 Transitional//EN”><html><head><title> New Document </title><meta name=”Generator” content=”EditPlus”><meta name=”Author” content=””><meta name=”Keywords” content=””><meta name=”Description” content=””><style>tr:nth-of-type(odd) { background-color:#ccc;} </style></head><body><table> <tr> <td>test test test</td> <td>test test test</td> <td>test test test</td> <td>test test test</td> </tr> <tr> <td>test test test</td> <td>test test test</td> <td>test test test</td> <td>test test test</td> </tr> <tr> <td>test test test</td> <td>test test test</td> <td>test test test</td> <td>test test test</td> </tr> <tr> <td>test test test</td> <td>test test test</td> <td>test test test</td> <td>test test test</td> </tr> <tr> <td>test test test</td> <td>test test test</td> <td>test test test</td> <td>test test test</td> </tr></table> </body></html>

HTML 5 and Audio, Video, Made easy

Sushant Danekar — Sat, 24 Jul 2010 07:53:46 +0000

How it will be if you have a simple tag Called and with just a simple Src parameter as we have in tag…

HTML 5 comes with this tags. Now onwards it will be easy for HTML designer to Add Videos and Audios.

The Audio Video Tags are interested because JavaScript Developer can Perform some operation and invoke some methods and events !

The details of HTML 5 and Audio Tag is here

http://dev.opera.com/articles/view/html5-audio-radio-player/

Image Resizing Made Easy. Smart script

Sushant Danekar — Tue, 06 Jul 2010 11:35:45 +0000

Image resizing is big trouble for every project.

I found a perfect script which almost cover every aspect of a developer.

http://github.com/maxim/smart_resize_image/

This script re-size as per given WIDTH and / or HEIGHT.

Output is in FILE as well as in TAG ( image object )

Following are the features..

* If you pass width as 0 (zero) — this function will disregard width, and use height as constraint. Same vice versa. * If you set “proportional” to false – the function will simply stretch (or shrink) the image to its full constraints. * If one of the dimensions is set to zero, and proportional set to “false” – then the image will be forced to stretch or shrink the other dimension, and disregard the zeroed dimension (leave it the same). * If proportional is set to true – the image will resize to constraints proportionally, once again, with possibility to have either width or height set to zero. * The function can use either linux “rm” command, or php @unlink. Most probably you don’t need to ever use that flag, but on some setups – @unlink won’t work due to user access restrictions. * The function will simply replace the file that you give it, with the resized file. * The function supports gif, png, and jpeg, and preserves the transparency of gif and png images. * Tested on GD version 2.0.28 only.

Enjoy Smart Image Resizing ..

Regards
Sushant Danekar

MySQL Order By Floating , integer ,Numbers

Sushant Danekar — Wed, 28 Apr 2010 14:00:26 +0000

Say we have 5 (five) records in the database table with the following
values in the “price” field/column.

19.99
125
5.99
199
300

Execute this query ..

SELECT
* FROM `table` ORDER BY `price`
ASC;

If your result looks like in following list, you need my help

125
199
19.99
300
5.99

Use following query if your result comes in this way..

SELECT * FROM `table` ORDER BY ABS(`price`) ASC;

Thanks and Regards
Sushant Danekar

MySQL Query Cache

Sushant Danekar — Wed, 28 Apr 2010 07:55:04 +0000

MySQL Query Cache

Will MySQL supports Query Caching?

The answer is “YES”

MySQL supports query caching if done some changes in the configuration file my.ini

Under [mysqld] section you can add,

query_cache_type
= #query_cache_value#

#query_cache_value # can be any of the following,

query_cache_type = 0 => Caching is disabled

query_cache_type = 1 => Caching is enabled for all queries

query_cache_type = 2 => this requires adding the keyword SQL_CACHE to the queries that are to be cached

If defined “query_cache_type = 2”, then caching will be enabled for the queries which is mentioned SQL_CACHE in it.

SELECT SQL_CACHE column1, column2 FROM table_name;

SELECT SQL_CACHE name, age FROM employees;

For more information, Pls visit http://dev.mysql.com/doc/refman/6.0/en/query-cache.html

How do I add my PHP directory to the PATH on Windows?

Sushant Danekar — Mon, 12 Apr 2010 09:41:32 +0000

How do I add my PHP directory to the PATH on Windows?

On Windows NT+ and Windows Server 2000+:

Go to Control Panel and open the System icon (Start ->
Settings
-> Control Panel -> System, or just Start -> Control
Panel
-> System for Windows XP/2003+)
Go to the Advanced tab
Click on the ‘Environment Variables’ button
Look into the ‘System Variables’ pane
Find the Path entry (you may need to scroll to find it)
Double click on the Path entry
Enter your PHP directory at the end, including ‘;’ before (e.g.
;C:\php)
Press OK

More information is here OR

http://www.php.net/manual/en/faq.installation.php#faq.installation.addtopath

Cross Table Delete with MySQL

Sushant Danekar — Mon, 12 Apr 2010 07:52:26 +0000

Cross Table Delete with MySQL

DELETE product.* FROM product p LEFT JOIN productPrice pp ON p.productId = pp.productId WHERE pp.productId is null

THIS IS POSSIBLE

Deleting records with MySQL can be done by referencing records in
another table by joining them together. This is useful if you need to
delete data from one table based on the values in another, or if you
want to delete records from one table where there are no associated
records in the second table. Note that although the examples in this
article show joins between two tables you can join three, four or more
tables if required.

Using a join to delete records in MySQL is only possible with version
4.0 or higher. Unfortunately this is not possible using earlier
versions of MySQL, ie 3.23 and earlier.

With MySQL you can do a cross table delete in one of two ways. The
first is to use commas with an implicit inner join like in the example
below. In these examples we’re using a product and productPrice table
where product info is stored in the product table and price information
in the productPrice table. Each table has a productId field which is
what we’ll be joining them on.

With MySQL you can do a cross table delete in one of two ways. The first
is to use commas with an implicit inner join like in the example below.
In these examples we’re using a product and productPrice table where
product info is stored in the product table and price information in the
productPrice table. Each table has a productId field which is what
we’ll be joining them on.

DELETE product.*, productPrice.* FROM product p, productPrice pp WHERE p.productId = pp.productId AND p.created < '2004-01-01'

Note that you don’t necessarily need to delete all records from all
tables in the query. The example above could just delete from the
productPrice table by changing the first line to delete product.*.

You can also use a left join to delete records using MySQL. An
example of this is using our product and productPrice tables below,
where we are deleting all the records from the product table where there
is not an associated record in the productPrice table.

DELETE product.* FROM product p LEFT JOIN productPrice pp ON p.productId = pp.productId WHERE pp.productId is null

When testing these queries on a test database to make sure they actually
executed I discovered it appears you cannot use the alias names for the
data to delete (eg delete p.*) otherwise you get the error
error 1066 not unique table/alias. To fix this error type
in the full table name instead of the alias.

Source Document is here