Tag Archives: Performance

Blog Shifted

13 Sep

Dear Friends,

I got lot of support from you and I am very happy to let you know that Finally I have migrated from WordPress Hosting to own hosted Blog.

Yes, I believe WordPress is the best blogging platform available in market. So I have used wordpress again for my blog.

Here is a link for my New Blog :- http://mukundtechie.com

I request all my followers to visit my site and suggest me, What can be done to make it more interactive and pleasing to see posts.

All your feedback and suggestions are welcomed.

Thanks,

Mukund Chaudhary

New Blog : http://mukundtechie.com

 

How to optimize the performance of a website.

3 Sep

Performance of a web page play a key role in conversion rate of your website. A fast website gets more user automatically. I decided to write on how to make the web pages loads faster.

Optimise performance of website

Optimize performance of website

If your answers is yes then, there are some of golden rule to be followed to make your site loads faster. They are as below:-

Rule 1: Make Fewer HTTP Requests

HTML take 10-20% time only however 80-90% of time spent in making HTTP requests for all the components (images, scripts, stylesheets, Flash, etc.) referenced in the HTML document. Using techniques as below, we can reduces response times of the pages by as much as 50%

  • Image Maps
  • CSS Sprites
  • Inline Images
  • Combined Scripts and Stylesheets

Rule 2: Use a Content Delivery Network
Content Delivery Networks (CDN) is a large distributed system of servers.The goal of a CDN is to serve content to end-users with high availability and high performance.

Rule 3: Add an Expires Header
A web server uses the Expires header in the HTTP response to tell the client how long a component can be cached.In Apace ExpiresDefault is set to 10 year.

Some useful techniques are as below:-

  • Expires Header
  • Max-Age and mod_expires
  • Empty Cache vs. Primed Cache
  • More Than Just Images
  • Revving Filenames

Rule 4: Gzip Components
Compression is a simple, effective way to save bandwidth and speed up your site. Smaller the file, faster it will loads.If you are using Apache, see how it work
Rule 5: Put Stylesheets at the Top
Put all your stylesheets at the top and remove unused content.
Rule 6: Put Scripts at the Bottom
Put script at bottom as anything below the script is blocked from rendering and downloading until after the script is loaded.
Rule 7: Make JavaScript and CSS External
Use external javascript and css as much as possible.

Rule 9: Reduce DNS Lookups
The Domain Name System (DNS) maps hostnames to IP addresses, just as phonebooks map people’s names to their phone numbers.DNS lookups add delays to the initial requests to a host. Making requests to a large number of different hosts can hurt performance.

Rule 10: Minify JavaScript
Always minify your javascript or css. There are various online tools available.(http://minify.avivo.si/#results)

Rule 11: Avoid Redirects
Redirects increase the load time as it has to look up two different address. Try to avoid redirects.

Rule 12: Remove Duplicate Scripts
Duplicacy in code normally happens but it can hurt your performance. So try to remove duplicacy in the code.

This article is based on Steve’s book High Performance Web Sites, published by O’Reilly.]

Cleaning Magento Store’s Database logs for faster performance

23 Aug

As we all know magento is a highly scalable eCommerce system but its database is not as efficient as it should be.It contains log tables and cleaning logs at regular interval will reduce latency of query execution which in turns helps in improving the performance of a system. Magento Store performance depends on various parameters but today we will talk about how to clean the log tables.

magento-log-cleaning

**Click Here to View Larger Image

I strongly recommends you to backup your database before doing anything (as it is always safe to have a backup). There are various techniques to take a back up your database.

  • Free extensions available to on maze store to take the backup.
  • You can use Magento’s built in profilers to export entire database.
  • Use phpmyadmin to take a backup.

Once you are done with the backup of database. you can use these two different options to clean up your logs:

  • Clean your logs via Magento Admin Panel “Log Cleaning”.
  • Clean up your database tables directly via phpmyadmin or through commandline.

Below are the tables used by Magento to manage logs:-

        log_customer
log_visitor
log_visitor_info
log_url
log_url_info
log_quote
report_viewed_product_index
report_compared_product_index
report_event
catalog_compare_item

How to clean logs via Magento Admin:-

  1. Log on to your Magento Admin Panel.
  2. Go to System => Configuration
  3. On the left side under Advanced click on System (Advanced = > System)
  4. Under system you will see “Log Cleaning” option
  5. Fill the desired “Log Cleaning” option values and click Save.

How to clean the logs through Command line or through phpmyadmin:-

  1. Open the database you are using for your store.
  2. Open the tables as stated above and truncate them.

Note:– Truncate means you are only deleting the values from the tables. Structure remains same. Never drop any table.

You are all done. You can also write a script to truncate the values of this tables on regular interval by putting it in cron. I will explain that in my next post.

Happy Reading and leave you valuable feedback.

%d bloggers like this: