Posts Tagged: query
-
Nov 09, 2010
Comments OffHow did I reduce CPU overhead problem caused by MySql?
We were having problem with a project which was shut down in the middle due to heavy traffic. As a technical manager, I was the person who to take charge over the project bring it down to the track. After doing few benchmark test, I came to know that the MySql access from a PHP...
-
Apr 07, 2010
Comments OffHow to get Query as a String in Magento?
Magento as you might know or not! has really a very PIA (Pain in the A**) type of methods to create SQL, execute and fetch! There are two ways of getting SQL from the collection of Magento. Here are the two ways. 1. Only Echoing Query String. For just echoing the query string you must...
-
Apr 07, 2010
Comments OffUsing Custom Query in Magento
Magento has given us very good features to manage Models and Collection for interacting with Database tables. Nowonder, they are very helpful in most of the cases. Yet, we may need to write custom query in some cases (if you need it quick or if you are new to Models & Collection in Magento). But...
-
Apr 07, 2010
Comments OffUsing Custom Query in Magento
Magento has given us very good features to manage Models and Collection for interacting with Database tables. Nowonder, they are very helpful in most of the cases. Yet, we may need to write custom query in some cases (if you need it quick or if you are new to Models & Collection in Magento). But...
-
Apr 06, 2010
Comments OffRedirect to some other location from Model or Observer in Magento
Redirection in...
-
Apr 06, 2010
Comments OffCreating Product Links in Magento Using Custom Query
I’ve already made a post in this blog about Adding Related Product and other links to Product in Magento . But when I used the method to creating links among product’s, while importing very large number of products and creating large number of product links, it took a lot of time and resource. So I...
-
Apr 06, 2010
Comments OffCreating Collection of Objects in Magento using a
Have you ever wondered how Collection in Magento are built, containing array of individual Entity Objects of Magento? Collections are one of the most important data structure (if I am right) used in Magento. Most of the queries in Magento will result into collection, and then you will apply a foreach loop to access individual...
-
Apr 06, 2010
Comments OffGetting Ordered Items and their Detail from Order ID in Magento
Here is a small snippet of code, yet useful, to get ordered items and its details....
-
Apr 06, 2010
Comments OffGetting Customer
Query in Magento can be quite troublesome, if you are a starter..or non-starter. So...
-
Mar 16, 2010
Comments OffHow did I reduce CPU overhead problem caused by MySql?
From last day, We were having problem with a project which was shut down in the middle due to heavy traffic. As a technical manager, I was the person who to take charge over the project bring it down to the track. After doing few benchmark test, I came to know that the MySql access...
-
Mar 03, 2010
Comments OffHow did I reduce CPU overhead problem caused by MySql?
From last day, We were having problem with a project which was shut down in the middle due to heavy traffic. As a technical manager, I was the person who to take charge over the project bring it down to the track. After doing few benchmark test, I came to know that the MySql access...