Solved

Magento Indexing

Posted on 2016-08-11
1
115 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 17

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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Learn about the eCommerce marketing trends for the year ahead.
Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

749 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