Solved

Magento Indexing

Posted on 2016-08-11
1
87 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

SSL stands for “Secure Sockets Layer” and an SSL certificate is a critical component to keeping your website safe, secured, and compliant. Any ecommerce website must have an SSL certificate to ensure the safe handling of sensitive information like…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
The purpose of this video is to demonstrate how to set up the WordPress backend so that each page automatically generates a Mailchimp signup form in the sidebar. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

930 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now