Magento Import Products Using CSV

Many users have reported issues when trying to import products using the default Import/Export within Magento.
I too have suffered this headache. And I tried to get possible solutions for every issues(here) but!!!
I guess I have to leave it to Magento and just use what Magento is recommending.
Default Magento Import/Export method has so many holes to cover. So…my conclusion for importing and exporting is just using Dataflow – Profiles. And create advanced profiles for needs.

So I am going to post my custom profiles that can solve numerous default Import/Export problems.

In this post, I will show how to bypass image importing problems which include “Image’s not saving as base, thumb or small”

Optimizing Database

There are lots of articles about how to optimize your app’s database. But I haven’t seen actual tricks that you can use on your applications / websites.

There is pretty good starting article on Smashing Magazine – “Speeding up your website’s database“. I love Smashing’s contribution to the webdev community, but this article is a bit longer and more basic at the same time.

I DO understand the need for simplicity because of the wide audience of Smashing Magazine, but I’d wish they’d give something more than the absolute basics you could find in almost any other site out there. I also think there is a better approach on some of the methods mentioned there for profiling (or the code itself), so here is my quick thought to optimizing database performance. Which you can actually apply to your code.

Before thinking about optimizing :
Updating mysql server version (the more recent, the better/faster/stronger) using stored procedures, that spare multiple successive connections to the server, and their inherent costs

Instagram Load Balance Stack

Here’s some interesting info (a year old) on what Instagram’s running.

Surprises!
Since Yahoo proves that PostgreSQL can handle enterprise level of big data, PostgreSQL wasn’t surprise for me. BUT this…

Every request to Instagram servers goes through load balancing machines; we used to run 2 NGINX machines and DNS Round-Robin between them. The downside of this approach is the time it takes for DNS to update in case one of the machines needs to get decomissioned. Recently, we moved to using Amazon’s Elastic Load Balancer, with 3 NGINX instances behind it that can be swapped in and out (and are automatically taken out of rotation if they fail a health check). We also terminate our SSL at the ELB level, which lessens the CPU load on NGINX. We use Amazon’s Route53 for DNS, which they’ve recently added a pretty good GUI tool for in the AWS console.

Introduction to Callbacks – Node.js

This is the most important topic to understand if you want to understand how to use node. Nearly everything in node uses callbacks. They weren’t invented by node, they are just part of the JavaScript language.

Callbacks are functions that are executed asynchronously, or at a later time. Instead of the code reading top to bottom procedurally, async programs may execute different functions at different times based on the order and speed that earlier functions like http requests or file system reads happen.

The difference can be confusing since determining if a function is asynchronous or not depends a lot on context. Here is a simple synchronous example, meaning you can read the code top to bottom just like a book:

var myNumber = 1
function addOne() { myNumber++ } // define the function
addOne() // run the function
console.log(myNumber) // logs out 2

" But only in their dreams can men be truly free. 'Twas always thus, and always thus will be. "- John Keating