Solved

Magento Indexing

Posted on 2016-08-11
1
96 Views
Last Modified: 2016-08-16
What i don't understand is that the indexing is supposed to run as a 'background' process, but reindexing is also done when an individual change is made , why does it need to run in the background as well and how does it run unless on a cron job as php is not multi-threaded? (The docs claim it happens in the background automatically althouth that maybe we with Enterprise docs and the cron jobs run without being set up, maybe??)
0
Comment
Question by:Silas2
1 Comment
 
LVL 16

Accepted Solution

by:
Lucas Bishop earned 0 total points
ID: 41757055
I'd add some SQL topics to this question to get the DBAs in here. Magento uses the EAV data model.

I believe the way it's structured, causes tables to be dropped and rebuilt when you make changes. If you have a huge store (ex. 10k items), the rebuild process can take hours to complete. These rebuilds are managed by MySQL triggers afaik.

Magento also recommends setting up the indexing to be handled via cron, if you have multiple admins changing the store data at the same time.
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
hosting images 4 29
Help with query 3 25
Connection to multiple databases 13 19
specific navigation button disappears on mobile devices 1 15
Any business that wants to seriously grow needs to keep the needs and desires of an international audience of their websites in mind. Making a website friendly to international users isn’t prohibitively expensive and can provide an incredible return…
Boost your ability to deliver ambitious and competitive web apps by choosing the right JavaScript framework to best suit your project’s needs.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question