Magento Indexing : Simple explanation

– In magneto, there is only database level indexing in spirit.

– Process of denormalization to allow faster operation of site.

PRODUCT
——-
product_id INT
sku VARCHAR

PRODUCT_ATTRIBUTE_VALUES
————————
product_id INT
attribute_id INT
value MISC

PRODUCT_ATTRIBUTES
——————
attribute_id
name

– Generate big table from beginning.
– So, queried from a single table.

– When you re-index, you are blowing up the old table and generating it again.

– Look up table are the magneto “indexes”

– So, for price of product if you query “catalog_product_index_price” instead of “catalog_product_entity_decimal”.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s